2 ms·
Related question - does SQLite checksum blocks (pages) of data? Of course the filesystem usually does, and the physical device itself does, but in the scenario
by endorphone 7y ago
Related question - does SQLite checksum blocks (pages) of data? Of course the filesystem usually does, and the physical device itself does, but in the scenario where the OS somehow delivered corrupted data would SQLite at a minimum detect it?
- Liquid_Fire 7y ago> Of course the filesystem usually does Does it really? Certainly a few filesystems like ZFS have features like that, but AFAIK none of the "mainstream" ones do (the things actually running on billions of devices, like ext4, NTFS, etc)
- blattimwind 7y ago> does SQLite checksum blocks (pages) of data? No. Postgres has an off-by-default option for this. The journal does, though. > Of course the filesystem usually does Nope. Data checksumming is usually only employed by CoW file systems, because it requires data journaling for a regular file system, which generally isn't used or not supported at all.