4 ms·
Not sure what you mean by durability. Sqlite has WAL that can be replicated (see litestream)
by axelthegerman 4y ago
Not sure what you mean by durability.
Sqlite has WAL that can be replicated (see litestream)
- endisneigh 4y agohttps://en.m.wikipedia.org/wiki/Durability_(database_systems) https://en.m.wikipedia.org/wiki/Durability_(database_systems...
- dinosaurdynasty 4y agohttps://www.sqlite.org/atomiccommit.html 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 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.
- endisneigh 4y agoI’m talking about the post I originally commented on. Things were disabled so durability is not guaranteed.
- dinosaurdynasty 4y agoYeah that's not great