News for hackers. Stuff that matters.
Re:SQLite Release 3.25.0 adds support for window functions by plq on Wednesday August 15, 2018 @06:05AM (#17764846)
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

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.

Re:SQLite Release 3.25.0 adds support for window functions by ngrilly on Wednesday August 15, 2018 @08:20AM (#17765445)
Any idea on how to do this without blocking writes when SQLite is embedded in a server process?