Re: [sqlite] No journal vs WAL journal

2011-04-25 Thread Dan Kennedy
On 04/26/2011 08:13 AM, Nikolaus Rath wrote: > Nikolaus Rath writes: > [ WAL Performance ] >> Really no one an idea of why this is happening? > > I tried to investigate this further myself and created a small example > program (attached). It fills a table with 500,000 entries without using > expli

Re: [sqlite] No journal vs WAL journal

2011-04-25 Thread Nikolaus Rath
Nikolaus Rath writes: [ WAL Performance ] > Really no one an idea of why this is happening? I tried to investigate this further myself and created a small example program (attached). It fills a table with 500,000 entries without using explicit transactions. The final db is 24 MB big. On my syste

[sqlite] Best JDBC driver for SQLite?

2011-04-25 Thread Paul Linehan
Hi all, I am currently working on a project which will use several different databases as a back end. I'm going to try and take advantage of the various features of the different databases as I go along, but obviously I will need to code some features by hand. As I'm going to be using Java, I wo

Re: [sqlite] data issues on iPhone

2011-04-25 Thread Simon Slavin
On 25 Apr 2011, at 6:20pm, Mickey Mestel wrote: >> Have you tried removing SQLCipher, and just use standard SQLite, to help >> isolate the source of the problem? > > hmmm... not good. i removed SQLCipher, and am linking with the > standard libsqlite, and the problem persists. Okay, if

Re: [sqlite] data issues on iPhone

2011-04-25 Thread Mickey Mestel
>> > > Have you tried removing SQLCipher, and just use standard SQLite, to help > isolate the source of the problem? hmmm... not good. i removed SQLCipher, and am linking with the standard libsqlite, and the problem persists. that points more towards it being something in ou

Re: [sqlite] group_concat(... ORDER BY ...)

2011-04-25 Thread Nico Williams
On Mon, Apr 25, 2011 at 8:35 AM, Petite Abeille wrote: > On Apr 25, 2011, at 7:57 AM, Nico Williams wrote: >> For group_concat(), however, this undefined order is >> obnoxious. > > Seconded. As it stands, group_concat nondeterministic nature renders it > useless for most practical purposes. I wo

Re: [sqlite] group_concat(... ORDER BY ...)

2011-04-25 Thread Petite Abeille
On Apr 25, 2011, at 7:57 AM, Nico Williams wrote: > For group_concat(), however, this undefined order is > obnoxious. Seconded. As it stands, group_concat nondeterministic nature renders it useless for most practical purposes. For what's worth, here is the syntax adopted by Oracle for its LIST