3 ms·

> The biggest issue with SQLite is what happens if your server serving stuff goes down mid write? Why would that matter? SQLite is still fully ACID compliant l

• WJW 4y ago
  I imagine that GP means a hardware failure severe enough that it permanently borks the disk drive of the machine. In that case vanilla SQLite would indeed lose data written since the time of the last offsite backup. MySQL/Postgres/etc typically have streaming replication which means you can promote one of the replicas and not lose any (or at least much less) data. There are some new-ish projects like Litestream (https://litestream.io/ https://litestream.io/) that provide a similar functionality for SQLite by streaming the WAL file changes to S3.