[sqlite] Creating a stable database

2015-09-28 Thread Aaron Digulla
Am Montag, 28. September 2015 15:55 CEST, "R.Smith" schrieb: > > > On 2015-09-28 11:30 AM, Aaron Digulla wrote: > > > > Am Freitag, 25. September 2015 20:46 CEST, Warren Young > etr-usa.com> schrieb: > > > >> > >> That suggests a good test for Aaron, then: > >> > >> sqlite3

[sqlite] Creating a stable database

2015-09-28 Thread R.Smith
On 2015-09-28 11:30 AM, Aaron Digulla wrote: > > Am Freitag, 25. September 2015 20:46 CEST, Warren Young > schrieb: > >> >> That suggests a good test for Aaron, then: >> >> sqlite3 my.db .dump > dump.sql >> sqlite3 a.db < dump.sql >> sqlite3 b.db < dump.sql > Thank you

[sqlite] Creating a stable database

2015-09-28 Thread Simon Slavin
On 28 Sep 2015, at 10:30am, Aaron Digulla wrote: > That leaves me with a bug in my code or some really odd behavior because of > the Java VM. That's a nice bit of detective work. Is there anyone on the Java VM team you can contact and explain the bug to ? Simon.

[sqlite] Creating a stable database

2015-09-28 Thread Aaron Digulla
Am Freitag, 25. September 2015 20:46 CEST, Warren Young schrieb: > On Sep 25, 2015, at 11:59 AM, Richard Hipp wrote: > > > > On 9/25/15, Aaron Digulla wrote: > >> > >> I was wondering if it was possible to create the same database (= no binary > >> difference) twice with sqlite. > > > >

[sqlite] Creating a stable database

2015-09-25 Thread R.Smith
On 2015-09-25 08:46 PM, Warren Young wrote: > On Sep 25, 2015, at 11:59 AM, Richard Hipp wrote: >> On 9/25/15, Aaron Digulla wrote: >>> I was wondering if it was possible to create the same database (= no binary >>> difference) twice with sqlite. >> It works fine to create identical database

[sqlite] Creating a stable database

2015-09-25 Thread Simon Slavin
On 25 Sep 2015, at 5:04pm, Aaron Digulla wrote: > I was wondering if it was possible to create the same database (= no binary > difference) twice with sqlite. Everything in a SQLite database is either structure (which we tend to call 'schema' here) or data. (For the same of argument we'll

[sqlite] Creating a stable database

2015-09-25 Thread Stephan Mueller
> On 9/25/15, Aaron Digulla 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

[sqlite] Creating a stable database

2015-09-25 Thread Aaron Digulla
Hello, I was wondering if it was possible to create the same database (= no binary difference) twice with sqlite. I tried by creating all tables in the same order and then inserting all rows in order of the primary key. But if I create two database files with the same code, the files are

[sqlite] Creating a stable database

2015-09-25 Thread Richard Hipp
On 9/25/15, Aaron Digulla wrote: > Hello, > > I was wondering if it was possible to create the same database (= no binary > difference) twice with sqlite. > > I tried by creating all tables in the same order and then inserting all rows > in order of the primary key. But if I create two database

[sqlite] Creating a stable database

2015-09-25 Thread Warren Young
On Sep 25, 2015, at 11:59 AM, Richard Hipp wrote: > > On 9/25/15, Aaron Digulla wrote: >> >> I was wondering if it was possible to create the same database (= no binary >> difference) twice with sqlite. > > It works fine to create identical database files when I try it: > > drh at