Stack Overflow
Stack Overflow

Questions tagged [supabase-database]

Supabase is a database solution powered by PostgreSQL. Under the hood, Supabase uses PostgREST, an open source tool to make automatically create REST API for PostgreSQL databases. Supabase utilizes row level security feature on top of PostgREST to provide authorization. Use this tag when you are having problems, and not to ask for new features.

Supabase Database is a component of Supabase that automatically creates RESTful APIs for your Supabase database backed by PostgreSQL. Under the hood, Supabase uses PostgREST, an open source tool to create REST APIs for your PostgreSQL database. Supabase utilizes row level security feature on top of PostgREST to provide authorization. Use this tag when you are having problems, and not to ask for new features.

Supabase Database comes with:

  • intuitive table editor
  • clients in various languages to communicate with the database
  • SQL editor to easily run SQL on your database
330 questions
0
votes
1 answer

Not able to use Supabase Hook to read data from database into react-table with react-query

This is the error I get : TypeError: observer.getOptimisticResult is not a function I'm trying to work with React-Query and Supabase to read data into a React-Table. I've created a useReadData.ts hook as shown below: export default function…
Reuben Rapose
  • 157
  • 2
  • 8
0
votes
1 answer

Supabase JS missing "DELETE" event

Here is a snippet of my code const subscription = supabase .from(`messages:channel_id=eq.${props.channelId}`) .on('INSERT', payload => addMessage(payload.new)) .on('UPDATE', payload => updateMessage(payload.new)) …
KleFaCh
  • 1
0
votes
2 answers

Flutter FutureBuilder using Supabase query

I'm unable to get Supabase queries working with flutter. Here is an example of the code: child: FutureBuilder>( future: supabase.from('products').select().execute(), builder: (context, snapshot) { if…
Jake Anderson
  • 309
  • 1
  • 4
  • 18
0
votes
1 answer

how to stream my data from supabase to the flutter app

I'm trying to stream a tables data into my flutter app, but I keep getting some errors. I'm trying to do it as I would do it with Firebase but with no success :( Can someone point out what is it that I'm doing wrong here? My db: My service: import…
NiiTii
  • 237
  • 6
  • 25
0
votes
1 answer

How to authenticate with another auth provider using Supabase?

I'm making a website that can basically read and write data to a Supabase database. It's using FluffyScratch auth. FluffyScratch isn't supported by Supabase so I need to implement an authentication solution. I did a search and I found out that…
webdev03
  • 5
  • 1
  • 5
0
votes
1 answer

What is the idiomatic way of having PUBLIC and PRIVATE FUNCTIONS in Postgresql?

Please, I am working on a PoC in supabase(PG 13.3) in my free time, and although I am breaking the main functions into smaller functions (for reuse purposes), I want the applications/clients to only have access to three of them ("public" functions).…
jfbaro
  • 301
  • 2
  • 10
0
votes
2 answers

How to connect ASP.NET Core 5 MVC project to Supabase database instead of SQL Server?

I'm new to developing Dot Net projects and I've spent most of my time developing small projects with React, Next.js, and Vue.js alongside Supabase for the database. In the ConfigureServices method, I see tutorials use options =>…
Ender91
  • 61
  • 1
  • 8
-1
votes
0 answers

Flutter/Supabase - delete master if all child records deleted

I have a Supabase database where a master 'Booking' table is linked to a child 'Events' tables, where a booking can have multiple events. My app allows the booking to be deleted, and I have set up a cascading association so that when the booking is…
user2868835
  • 1,250
  • 3
  • 19
  • 33
-1
votes
1 answer

How to create a sequence for integers in PostgreSQL?

I'm trying to create a sequence for a product id to start at 100 in Supabase SQL editor and I'm getting this error: Failed to validate SQL query: syntax error at or near ")" What am I doing wrong in this code? create sequence product_id_seq …
Mintee
  • 505
  • 4
  • 22
-1
votes
1 answer

Does anyone who has experience with loading GA4 log data to Supabase database?

I work as a growth marketer in a startup. For various growth marketing activities, I'm using raw data by linking GA4 and Big Query. By the way, my company is trying to build a user's DB called Service Log into a database provided by a place called…
Mark Kim
  • 1
-1
votes
2 answers

How to stop supabase which is running on localhost 3000?

I wanted to know what supabase is so I installed it using this local development guide enter link description here it was few weeks back, i was simply checking port 3000 and supabase is running i have removed all supabase related folder but still…
Karna04
  • 21
  • 2
-1
votes
1 answer

How to get total likes count of a post from supabase backend?

I have two tables one for post and one for likes. Post table stores all the post information. Likes table has 3 columns id, post_id user_id Now I need help to figure out how to get total number of likes of each post through supabase query. I am…
Agraj Yadav
  • 27
  • 6
-2
votes
0 answers

Golang defer db.close() undenified (has no field or method)

I have below code its giving undefined error on the defer db.close(). unsure how to fix this error. Any help to resolve this error? error run code : ./main.go:24:11: db.Close undefined (type *gorm.DB has no field or method Close) code : package…
Anugerah Bayu Pratama
  • 5
  • 2
-2
votes
3 answers

Flutter Supabase - Join Tables

I have 2 tables Department(id, department_name) Programs(id, program_name, department_id) dept_id in Programs is the foreign key from Department table I want to join department_id in Program table and id in Department table I'm unable to do it in…
Akash Punagin
  • 17
  • 1
  • 6
-3
votes
1 answer

Scrapbook Application with Content/Template Types (text, video, image, etc) Schema

Wondering the best way to architect a scrapbook application that has different content types/templates: Text, Video, Image, Gif etc. A page can contain any number of content types ex: A Collage Template can have 3 images, a video, and some text on…
user433575
  • 357
  • 1
  • 4
  • 13
1 2 3
…
21
22