Add automatic database migrations

[developer-dao]

Add automatic database migrations

[JoviDeCroock]

I haven't read abour this in context of supabase but the idea is setting up a CI step that will update the database schema when we roll out updates to production. This so we don't have the pressure of manually running a script to keep the schema in sync. When I look for supabase migrations I ended up at their cli https://supabase.com/blog/2021/03/31/supabase-cli

[with-heart]

Could you please explain what "automatic database migrations" refers to here?

How do they work? What might we need to do to make them happen?

Is there a documentation page that might provide more context?

[carlomigueldy]

Could you please explain what "automatic database migrations" refers to here?
How do they work? What might we need to do to make them happen?
Is there a documentation page that might provide more context?

Updated the description for this ticket to address these.

[carlomigueldy]

Just a question since I didn't completely catch it from Discord conversation I was a bit lost with a bunch of options thrown out, why would we defer from using Prisma? @JoviDeCroock

1. What's the concern main concerns of it on using it client side?
2. What's the concern main concerns of it on using it server side? (e.g. Serverless Functions)