Hacker News new | ask | show | jobs
by axelthegerman 1385 days ago
Not sure what you mean by durability. Sqlite has WAL that can be replicated (see litestream)
1 comments

https://www.sqlite.org/atomiccommit.html

sqlite is as good at durability as any non-replicated database, though you can configure it to be non-durable (most other databases too tbf).

https://www.sqlite.org/pragma.html#pragma_synchronous

By default WAL mode can rollback committed transactions in cases of power failure, but you can do `PRAGMA synchronous = FULL` to trade speed for durability.

I’m talking about the post I originally commented on. Things were disabled so durability is not guaranteed.
Yeah that's not great