PDO (was: SQLite API deficiency)

It's more like Perl DBI in concept but with a PHP twist; data access
abstraction as opposed to database abstraction.

Very light weight and will take advantage of PHP 5 OO features to
implement lazy evaluation of result sets.

Although we discussed a limited amount SQL dialect abstraction at
LinuxTag last year, the initial code is not going to do anything about
it.

You'll see more on PDO over the next week, when it starts to appear in
PECL.

--Wez.

-----Original Message-----
From: Marc Boeren [mailto:m.boeren@guidance.nl]
Sent: 13 May 2004 15:30
To: PHP Development
Subject: [PHP-DEV] PDO (was: SQLite API deficiency)

Hi,

I'm currently in DB API mode (working on PDO),

I know PDO is slated to be the db-abstraction module from 5.x (5.1?)
onwards (which would replace dbx, but that's fine by me: PDO seems to
work more or less the same but with a more OO-ish api), but I was
wondering if these names bear any relation to the Python
DB-API and the
Python Database Objects, or if that is more of a coincidence?

Also, will there be an complementary SQL-abstraction package for
SQL-dialect differences (such as UPPER(value) vs. UCASE(value), or
differences in TOP/LIMIT/OFFSET usage)?
I have a preliminary package ready (in php-source-code, not c) that is
coupled to an OO-ish api for dbx, but is easily rewritable to a more
generic version.

Cheerio, Marc.

Marc Boeren wrote:

I'm currently in DB API mode (working on PDO),

I know PDO is slated to be the db-abstraction module from 5.x (5.1?)
onwards (which would replace dbx, but that's fine by me: PDO seems to
work more or less the same but with a more OO-ish api), but I was
wondering if these names bear any relation to the Python DB-API and the
Python Database Objects, or if that is more of a coincidence?

Also, will there be an complementary SQL-abstraction package for
SQL-dialect differences (such as UPPER(value) vs. UCASE(value), or
differences in TOP/LIMIT/OFFSET usage)?
I have a preliminary package ready (in php-source-code, not c) that is
coupled to an OO-ish api for dbx, but is easily rewritable to a more
generic version.

Actually PDO is more an API unification than abstraction layer.
Abstraction will best be handled in userland code, specifically a PEAR
package should handle this. For this reason I am also involved in the
project more from the API perspective then from actual C implementation.
Also obviously the current DBAL in PEAR have solved alot of the issues
that PDO faces as well.

regards,
Lukas Smith