[sqlite] using .sqliterc on Windows

2004-02-27 Thread Helphand
How do I get .sqliterc to work for the sqlite.exe client under Windows? It doesn't seem to find the file no matter where I try putting it. Scott Utilities for POPFile, the OpenSource Mail Classifier http://www.geocities.com/Helphand1/popfile.htm

Re: [sqlite] multithreading

2004-02-27 Thread Dave Hayden
After reading that SQLite should Just Work, I dug through my code and found my bug: I was calling sqlite_reset before invoking my precompiled queries instead of afterwards. I changed it around and it seems to be fixed--leaving the vm in a running state must have held a lock somewhere? Many

Re: [sqlite] PHP extention

2004-02-27 Thread Yves Glodt
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 27 February 2004 09:03, Yves Glodt wrote: > > Pierre-Alain Joye wrote: > >>On Sun, 15 Feb 2004 13:10:59 -0800 > >> > >>"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > >>>Im a bit confused as to where i get a sqlite.so for php. > >>>When i

RE: [sqlite] Re: [inbox] [sqlite] About ORDER BY results...

2004-02-27 Thread Williams, Ken
> -Original Message- > From: Jay Macaulay [mailto:[EMAIL PROTECTED] > Sent: Friday, February 27, 2004 10:56 AM > > Another solution that would allow using an index would be to > add another > column, flatname, and insert the name into that column > without any accents > while still

[sqlite] Re: [inbox] [sqlite] About ORDER BY results...

2004-02-27 Thread Jay Macaulay
> > > > Unfortunately, in neither of these cases will SQLite use an index to perform > the sort or retrieval. So you won't get the performance of, say, mysql's > text fields: > > http://www.mysql.com/doc/en/CHAR.html > > -Ken > Another solution that would allow using an index would be to add

Re: [sqlite] Re: [inbox] [sqlite] About ORDER BY results...

2004-02-27 Thread Michael Hunley
At 10:32 AM 2/27/2004 +0100, Eric Morand wrote: This was a mistake by me ! Here is the order actually returned by SQLite : Celine Céline Eric Marc Zoe céline eric Éric éric Do someone know how to have the ORDER BY statement return values ordered with anything else that memcmp() order ? This

Re: [sqlite] multithreading

2004-02-27 Thread Christian Smith
On Fri, 27 Feb 2004, D. Richard Hipp wrote: >[EMAIL PROTECTED] wrote: > > > > I'm trying to access the database from two threads: the UI thread mostly > > reads and occasionally updates rows, while the network thread loads new > > messages and inserts them. Will that work, or do I just

Re: [sqlite] multithreading

2004-02-27 Thread D. Richard Hipp
rumcais wrote: > I've make some experiments around accessing the SQLite database fom concurent > processes at the same time and I find it work good when I'm using > transactions every time I touch the database. When I don't, it corrupt the > database file sometimes. > The only ways to corrupt an

[sqlite] LiteQuery

2004-02-27 Thread Edmunt Pieńkowski
Hi everyone. I wrote another GUI to SQLite database management. I called it LiteQuery. Binary and sources may be found at http://republika.pl/roed ( look also at Wiki pages ). Please send me your comments about this tool. Ed.

Re: [sqlite] PHP extension

2004-02-27 Thread Cesare D'Amico
Alle 02:36, venerdì 27 febbraio 2004, [EMAIL PROTECTED] ha scritto: > For whatever reason pear install sqlite is not working now. It gets > through the configure, then starts the build and errors with: *Did* you try asking that on the right mailing list? (pecl-dev) PHP's sqlite extension has

Re: [sqlite] Re: [inbox] [sqlite] About ORDER BY results...

2004-02-27 Thread Eric Morand
This was a mistake by me ! Here is the order actually returned by SQLite : Celine Céline Eric Marc Zoe céline eric Éric éric Do someone know how to have the ORDER BY statement return values ordered with anything else that memcmp() order ? This method completely make the ORDER BY useless when

Re: [sqlite] PHP extention

2004-02-27 Thread Yves Glodt
> Pierre-Alain Joye wrote: > >>On Sun, 15 Feb 2004 13:10:59 -0800 >>"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: >> >> >> >>>Im a bit confused as to where i get a sqlite.so for php. >>>When i build sqlite from source it does not place a sqlite.so anywhere >>> >>>in my system. >>>Using 'pear