4 ms·

https://en.m.wikipedia.org/wiki/Durability_(database_systems) https://en.m.wikipedia.org/wiki/Durability_(database_systems...

• dinosaurdynasty 4y ago
  https://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 ago
    I’m talking about the post I originally commented on. Things were disabled so durability is not guaranteed.
    • dinosaurdynasty 4y ago
      Yeah that's not great