Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:9839
Return-Path: <m.boeren@guidance.nl>
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Delivered-To: mailing list internals@lists.php.net
Received: (qmail 58544 invoked by uid 1010); 13 May 2004 15:08:32 -0000
Delivered-To: ezmlm-scan-internals@lists.php.net
Delivered-To: ezmlm-internals@lists.php.net
Received: (qmail 58509 invoked from network); 13 May 2004 15:08:32 -0000
Received: from unknown (HELO guidance.nl) (213.201.153.14)
  by pb1.pair.com with SMTP; 13 May 2004 15:08:32 -0000
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0
Date: Thu, 13 May 2004 17:06:31 +0200
Message-ID: <0C77C7530EA52A4EBD1C47C80D1D291E07F8D6@sbs.GuidanceBV.local>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [PHP-DEV] PDO (was: SQLite API deficiency)
thread-index: AcQ47djdrtilCPD0QWegvEp8JZxlaQAAIs6gAAG7BaAAAHspgAAAku5w
To: "PHP Development" <internals@lists.php.net>
Subject: RE: [PHP-DEV] PDO (was: SQLite API deficiency)
From: m.boeren@guidance.nl ("Marc Boeren")


Hi,

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

Is there some source available somewhere? I noticed an ext/pdo on
marcus-boerger.de, with fairly recent code. There is a lot of SQL in the
testset though, so I wouldn't call that data access abstraction. But I
don't really care about a specific name: it is the ability to access
data from multiple backends through one api that interests me.

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

If the goal is to be able to swap database backends easily, some SQL
abstraction is needed.=20

If PDO development has settled down after an initial release and you
have time to think about SQL abstraction, I have working code for=20
    sql_escape_string
    sql_count
    sql_min
    sql_max
    sql_lowercase
    sql_uppercase
    sql_concatenate
    sql_substring
    sql_replace
    sql_limit // and offset, except for databases that use TOP as limit
    sql_col_alias // use "col AS alias" or "col alias"
    sql_tbl_alias
for backends
    DBX_ODBC
    DBX_MSSQL
    DBX_FBSQL
    DBX_SYBASECT
    DBX_OCI8
    DBX_PGSQL
    DBX_MYSQL
    DBX_SQLITE

I could attach it or put it online somewhere if you wish to take a look.

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

Great. What are the initial backends that will be supported? SQLite,
MySQL, PGSQL?

Cheerio, Marc.