Hello everyone! is there any simple db-beginner-fr...
# help
h
Hello everyone! is there any simple db-beginner-friendly way to manage the project locally? I did read the "local development" guide (https://supabase.com/docs/guides/local-development) , but I'm having trouble to understand how this actually works, for example; how can I rollback to a previous state of DB?, can I manage all of that with regular git?, I'm not getting the "migrations" concept that well but I would like to learn! thanks in advance.
n
Hello @Haus Of Alejandro! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
m
Honestly, for beginners, I believe it is easier to create a dev project in supabase and a production project by migrating from one to the other: https://supabase.com/docs/guides/database#migrating-between-projects
But using a local environment properly set can be very useful with commands like:
supabase db reset
But setting up a local environment is something that can give you headaches if you miss a step. So, you should follow the link there carefully.
h
Yeah, I'm already struggling with that haha, but that's ok. Is it ok for example if my "versions" and changes in time over the project, are just a dump sql that I can versionate? I don't think that's sustentable in time but I might be so wrong any way.
I just want to for example keep control on what I change on a table, in a function, the last week, so I can compare, etc
just like git
m
You can use these commands to dump/ restore the database: https://supabase.com/docs/guides/database#migrate-the-database
h
Thank you so much @mansueli
n
Thread was archived by @Haus Of Alejandro. Anyone can send a message to unarchive it.