SupabaseS
Supabase•2y ago
sonsorei

Defining In Code Schemas

Hi, everyone 👋

I'm building a project with supabase and I want to know a good approach defining schemas.

How do you guys do it?
Create and modify the tables in the dashboard, then do a db pull and commit the new migrations to github?

Or define the schema in code first using something like prisma and then apply generated migrations?

I tried the prisma route, but I had HUGE problems with baselining the db because of the auth schema.

So I'm not sure how should I go about defining my database schemas.

Anyways, would love to hear your opinions and if you could share some project examples would be great, ty!
Was this page helpful?