3 ms·
There is nothing stopping you from doing it yourself. The Sqlite FAQ[1] even has an entry on it. Two things holding this back: 1. code being inside our outside
by plq 8y ago
There is nothing stopping you from doing it yourself. The Sqlite FAQ[1] even has an entry on it.
Two things holding this back: 1. code being inside our outside sqlite would not be much different. 2. the amount of additional test code would be humongous for an operation of that level of complexity.
So, just do it yourself. It's not that hard.
[1]: https://www.sqlite.org/faq.html#q11 https://www.sqlite.org/faq.html#q11
- blattimwind 8y ago> There is nothing stopping you from doing it yourself. Good database migration tools (e.g. Alembic) do this automatically.
- ngrilly 8y agoAny idea on how to do this without blocking writes when SQLite is embedded in a server process?
- cryptonector 8y agoA lot of table alterations can be done without rebuilding the table, though perhaps a table scan might be needed to validate constraints (though this should optionally be a separate statement). To do this safely requires the RDBMS to support the functionality.