Re: [sqlite] SQLite3 and threading

2011-02-04 Thread Pavel Ivanov
> I cite from http://sqlite.org/faq.html#q6: > > "The restriction on moving database connections across threads was > relaxed somewhat in version 3.3.1. With that and subsequent versions, it > is safe to move a connection handle across threads as long as the > connection is not holding any fcntl()

[sqlite] Auto Reply: Auto Reply: Re: sqlite-users Digest, Vol 38, Issue 4

2011-02-04 Thread nicolas . williams
This is an auto-replied message. I have left Oracle. My new e-mail address is n...@cryptonector.com. Nico -- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Auto Reply: Re: sqlite-users Digest, Vol 38, Issue 4

2011-02-04 Thread nicolas . williams
This is an auto-replied message. I have left Oracle. My new e-mail address is n...@cryptonector.com. Nico -- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite-users Digest, Vol 38, Issue 4

2011-02-04 Thread Igor Tandetnik
On 2/4/2011 11:14 AM, Scott Baker wrote: > On 02/04/2011 04:00 AM, sqlite-users-requ...@sqlite.org wrote: >> On 2/3/2011 12:10 PM, Scott Baker wrote: #3) Query for customers who bought exactly 2 apples? >> select CustomerID from Customers >> group by CustomerID >> having sum(Type = 'Apple')

Re: [sqlite] sqlite-users Digest, Vol 38, Issue 4

2011-02-04 Thread Scott Baker
On 02/04/2011 04:00 AM, sqlite-users-requ...@sqlite.org wrote: > On 2/3/2011 12:10 PM, Scott Baker wrote: >> > CREATE Table Customers ( >> >EntryID INTEGER PRIMARY KEY, >> >CustomerID INT, >> >Type ENUM >> > ); >> > >> > #1) Query for customers who*ONLY* bought apples > select

Re: [sqlite] Trigger for incrementing a column is slow

2011-02-04 Thread Richard Hipp
On Fri, Feb 4, 2011 at 7:26 AM, Simon Slavin wrote: > > On 4 Feb 2011, at 9:42am, Dan Kennedy wrote: > > > The problem is that the trigger version is creating a statement journal > > for each INSERT statement. It doesn't *really* need to, as there is no > > way that this

Re: [sqlite] Trigger for incrementing a column is slow

2011-02-04 Thread Simon Slavin
On 4 Feb 2011, at 9:42am, Dan Kennedy wrote: > The problem is that the trigger version is creating a statement journal > for each INSERT statement. It doesn't *really* need to, as there is no > way that this statement/trigger can hit a constraint after modifying > any rows. However at the moment

Re: [sqlite] Multithreading problem

2011-02-04 Thread Dan Kennedy
On 02/04/2011 01:04 AM, Tiberio, Sylvain wrote: > You're right! > > I checked the Solaris documentation the correct flag to compile > multithread program is -D_REENTRANT. > > I have reconfigured and remade sqlite libs: >./configure --enable-threadsafe CFLAGS=-D_REENTRANT >make > > I have

Re: [sqlite] Trigger for incrementing a column is slow

2011-02-04 Thread Dan Kennedy
On 02/04/2011 03:24 PM, Kevin Wojniak wrote: > > On Feb 3, 2011, at 10:35 PM, Dan Kennedy wrote: > >> Do you have a test program that we can use to reproduce this phenomenon? >> >> Dan. > > Here is a complete program: > http://pastie.org/pastes/1527560 > > Set USE_TRIGGER to see the trigger

Re: [sqlite] beginner question: help required to retrieve "filename" from an open "sqlite3*" handle

2011-02-04 Thread Simon Davies
On 4 February 2011 07:38, Andreas Otto wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, > > with "sqlite2_open" the parameter "filename" is used to specify the > database location. > > Q: how I can retrieve this parameter from an open handle?

Re: [sqlite] Trigger for incrementing a column is slow

2011-02-04 Thread Kevin Wojniak
On Feb 3, 2011, at 10:35 PM, Dan Kennedy wrote: > Do you have a test program that we can use to reproduce this phenomenon? > > Dan. Here is a complete program: http://pastie.org/pastes/1527560 Set USE_TRIGGER to see the trigger version. Thanks, Kevin