i wrote a new blog post: SQLite does not do checksums.
what does this mean? If even a single bit gets flipped, your database can be corrupted and you won't know when you're reading incorrect data.
this can have serious consequences depending on your application.
ALT PSA: SQLite does not do checksums
09 Nov 2024
SQLite does not do checksums by default. I learned this from Alex Miller. What does this mean? If there is disk corruption, the database or application wonβt be able to know that the database is βcorruptβ.
Even a single bit flip can cause havoc. This can happen due to a faulty disk, a bug in the disk driver, or when another application (malicious or otherwise) modifies the database files.
This is not a bug