Re:SQLite Release 3.25.0 adds support for window functions
by cryptonector on Wednesday August 15, 2018 @11:04AM
(#17766548)
A 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.
Re:SQLite Release 3.25.0 adds support for window functions
by blattimwind on Wednesday August 15, 2018 @06:44AM
(#17765043)
> There is nothing stopping you from doing it yourself.
Good database migration tools (e.g. Alembic) do this automatically.
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