News for hackers. Stuff that matters.
Re:PSA: SQLite WAL checksums fail silently and may lose data by mardifoufs on Thursday July 24, 2025 @05:31PM (#44676469)
I know MySQL has checksums by default, how does it compare? Is it useful or is it similarly weak?
Re:PSA: SQLite WAL checksums fail silently and may lose data by jandrewrogers on Thursday July 24, 2025 @07:23PM (#44677559)
I don't know but LLMs seem to think it uses a 32-bit CRC like e.g. Postgres.

In fairness, 32-bit CRCs were the standard 20+ years ago. That is why all the old software uses them and CPUs have hardware support for computing them. It is a legacy thing that just isn't a great choice in 2025.