Re: [sqlite] How to implement connection pooling

2007-07-11 Thread Dinesh Ramdass
. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Dinesh Ramdass [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 10, 2007 3:56 AM To: sqlite-users@sqlite.org Subject: [sqlite] How to implement connection pooling HI , *How we use SQlit

Re: [sqlite] How to implement connection pooling

2007-07-10 Thread John Stanton
We use connection pooling. It took only a few lines of C code to implement. In our case we maintain a global list of open connections and access them by pathname. A mutex is required to protect the list anchor pointer when a new connection is added. We also add pthread read/write locking

RE: [sqlite] How to implement connection pooling

2007-07-10 Thread Samuel R. Neff
lite-users@sqlite.org Subject: [sqlite] How to implement connection pooling HI , *How we use SQlite:* We use MONO and SQLite 3 for our project which runs on Linux. It is going to be used as an embedded database in a device. *What i want to do:* I want to use connection pooling either using

[sqlite] How to implement connection pooling

2007-07-10 Thread Dinesh Ramdass
HI , *How we use SQlite:* We use MONO and SQLite 3 for our project which runs on Linux. It is going to be used as an embedded database in a device. *What i want to do:* I want to use connection pooling either using some feature provided by SQLite or someone else *What i want to know:*