alt.hn

6/26/2026 at 6:05:39 PM

How to Corrupt an SQLite Database File

https://www.sqlite.org/howtocorrupt.html

by tosh

6/26/2026 at 6:45:28 PM

Article date is Jan 2022. This changes when SQLite runs as WASM in a browser — a context that only became properly viable with OPFS synchronous access handles in mid-2022.

by red1oon

6/27/2026 at 1:54:38 PM

The January 6, 2022 date at the bottom of the page is not the date the page was last updated. It is the date problem 8.9 (Boundary value error in the secondary journals used by nested transactions) directly above it was fixed. The date at the very bottom of the screen in the middle says the page itself was last updated on 2026-04-13.

by andrewl

6/27/2026 at 1:59:04 AM

Interesting title for official SQLite documentation :)

by linzhangrun

6/27/2026 at 12:22:59 PM

The whole sqlite documentation is full of gold gems and other curious documents mostly to appease bureocrats and big companies. It doubles as a fun read other than being incredibly useful.

See, for example: "Defense about the dark arts" (https://sqlite.org/security.Html) and "Why in C?" saying "Because C is best."

by unfocso

6/27/2026 at 1:57:36 PM

Your link to the security page is broken because of the capital H in your URL. It should be: https://www.sqlite.org/security.html

by andrewl

6/27/2026 at 2:01:26 PM

It’s impressive. To admit fallibility is to be honest. It represents confidence.

by andrewl