2 ms·
Yes, the process at https://www.sqlite.org/lang_altertable.html https://www.sqlite.org/lang_altertable.html is super risky - 12 steps and a giant CAUTION sideba
by bbkane 3mo ago
Yes, the process at https://www.sqlite.org/lang_altertable.html https://www.sqlite.org/lang_altertable.html is super risky - 12 steps and a giant CAUTION sidebar about the data loss possible if you do it incorrectly.
They DO include a nice section at the bottom about why these limitations exist, but I wish they would make the process easier.
- wmanley 3mo agoWe use this for migrations: https://david.rothlis.net/declarative-schema-migration-for-sqlite/ https://david.rothlis.net/declarative-schema-migration-for-s... Discussed here: https://news.ycombinator.com/item?id=31249823 https://news.ycombinator.com/item?id=31249823 But it would be a lot better if it were built in.