https://supabase.com/ logo
#help
Title
# help
h

Haus Of Alejandro

06/13/2022, 5:11 PM
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

Needle

06/13/2022, 5:11 PM
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

mansueli

06/13/2022, 6:27 PM
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

Haus Of Alejandro

06/13/2022, 6:50 PM
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

mansueli

06/13/2022, 7:21 PM
You can use these commands to dump/ restore the database: https://supabase.com/docs/guides/database#migrate-the-database
h

Haus Of Alejandro

06/14/2022, 6:40 PM
Thank you so much @mansueli
n

Needle

06/14/2022, 6:40 PM
Thread was archived by @Haus Of Alejandro. Anyone can send a message to unarchive it.