RE: [sqlite] Using sqlite.exe

2006-12-31 Thread Ralf Junker
Hello Michael Hooker, >I shall try using a Delphi wrapper later on, DiSQLite3 will probably be the >one I will choose, but so far I'm struggling to understand the examples >because the author has chosen to use a maze of separate units and an >unfamiliar set of external third party components to

RE: [sqlite] Using sqlite.exe

2006-12-31 Thread Michael Hooker
I have sent Ralf a long reply directly. No criticism was intended, and eventually I expect to be as impressed by DiSQLite as I am by SQLiteSpy. It's just that I can't make it work yet and don't have the time for the steep learning curve. Michael Hooker -Original Message- From: Ralf

[sqlite] SQLite Corruption - Probably Related to auto-vacuum

2006-12-31 Thread Ron Avriel
Hi, The SQLite database in my application becomes corrupted quite often under high test load (error 'database disk image is malformed' is returned). Some information: SQLite version: 3.3.8, but a similar crash occurred at previous versions as well. SQLite configuration: --enable-threadsafe

Re: [sqlite] Using sqlite.exe

2006-12-31 Thread Clay Dowling
Sorry I didn't chime in before, but I would strongly recommend using Mike Cariotoglou's mksqlite import library, which is available in the contrib section of the sqlite website. It contains a direct import of the SQLite library into Delphi. I'm using it for a couple of projects right now and

Re: [sqlite] v338 build seems ok, but 'make test' complains a lot

2006-12-31 Thread snowcrash+sqlite
On my builds, all tests pass and collectively give about 98% source code coverage. I never release unless all tests pass. important to know, then. thanks. I have spent entirely too much of my life already trying to get my head around autoconf/libtool and I do not intend to waste any more

Re: [sqlite] v338 build seems ok, but 'make test' complains a lot

2006-12-31 Thread drh
snowcrash+sqlite <[EMAIL PROTECTED]> wrote: > > i'm happy to make the changes to the Makefile, avoiding the autofoo > stuff completely, if you might point in the right direction ... > The Makefile that I use for debugging and testing (on SuSE 10.1) follows: #!/usr/make # # Makefile for SQLITE

Re: [sqlite] v338 build seems ok, but 'make test' complains a lot

2006-12-31 Thread snowcrash+sqlite
this was very helpful. with minor changes to your 'Makefile' for my env, % cat Makefile #!/usr/bin/make TOP =/usr/ports/sqlite-3.3.8 AR = /usr/bin/ar -cr RANLIB = /usr/bin/ranlib NAWK = /usr/local/bin/gawk BCC