News for hackers. Stuff that matters.
Re:SQLite Release 3.25.0 adds support for window functions by rypskar on Wednesday August 15, 2018 @06:21AM (#17764927)
One problem is that you then might need a special case for SQLite in migrations which can lead to different db schemas in tests and production
Re:SQLite Release 3.25.0 adds support for window functions by ngrilly on Wednesday August 15, 2018 @08:22AM (#17765456)
Use the same database for test and production. Nowadays, it is really easy to install PostgreSQL or MySQL locally or in your test environment. SQLite is great, but not for replacing PostgreSQL or MySQL during tests.