471 questions
0
votes
2
answers
1k
views
Flutter FutureBuilder using Supabase query
I'm unable to get Supabase queries working with flutter. Here is an example of the code:
child: FutureBuilder<PostgrestResponse<dynamic>>(
future: supabase.from('products').select()....
- 341
2
votes
1
answer
4k
views
Is there a ways I can insert large amount of rows faster into my table in Supabase?
This query I made is working, but it's kind of slow, the last time I insert it was over 30,000 records and I have to wait for about an hour or two I guess. And it's a little bit weird that I'm using ...
- 666
3
votes
1
answer
2k
views
Designing a Multi-tenant SAAS Database with Postgres RLS
I want to design a multi-tenant SAAS database with PostgreSQL and RLS. I want to be able to host all users and the tenants in the same database and isolate their data with RLS.
In my use case it makes ...
- 55
8
votes
2
answers
4k
views
PostgREST - Add authenticated user id on insert
I need to automatically add an author of an inserted row in one of its columns. I am using postgREST (using Supabase cloud service) and I don't want users to add whoever they want as the author. Is ...
- 764
0
votes
1
answer
1k
views
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 ...
- 5
0
votes
1
answer
2k
views
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 ...
- 331
11
votes
3
answers
10k
views
Supabase, filter by column value of foreign key row
I am trying to figure out how to implement a query in supabase:
Schema
CREATE TABLE cars
(
id SERIAL PRIMARY KEY,
brand TEXT
);
CREATE TABLE stores
(
id SERIAL PRIMARY KEY,
car INT ...
- 957
1
vote
2
answers
5k
views
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 ...
- 81
4
votes
1
answer
3k
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 ...
- 5,504
5
votes
1
answer
5k
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(&...
- 55
36
votes
1
answer
58k
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 (
...
- 19.2k