Re: [sqlite] [PHP5-FPM] Sqlite3 or pdo_sqlite?

2010-07-24 Thread Gilles Ganault
On Sat, 24 Jul 2010 18:50:05 +0200, Kees Nuyt wrote: >There's also pdo_sqlite_external which uses the sqlite3.dll >the user provides, so you can use the latest and greatest >sqlite version without having to wait for incorporation in >PHP or PDO itself. Thanks guys for the

Re: [sqlite] [PHP5-FPM] Sqlite3 or pdo_sqlite?

2010-07-24 Thread Kees Nuyt
On Sat, 24 Jul 2010 09:18:57 -0400, "J. King" wrote: > PDO_sqlite3 also does have the advantage of being available by default > since PHP 5.0.0, whereas sqlite3 is only available by default since PHP > 5.3.0. I'm aware of no other advantages to using PDO, and from what

Re: [sqlite] [PHP5-FPM] Sqlite3 or pdo_sqlite?

2010-07-24 Thread Alan Chandler
On 24/07/10 15:41, Alan Chandler wrote: > On 24/07/10 14:18, J. King wrote: > >> PDO_sqlite3 also does have the advantage of being available by default >> since PHP 5.0.0, whereas sqlite3 is only available by default since PHP >> 5.3.0. I'm aware of no other advantages to using PDO, and from what

Re: [sqlite] [PHP5-FPM] Sqlite3 or pdo_sqlite?

2010-07-24 Thread Alan Chandler
On 24/07/10 14:18, J. King wrote: > PDO_sqlite3 also does have the advantage of being available by default > since PHP 5.0.0, whereas sqlite3 is only available by default since PHP > 5.3.0. I'm aware of no other advantages to using PDO, and from what I've > read it's on the slow side. > Right

Re: [sqlite] [PHP5-FPM] Sqlite3 or pdo_sqlite?

2010-07-24 Thread J. King
On Sat, 24 Jul 2010 08:33:21 -0400, Simon Slavin wrote: > > On 24 Jul 2010, at 9:56am, Gilles Ganault wrote: > >> So from the above, it looks like this binary supports access to >> MySQL(i) and SQLite2/3, in both procedural and (PDO) object-oriented >> modes. >> >> If

Re: [sqlite] [PHP5-FPM] Sqlite3 or pdo_sqlite?

2010-07-24 Thread Simon Slavin
On 24 Jul 2010, at 9:56am, Gilles Ganault wrote: > So from the above, it looks like this binary supports access to > MySQL(i) and SQLite2/3, in both procedural and (PDO) object-oriented > modes. > > If that's correct, and provided the application doesn't need to be > DB-agnostic... why should I

[sqlite] [PHP5-FPM] Sqlite3 or pdo_sqlite?

2010-07-24 Thread Gilles Ganault
Hello I'm using the pre-compiled PHP5-FPM/FastCGI (www.php-fpm.org) which seem to contain the following DB connectors: PDO drivers mysql, sqlite, sqlite2 pdo_mysql 5.1.48 pdo_sqlite 3.6.22 SQLite 2.8.17 sqlite3 3.6.22 So from the above, it looks like this binary supports access to MySQL(i)