Comment

Comment by electricshampo1

Does sqlite have per page checksums (for bit rot detection)?

Only thing per page I see in the docs is

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

"SQLite has the ability to set aside a small number of extra bytes at the end of every page for use by extensions. These extra bytes are used, for example, by the SQLite Encryption Extension to store a nonce and/or cryptographic checksum associated with each page."

Postgres (and other databases that actually care about data integrity) have per page checksums:

https://www.postgresql.org/docs/13/storage-page-layout.html#...

Discussion

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton