RE: [PHP-DEV] PDO (was: SQLite API deficiency)

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. If PDO development has settled down after an initial release and you have time to think about SQL abstraction, I have working code for 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.