> On 9/25/15, Aaron Digulla <digulla at hepe.com> wrote: >> >> I was wondering if it was possible to create the same database (= no binary >> difference) twice with sqlite.
I trust the output of sqldiff, usually with the --primarykey option, to tell me two dbs are equivalent (subject to the caveats listed in http://sqlite.org/sqldiff.html). Great tool -- thanks DRH and other SQLiters! Understood this doesn't directly answer the original question, and I can easily imagine cases where identical dbs are needed, but this discussion reminded me of sqldiff, and this aside: it'd be greatly appreciated (and maybe increase uptake?) if sqldiff binaries were available on the http://sqlite.org/download.html page along with the other tools. stephan($0.02);