SQLite Forum

binary .dump format
Login
> each copy has many incidental pointer-level differences depending on the precise page layouts, reducing the effectiveness of deduplicating backup tools

How reproducible are the resulting files if you `VACUUM` them afterwards?

Maybe we could look for other ways of "canonicalizing" an SQLite3 database?