News for hackers. Stuff that matters.
Re:SQLite Release 3.25.0 adds support for window functions by silvestrov on Wednesday August 15, 2018 @05:55AM (#17764814)
That’s not enough because it ignores all foreign key constraints.
Re:SQLite Release 3.25.0 adds support for window functions by ifdefdebug on Wednesday August 15, 2018 @07:37AM (#17765258)
Lock db exclusively, disable foreign key checking, rebuild and replace table, reconfigure foreign keys (they are gone after delete and rename), and everything should be fine.