News for hackers. Stuff that matters.
Re:SQLite in Production: Lessons from Running a Store on a S... by crazygringo on Tuesday April 07, 2026 @12:11PM (#47677511)
> Backups are much more straightforward for SQLite.

Not sure how? All of them can be backed up with a single command. But if you want live backups (replication) as opposed to daily or hourly, SQLite is the only one that doesn't support that.

Re:SQLite in Production: Lessons from Running a Store on a S... by MitziMoto on Wednesday April 08, 2026 @12:03AM (#47685048)
Litestream exists?
Re:SQLite in Production: Lessons from Running a Store on a S... by crazygringo on Wednesday April 08, 2026 @11:15AM (#47691390)
That's a third-party tool. It's not part of SQLite.

And it's a pretty hacky usage of the WAL. If it works for you, great, but if I need replication, I'm going to want a database that supports it natively.