Re: [sqlite] Finding duplicate records

2005-02-05 Thread Stefano Barbato
On Wed, 2005-01-26 at 17:45 -0800, Clark Christensen wrote: > Hello all, > > I'm new to SQL, and SQLite, and I find myself needing to > identify duplicate records in a SQLite table (there are > about 2K duplicates in a 36K row table). Any suggestions > or magic SQL queries appreciated :-) >

Re: [sqlite] Finding duplicate records

2005-02-05 Thread Stefano Barbato
On Wed, 2005-01-26 at 17:45 -0800, Clark Christensen wrote: > Hello all, > > I'm new to SQL, and SQLite, and I find myself needing to > identify duplicate records in a SQLite table (there are > about 2K duplicates in a 36K row table). Any suggestions > or magic SQL queries appreciated :-) > I've u

Re: [sqlite] runtime detect of THREADSAFE

2004-05-21 Thread Stefano Barbato
On Thursday 20 May 2004 20:29, Christian Smith wrote: > Well, as it's PD software, just ship and compile the latest version with > your software. You can then control how it's compiled. On Friday 21 May 2004 01:00, you wrote: > Have you considered linking sqlite staticly ? well, even if the "objd

Re: [sqlite] runtime detect of THREADSAFE

2004-05-20 Thread Stefano Barbato
On Thursday 20 May 2004 09:31, Stefano Barbato wrote: > On Thursday 20 May 2004 00:25, Peter wrote: > > Stefano Barbato wrote: > > > is there a way to detect at runtime if the sqlite library has been > > > compiled with the THREADSAFE=1 flag or not? > > > >

Re: [sqlite] runtime detect of THREADSAFE

2004-05-20 Thread Stefano Barbato
On Thursday 20 May 2004 00:25, Peter wrote: > Stefano Barbato wrote: > > is there a way to detect at runtime if the sqlite library has been > > compiled with the THREADSAFE=1 flag or not? > > No, or not that I know of. It would be nice for ver 3 to have a simple >

[sqlite] runtime detect of THREADSAFE

2004-05-19 Thread Stefano Barbato
Hi, I already tried to find the aswer on the faq/wiki/mailing list archive/google with no luck so here is my question: is there a way to detect at runtime if the sqlite library has been compiled with the THREADSAFE=1 flag or not? I need thread-safeness turned on and I would like to test for it