3 ms·
> When a commit completes for a transaction, that transaction has been durably written. No mystery. That's true whether you decide to restrict writes to a singl
by catlifeonmars 1y ago
> When a commit completes for a transaction, that transaction has been durably written. No mystery. That's true whether you decide to restrict writes to a single thread in your application or not.
Usually this is true but there are edge cases for certain journaled file systems. IIRC sqlite.org has a discussion on this.
- zimpenfish 1y ago> there are edge cases for certain journaled file systems. IIRC sqlite.org has a discussion on this. Can't currently find it but I guess it comes under the "if the OS or hardware lies to SQLite, what can it do?" banner?
- catlifeonmars 1y agoThat might have been it. Overall the whole “How to corrupt your database article” was quite a good read: https://sqlite.org/howtocorrupt.html https://sqlite.org/howtocorrupt.html