> 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 6 days ago | parent [-]

> 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 6 days ago \| parent [-]
		That might have been it. Overall the whole “How to corrupt your database article” was quite a good read: https://sqlite.org/howtocorrupt.html