Prisma with Supabase Auth

I created 2 tables, table 2 has foreign key to table 1 both has id primary key auto increment. Then I inserted around 900 rows to both from SQL EDITOR so my id columns is already 900+ Now I am using supabase-py to insert new rows.

supabase.from(table_name).insert(json={'name': 'test'}).execute()

It fails with following error:

postgrest_py.exceptions.APIError: {'message': 'duplicate key value violates unique constraint "model_pkey"', 'code': '23505', 'details': 'Key (id)=(58) already exists.', 'hint': None}

Every time I run the script the primary key in error increments with 1

question about the development flow - it looks like local development doesn't support storage, but the new CLI migration tools don't support two databases in the cloud (e.g. using a supabase.com project as the dev environment). any ideas which direction to choose?

I am pretty sure local development (if you mean docker) does support storage, it is just not available in the studio so you need to use supabase-js or one of the other SDKs to create buckets and such. By default it uses the file system as a storage service in local development but you can use s3 instead.

oh, interesting. ok, i'll give it a try. maybe all buckets are public by default since it's development.

Is it better to have more API calls or more data to search? I'm working on a web directory where we use a lot of metadata (we use Dublin Core). For example, we have a table for authors, subject, geographical coverage, format and types, but since it's a many-to-many relation, we have to create some "link table", right? But, we will have to do more calls to the API to get everything we need to build the web page. In that situation, is it better to get info from 5 different tables or should we create a "relations" table with foreign relations for every table at once (meaning there would be 4 null out of 5 for each row). How do you deal with your many-to-many relationship?

Hi will the Optimized database instances for $50/month help us make our queries faster under heavy load?

Hello guys is this new and not documented yet @supabase/supabase-auth-helpers

Auth helpers

Hi, I have serval project in my account. I wonder Why some projects support more postgres extensions than other

guys can anyone tell me how to get the user id in flutter

this one

Hi! I am trying to setup supabase to evaluate it on a droplet and thought I could use the supabase/postgres repo to install a database locally. Should I be using the ansible playbook to do so? It doesn't seem to run on x86_64 very well (osquery only had arm package defined, now its complaining about CFLAGS even though I see a check for arm and x86_64 version of the task right below it)

is this the right way to go about it if i don't want to run the postgres in a container?

many-to-many

Hi, 👋 , Wondering if there is a way to effectively "deactivate" a user on the supabase auth system; we want to keep the user intact but just stop login.

fwiw, storage does work locally, but only somewhat.

download()

works but

getPublicURL()

doesn't

If you made sure to make your buckets public then you could probably ask in the supabase GitHub discussions about that cause you have a better chance of getting a response from a developer or someone who knows more about supabase storage then me

Hi I am trying to self host supabase and tried to run the docker container

However I am getting this error

Can someone please help, thank you!

Can I see your .env maybe there is something wrong there

Is app.supabase.io open source?

yep: https://supabase.com/blog/2021/11/30/supabase-studio

not all the functionality of app.supabase.io is exposed though

Hi gabydd, here is my .env

from the .env.example I only changed the POSTGRES_PASSWORD

and the JWT_SECRET

everything else is the same as the example

Ah try to do it without the @ maybe and see if that works for the password