Questions tagged [supabase]
Supabase is a collection of open source tools to build modern apps quickly and efficiently. It utilized Postgres database to power its Auth, Database, and Storage features. Use this tag when you are having problems, and not to ask for new features.
62
questions
6
votes
1answer
2k views
How to query using join in Supabase?
In Supabase documentation, it explains this as how you would "join" tables to get data
const { data, error } = await Supabase
.from('countries')
.select(`
name,
cities (
...
4
votes
1answer
722 views
How can I send secure API requests from SvelteKit app, without showing API keys on the client side?
I'm using Supabase for a new Sveltekit app, with this template
Currently, I'm passing the Supabase keys through on the client side, like this:
const supabase = createClient(
import.meta.env....
4
votes
1answer
122 views
Supabase third party oAuth providers are returning null?
I'm trying to implement Facebook, Google and Twitter authentication. So far, I've set up the apps within the respective developer platforms, added those keys/secrets to my Supabase console, and ...
3
votes
3answers
794 views
How to get "COUNT(*)" in Supabase
I want to retrieve row count in Supabase.
I am guessing it would be something like this:
const { data, error } = await supabase
.from('cities')
.select('name', 'COUNT(*)')
Is this possible with ...
3
votes
1answer
560 views
Cannot update Supabase table because it does not have a replica identity
When trying to my first table update using Supabase, with code like:
await db.from("welcome").update({visit_count: newCount});
Got error:
{
"hint":"To enable updating the ...
2
votes
1answer
81 views
Ionic5 App connection to SupaBase gives "process is not defined"
Hello I have the following problem:
I wanted to test a few small things with the "new" SupaBase service.
I have also implemented everything using an example angularapp.
https://stackblitz....
2
votes
1answer
121 views
Supabase Self Hosted responded with 404
I've tried following the guide provided on supabase:
https://supabase.io/docs/guides/self-hosting
I went with Option 1 & 2 in which both resulted in the same error 404 when I try to reach ...
2
votes
0answers
81 views
How to sign in with Apple and Google credentials in react-native and supabase
I have been trying to implement sign in with google and apple using the following libraries and supabase in bare react-native projects.
react-native-apple-authentication
react-native-google-signin
...
2
votes
0answers
45 views
Create a ranking mechanism like Algolia
I'm creating a platform to search products based on certain filters. Let's say I have filters A, B and C and a database of around 20,000 products. What I'm trying to build is a way to create a ranking ...
1
vote
1answer
297 views
Count the occurrences of DISTINCT values using supabase
I want alternative supabase code for this SQL command
SELECT order_date,COUNT(*) as count
FROM orders
GROUP BY order_date
ORDER BY order_date Desc;
What I am trying to do is, I want the number of ...
1
vote
0answers
86 views
Complex query with parameters in SUPABASE
I would like to create this except query in supabase, but with parameters in the day column. For example:
CREATE VIEW employees_without_registering AS
SELECT employees.id
FROM employees
EXCEPT
...
1
vote
0answers
54 views
Loading images from Firebase is very slow [closed]
I am using Firebase for my android application. I am using different services of firebase like Firebase Auth, Firestore, Cloud Functions, and Cloud Storage. Apart from Firebase storage, everything ...
1
vote
0answers
41 views
parts of function after supabase data retrieval/upload not working until button is pressed a second time
I am trying to make an electron app and have it upload to a supabase database from an HTML form. The HTML part works just fine, and running the correct function in a separate file works just fine as ...
1
vote
1answer
667 views
When deploying Sveltekit app to Netlify, build breaks with error '@supabase/supabase-js' does not provide an export named 'createClient'. How to fix?
When I try to deploy a SvelteKit app with supabase to Netlify (using adapter-netlify), the Netlify build fails with the following error:
requested module '@supabase/supabase-js' does not provide an ...
1
vote
2answers
380 views
Supabase client permission denied for schema public
Whenever I've try to use @supabase/supabase-js to query the db, I get an error.
error: {
hint: null,
details: null,
code: '42501',
message: 'permission denied for schema public'
}
I ...
1
vote
0answers
129 views
Converting a Uint8Array into a file I can save in Supabase
I'm creating a Figma plugin that will convert a frame into an image that I want to save into Supabase storage. I successfully exported a Uint8array from Figma and sent it to an API I made using Nextjs ...
0
votes
1answer
92 views
How to use socket hooks with Stream Builder
I want to use real-time data and StreamBuilder with the package called realtime_dart because of my BaaS. Supabase uses this package so I need it too as well. But I don't know how to use Socket hooks ...
0
votes
2answers
89 views
Add stipe stripe subscriptions for different projects of each user
The use case I am working on which is common but I need some suggestions to visualize it.
Each user can have multiple projects to which they can subscribe to.
So for example, the User has two projects ...
0
votes
1answer
19 views
Possible to restrict PostgreSQL security definer function to RLS use?
I am using RLS (Row Level Security) with supabase.io for a "serverless" application. I have to use various security definer functions for RLS policies. These are still callable through ...
0
votes
1answer
50 views
How to access route parameter inside getServerSideProps in Next.js?
I want to query my Supabase table using the ID in the slug e.g. localhost:3000/book/1 then show information about that book on the page in Next.js.
Table
book/[id].js
import { useRouter } from 'next/...
0
votes
1answer
20 views
possibility of having a Like operator inside of the IN operator
Hoping this is the right tag to ask this question. Posted it before on a couple of forums, havent got the answer yet.
Below is a query copied from the supabase website.
const { data, error } = await ...
0
votes
2answers
142 views
Supabase update with row level policies
I am not able to update a row which has role level policy enabled
My table has row level policies on insert and update as follow :
create policy "Allow individual insert access" on public....
0
votes
1answer
186 views
Supabase: how to query users by eMail?
I'm using Supabase in a Node JS middleware. I am developing an invite function thats receives an eMail address of an existing supabase user via a REST Endpoint. Now it should query the users table in ...
0
votes
1answer
38 views
Supabase - Policy based on subscription type
I'm quite new to Supabase and PostgreSQL and have stumbled upon a question. If I'm creating a Todo app where people should be able to sign in and depending on subscription type (regular users or pro ...
0
votes
1answer
57 views
Supabase with React Full Register / Login / Account website
I'm new to React and Full Stack, And I wanted to us Supabase as Database with Postrgree and i thought if i could make full registration form and In this case do i need to use Node, Express or ...
0
votes
1answer
56 views
How To Extract Value From A Promise And Display It In React?
I am building a React app with Supabase as my backend. I'd like to display the contents from several of my supabase tables, in React. However, I am pulling that data with a promise and I am unsure of ...
0
votes
1answer
148 views
Supabase / PostgREST: Deny select multiple
I am bulding a supabase app. Instead of a login every user gets a uuid (or multiple, if he wants to). Everyone that knows the uuid has full acces to the data behind this uuid.
So basically the ...
0
votes
1answer
503 views
NextJS getServerSideProps pagination
I am using NextJS and Supabase for database. I am not sure how to use pagination here. Because the solution I am looking is passing query to the API. I cant do that because I am directly fetching it ...
0
votes
1answer
9 views
"Uncaught Error: More than one relationship was found" with Supabase client query
I'm building a multitenant app and running into an error after adding multiple relations that point to the same table:
Uncaught Error: More than one relationship was found for teams and users
When ...
0
votes
0answers
11 views
delete associated records in Supabase
When using Supabase, is there a clean / simple way in which I can delete all associated records together with an item? Say I have Posts and a Post can have many Comments. When I delete the Post I want ...
0
votes
0answers
13 views
Prisma <> Supabase - bind message supplies 1 parameters, but prepared statement \"s1\" requires 2
I am trying to integrate SupaBase with Prisma. When I try to insert any records I am getting the following error
Error occurred during query execution:
ConnectorError(ConnectorError { ...
0
votes
0answers
7 views
Supabase direct connect from IntelliJ: connection refused [duplicate]
Using PostGreSQL driver 42.2.22, which seems auspicious. However…
I've got this JDBC URL
jdbc:postgresql://db.xovybkwerwgbupdibonb.supabase.co:5432/postgres?user=postgres&password=[YOUR-PASSWORD]
[...
0
votes
1answer
26 views
Is there a way to perform full text search on multiple columns on Supabase with Javascript?
I've tried using many symbols to separate columns; ||, |, &&, & with and without spaces.
For instance
.textSearch("username, title, description", "...");
.textSearch(&...
0
votes
0answers
26 views
Supabase policies on getServerSideProps - Next.js
I'm crafting a Trello clone with Next.js and Supabase as a BaaS.
In my Supabase table I have this policies:
Policies are working grate on client side with the following code:
const { data } = await ...
0
votes
1answer
22 views
Supabase set password after email invite
In a Supabase app, I want to invite users (instead of them signing themselves up). I can invite a user with their email, but they get sent a link which directly authenticates them (like a magic link).
...
0
votes
0answers
22 views
Where to store media file of Django on production?
So I am learning Django. And I have made some websites with it. Now I am hosting those to Heroku. I am using free Dyno on Heroku. Also, I am using supabase.io database instead of Heroku's because ...
0
votes
0answers
33 views
I would like to setup authentification with supabase
I am adding a login form to my website https://covid19-virology.netlify.app/admin I am not sure how to
setup Supabase with a bootstrap form.
Github Repo https://github.com/drjoeycadieux/covid-virus
...
0
votes
1answer
47 views
Filtering in join in supabase
Im using supabase with a database which have 2 tables (that are implicates in this issue).
Tables are teachers and users. Both have ID and id_teacher/id_user respectively.
Im working in a query where ...
0
votes
1answer
36 views
Why do my POSTGRES composite key can't accept this input?
I'm creating a table with contents in a Postgres (Supabase) server. This table should have solely the content id.
In another table, I'm storing the translations for this content (i.e. the content id, ...
0
votes
0answers
18 views
How to set Authorization header for Urql client?
I've got a NextJS app where I am implementing Supabase for authentication, and attempting to strip out Apollo with Urql instead.
In my urql.ts file, I am creating the client as such:
import { ...
0
votes
0answers
26 views
How To Create Supabase Table In Flutter?
I want to make a chat application, where every user contains a table.. for that when new users register in the app... I have to create the table in supabase for himself/herself manually from flutter ...
0
votes
0answers
37 views
PostgreSQL NOTIFY and LISTEN not working with Supabase and Dart
I have a Flutter app which communicates with a Supabase project. In Dart, I'm using the postgres package to listen to a channel:
var connection = PostgreSQLConnection(/* connection data */);
await ...
0
votes
1answer
69 views
Issue uploading image file to Supabase storage with Flutter
I'm having an issue with uploading an image to Supabase storage from my Flutter app.
Basically the upload works fine however it only uploads a blank image each time.
Here is my code. FYI i'm useing ...
0
votes
0answers
50 views
undefined is not an object(evaluating 'this.localStorage.getItem') error in react-native
I tried to implement supabase with react-native expo app. Then got this error when trying to call a GET API call to get all data from 'Players' table but got an error in localstorage. How to fix this
...
0
votes
0answers
110 views
Firebase auth with supabase jwt token flutter
I am using flutter Firebase auth for authentication I want to use supabase storage with auth and setup security rules for supabase storage supabase dashboard says
Now how can I send jwt token through ...
0
votes
0answers
26 views
Receiving SSL wrong version number error when connecting to API
I'm attempting to connect to the Supabase API for my database. I've attempted to connect using Python client for Supabase and also using Insomnia. Both are giving me an SSL error of sorts.
I upgraded ...
0
votes
0answers
15 views
Get props from external redirect Vue
I am trying to add a reset password functionality to my website via Supabase.
The url that I get from Supabase is like this:
myProjectID.supabase.co/auth/v1/verify?token=x&type=recovery&...
0
votes
0answers
70 views
supabase flutter get multiple data (JSON object requested, multiple (or no) rows returned)
I am trying to print out multiple data from firebase using flutter but it just isn't working
getResponse(String uid) async {
await client
.from("privChatRoom")
.select()
...
0
votes
1answer
57 views
How to Join PostgreSQL JSONB Data with Foreign Table
I have a PostgreSQL database table with a JSONB column that contains keys to a foreign table.
The structure looks something like this.
Events
_ _ _ _
id:uuid
name: uuid
fields: JSONB {
date {},...
0
votes
0answers
20 views
Invalid hook call when trying to implement NextJS + Supabase auth
I'm just trying to get a simple auth flow working with a brand new NextJS app.
Specifically I'm following this tutorial, and I'm stuck on the Building our login interface section.
_app.ts
export ...
