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
451
questions
0
votes
0
answers
35
views
How can I fix this RLS policy issue with Supabase on .insert()?
I am in the process of creating a habit tracking app and am using Supabase PostgreSQL. I am implementing RLS in the habit table but cannot for all that is good figure out this issue. On the click of ...
0
votes
1
answer
17
views
How to do Join on composite key with postgREST?
I am struggling to find the right syntax to perform a (nested) join on on composite foreign keys.
For example, my tables are
CREATE TABLE post (id TEXT PRIMARY KEY, userId TEXT REFERENCES user(id), ...
1
vote
0
answers
16
views
Session null on next Middleware with supabase getUser
I got my session in the localStorage, but when I try to access the data in Middleware of Next, auth.getUser() is equal to null, and I dunno how to fix it.
enter image description here
enter image ...
0
votes
0
answers
17
views
Order by computed column in graphql supabase
Is it possible to order by a computed column with graphql ? Assuming to this discussion, it is possible with supabase client API call : https://github.com/orgs/supabase/discussions/7875
But I would ...
0
votes
0
answers
20
views
AWS Lambda/S3 Bucket to Supabase
I have a parquet file created in an AWS lambda function. The lambda function takes an xlsx file and reformats/fixes/edit column headings, etc it, and produces a parquet file, sending it to an AMS S3 ...
0
votes
0
answers
13
views
Supabase SQL: Allow company owner to access all employee data while restricting employees to their own data
I'm developing a Next.js application with Supabase as the backend. I need to implement Row Level Security (RLS) policies that allow a company owner to view and manage data for all employees in their ...
0
votes
0
answers
17
views
Massive data import from remote CSV file using COPY command within a Edge Function
Im trying to achieve a massive data insertion (about 50.000) from a CSV file uploaded into Supabase Storage from the frontend, and process data inside a Serveless Supabase Edge Function, trying to ...
1
vote
0
answers
42
views
How to seed local DB from remote supabase DB
I have a supabase database. I've been doing development locally by directly connecting to the remote DB. I want to move to a local dev environment for the DB so that my remote DB does not get impacted....
0
votes
0
answers
24
views
ImproperlyConfigured` Error When Deploying Django to Vercel with Supabase PostgreSQL
I'm currently trying to deploy my Django project to Vercel, using Supabase as the PostgreSQL database provider. I have separated my settings into base.py, development.py, and production.py to manage ...
0
votes
0
answers
20
views
Transform a table of Data imported from a CSV in Supabase
I import a .csv file with x number of rows directly into a table within Supabase. All the fields at this point are text and a number of columns have repeating data.
I'd like some advice on how to read ...
0
votes
1
answer
33
views
Supabase terminating connection and not able to load schema
I am currently working on a project and using nextjs, postgres+ prisma.
I used Supabase to create databse and used the link in my .env to connect the databse with my prisma schema.
When I am running ...
0
votes
0
answers
42
views
Supabase Query Date Compare
Recently try to fetch data by comparing date (from flutter) to supabase which is form of (year, month, day) 2024-06-22 by this snippet =>
date = '2024-06-22'
final res = await supabaseClient
...
0
votes
0
answers
26
views
Column already exists when running local migration
I am running supabase locally
I have been using the Studio to create tables and their columns
I have been pushing the latest migrations up with supabase db push
When I run supabase migration up, I ...
0
votes
0
answers
12
views
Supabase querying by email in Flask application using supabase_py
Querying Supabase 'users' table with the 'email' column returns empty data, but changing the value of the column as well as the value to match it to, into a normal text and not a email format such as '...
1
vote
1
answer
43
views
NextJS 14 & SupabaseAuth, SupabasePostgres
Firstly I am a Full Stack Bootcamp Graduate and just trying to get my head into NextJS, so this might be newbie questions here.
Now I am using a NextJS TypeScript template and using Supabase for ...