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 =

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] SQLite Corruption - Probably Related to auto-vacuum

2006-12-31 Thread Joe Wilson
What happens when you run your program through Valgrind, or any other memory debugger? Even the crudest memory debugger that fills free()'d memory with garbage can be very helpful in debugging multi-threaded program crashes. Regarding Apache 2, I've had problems with their memory pools before, sp

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 time

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

2006-12-31 Thread drh
snowcrash+sqlite <[EMAIL PROTECTED]> wrote: > i'm building sqlite3.3.8 on osx. > > the build, install & operation _seem_ to be ok, > > but, > > sudo -u snowcrash make test > > produces LOTS of comments/errors (long output below). > > i don't know whether to trust my build or not, given t

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

2006-12-31 Thread snowcrash+sqlite
i'm building sqlite3.3.8 on osx. the build, install & operation _seem_ to be ok, .configure --prefix=/usr/local/sqlite --enable-threadsafe --enable-cross-thread-connections --enable-threads-override-locks --enable-tempstore=yes --enable-tcl --enable-debug make make instal

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

2006-12-31 Thread drh
"Ron Avriel" <[EMAIL PROTECTED]> wrote: > 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

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 it's

[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 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 Junk

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 il