Recent and related:

SQLite (with WAL) doesn't do `fsync` on each commit under default settings - https://news.ycombinator.com/item?id=45005071 - Aug 2025 (90 comments)

with a relevant comment by the creator of SQLite here: https://news.ycombinator.com/item?id=45014296

(via https://news.ycombinator.com/item?id=45068594 - thanks int_19h!)