News for hackers. Stuff that matters.
Re:Litestream – Opensource disaster recovery and continuous ... by nwienert on Monday January 01, 2024 @11:42PM (#38838199)
This model ends up with a sort of db-per-user/team model no?

My questions are around that. Are there good solutions for migrations? Has anyone made it relatively easy to handle in terms of deploy/scale/manage?

Re:Litestream – Opensource disaster recovery and continuous ... by simonw on Monday January 01, 2024 @11:51PM (#38838238)
I've been working on a system for systematically applying migrations to SQLite databases here, inspired (a bit) by how Django migrations work: https://github.com/simonw/sqlite-migrate

I've used it in a few places myself, but I've not yet released a non-beta version of it. I'm close to having the confidence to say other people should use it too!

Re:Litestream – Opensource disaster recovery and continuous ... by ramraj07 on Tuesday January 02, 2024 @12:07AM (#38838320)
Why should it be a db per user though? All we have to do is ensure we have a single machine doing all the db writes, which might not be a terrible idea for simple apps..