Get the latest tech news

SQLite does not do checksums


SQLite does not do checksums by default. Disk corruptions go silently unnoticed.

SQLite assumes that the detection and/or correction of bit errors caused by cosmic rays, thermal noise, quantum fluctuations, device driver bugs, or other mechanisms, is the responsibility of the underlying hardware and operating system. 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.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of PSA

PSA

Photo of SQLite

SQLite

Photo of checksums

checksums

Related news:

News photo

PSA: don't stand still in Black Ops 6's Zombie mode

News photo

PSA: Apple's New USB-C Accessories Require macOS Sequoia, Don't Work Properly With macOS 15.2 Beta

News photo

Migration of the build system to autosetup