Stack Overflow
Stack Overflow

Questions tagged [supabase]

Supabase is a combination of open source tools. It builds the features of Firebase using enterprise-grade, open source products. Supabase is not a 1-to-1 mapping of Firebase. Its aim is to give developers a Firebase-like developer experience using open source tools.

Supabase has official JavaScript library as well as community built C# and Python library.

Supabase is composed of four components

  • Database
  • Authentication
  • Storage (coming soon)
  • Functions (coming soon)
16 questions
3
votes
1 answer

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 table, set REPLICA IDENTITY using ALTER TABLE.", …
Shorn
  • 13,549
  • 11
  • 63
  • 124
3
votes
1 answer

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 ( name ) `) But how do I know this works every time when…
dshukertjr
  • 8,227
  • 6
  • 33
  • 73
2
votes
1 answer

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.VITE_SUPABASE_URL, …
amatur
  • 23
  • 4
2
votes
1 answer

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.com/edit/supabase-angular-example Now I get the following…
lucky 7
  • 33
  • 4
2
votes
3 answers

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 Supabase?
dshukertjr
  • 8,227
  • 6
  • 33
  • 73
1
vote
0 answers

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 score and query the list of products based on…
Charles de Dreuille
  • 155
  • 1
  • 8
0
votes
0 answers

Designing realistic game inventory system using SQL

after years learning from Stack Overflow, this time i didn't find the answer. Currently I'm student and I'm trying to design a realistic game inventory system for a side project. I need your knowledge to find the best way to do this. Realistic game…
ethicnology
  • 1
0
votes
2 answers

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 in his name, Project X and Project Y. Now each…
Subhendu Kundu
  • 2,880
  • 3
  • 14
  • 41
0
votes
1 answer

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 export named 'createClient' However, I can…
amatur
  • 23
  • 4
0
votes
1 answer

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 think it has something to do with Prisma, which I…
rdavis
  • 13
  • 3
0
votes
0 answers

How to create chat email notifications

I'm trying to find the best way to build email notifications for an app with a chat component. To give a bit of context, we have a list of occasions in our app with a chat per occasion. We would like to send email notifications to notify the user…
Charles de Dreuille
  • 155
  • 1
  • 8
0
votes
1 answer

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 database is open to anyone, as long as you use any valid…
Tagas
  • 1,114
  • 9
  • 24
0
votes
1 answer

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 orders of each day. This is how my table looks…
Hadi azeez
  • 49
  • 6
0
votes
0 answers

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 hosted on Vercel. The part I'm struggling with…
Charles de Dreuille
  • 155
  • 1
  • 8
0
votes
1 answer

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 from database. What is the solution for me…
kelly
  • 15
  • 3
1
2