3 ms·

I agree! SQLite is very high quality and goes to greater lengths than any other software I'm aware of to ensure correctness and reliablity... but several people

I agree! SQLite is very high quality and goes to greater lengths than any other software I'm aware of to ensure correctness and reliablity... but several people told me that SQLite has ways of improving on fsync and I was interested to find that isn't the case. Edit: And I don't think testing actual power failures is realistic even for something like SQLite. Maybe if you are using SQLite and have a critically important application you'd do something like that, but it's too labor intensive in almost all cases.

jasonwatkinspdx 9y ago
> several people told me that SQLite has ways of improving on fsync and I was interested to find that isn't the case. The way you're talking about this is simplistic. To have a reliable datastore you need to know not just fsync exists, but a lot of specific details in exactly how you use it, and what you can and cannot count on. There's a lot for you to learn here if you care to look a bit deeper than "oh, just uses fsync, boring".
- jeffreyrogers 9y ago
  > There's a lot for you to learn here if you care to look a bit deeper than "oh, just uses fsync, boring". That wasn't my conclusion at all. That's why I took the time to read the docs and the source code. Because I was interested in how SQLite provided the guarantees that it does and what the limitations of those guarantees are.