4 ms·
My Go driver adds support for this by default, and I provide a simple API to enable it. I'm of the opinion that the VFS shim should ship by default, certainly
by ncruces 2y ago
My Go driver adds support for this by default, and I provide a simple API to enable it.
I'm of the opinion that the VFS shim should ship by default, certainly on the CLI, because it still needs to be enabled for each DB, and all it takes is one instance that doesn't know about checksums to modify a checksummed DB for it to appear corrupt.
https://github.com/ncruces/go-sqlite3/tree/main/vfs#checksums https://github.com/ncruces/go-sqlite3/tree/main/vfs#checksum...
Weirdly, databases created with the macOS version of the sqlite3 CLI reserve 12 bytes, for some reason, so you can't ever enable checksums on those DBs.