Comment by 5Qn8mNbc2FNCiVV
2 years ago
Crazy to me that the whole thread here doesn't mention how schema changes are more difficult and sometimes also lead to inconsistent data https://simonwillison.net/2020/Sep/23/sqlite-advanced-alter-...
Doesn't help that most ORMs (or other migration tools) don't generate you the correct migration you need
I routinely migrate my SQLite databases. I keep the schema in a text file and I write a separate SQL file to insert all data from the old database into a new one, making changes as needed.