How to not loss data everytime i change the schema
Hi Guys
I just learn drizzle with neondb, i try to use their branching feature where it is quite helpfull, however even though i use dev branching in neondb, everytime i change the schema when i try to do some experimentation, the existing data in the dev branch got deleted.
is there anyway i can keep the data even i change the schema?
3 Replies
@Andrew Sherman
I am trying to learn how to also do this for when I eventually go to prod.
Right now I lose data everytime I change my schema and just seed the data base afterwards.
However when I deal with real customer data this would mean data loss so what are the recommended way to apply db migrations without data loss?
Are there any resources u could point me to, to learn more about migrations without data loss?
I don't use push at all. I generate migrations and look over the generated SQL, making sure everything is correct