Top
Best
New

Posted by kiwicopple 4/3/2025

Declarative Schemas for simpler database management(supabase.com)
81 points | 57 commentspage 2
oulipo 4/4/2025|
So I guess this is a bit the same as using something like Drizzle to define your tables and handle your migrations?
xaas 4/3/2025||
I use ZenStack. In future releases they are moving away from supabase…
mylons 4/3/2025||
am i missing something? what does this offer over raw sql? it honestly looks very similar
kiwicopple 4/3/2025|
It is raw sql. The update here is more of a "workflow" change.

In the past we only offered tools to create a sql migration to make a change to your database. Now you can write the state of your database into files, then the migration is generated for you.

This is very similar to something like Rails/Phoenix/whatever, where you write your models and then it generates a change. The difference is that here you write your models in raw SQL, rather than an ORM

wmanley 4/3/2025|
See also:

“Simple declarative schema migration for SQLite”

https://david.rothlis.net/declarative-schema-migration-for-s...

Discussed previously:

https://news.ycombinator.com/item?id=31249823

Disclosure: I am the co author of that article