chjara ☭ :lesbian_mode_el: :true_progress_flag: :blobcat_3d_stretcher:@chjara@akko.tuxcrafting.xyz: SQLite seems incredibly paranoid about the way it …

Home | Notifications | New Note | Local | Federated | Search | Logout

Note Detail

chjara ☭ :lesbian_mode_el: :true_progress_flag: :blobcat_3d_stretcher:@chjara@akko.tuxcrafting.xyz (2026-07-26 01:28:12)
SQLite seems incredibly paranoid about the way it handles IO, but I suppose it's the kind of thing that only seems excessive until your database gets corrupted. Or, well, doesn't, thanks to all that.


---Replies---

wizzwizz4@wizzwizz4@fosstodon.org (2026-07-26 01:31:05)
@chjara You cannot trust the filesystem (see also: https://lwn.net/Articles/1085026/), you cannot trust the CPU, and you certainly cannot trust the storage media.

Sun Microdevil Pte Ltd@koakuma@uwu.social (2026-07-26 02:03:07)
@chjara If my experience with daily computer usage is an indication, every single layer in your stack can and will lie to you about whether the data has been committed down to the persistent storage so I suppose the paranoia is totally justified here...