RE: [sqlite] How to implement connection pooling

2007-07-11 Thread Samuel R. Neff
ssionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Dinesh Ramdass [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 11, 2007 12:51 PM To: sqlite-users@sqlite.org Subject:

Re: [sqlite] How to implement connection pooling

2007-07-11 Thread Dinesh Ramdass
oin our team building products. 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 con

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 to

RE: [sqlite] How to implement connection pooling

2007-07-10 Thread Samuel R. Neff
t: Tuesday, July 10, 2007 3:56 AM To: sqlite-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

[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:*