• pdonotices
• pdov1

• What have we learned about the PDO architecture in the past years (that needs fixing)?
• How do we deal with features that only related to one (or few) drivers? What if its impossible to fit a similar feature under a single API? Currently we have a few driver specific attributes (like the unbuffered query attribute for MySQL).
• How do we deal with different error handling? Like some RDBMS create throw errors during the prepare stage, others at the first execute.
• How do we deal with different behavior like transaction errors causing a rollback on some RDBMS but not on others.

• FETCH_SERIALIZE description is wrong, it works like FETCH_CLASS not FETCH_INTO
• document finally remaining FETCH constants like FETCH_KEY_VALUE, FETCH_FUNC
• better document fetchAll() constants

• bindValue() & bindParam() should enforce the type giving, currently it uses the current zval type for MySQL Bug #44639 / PDO: Fixing bug #44639 for mysql
  • PARAM_INT with strings => it should try to convert to the type, otherwise throw an Exception or create an error.
  • PARAM_BOOLEAN with strings => Exception or Error.
  • a new PARAM_AUTO could be used to determine the type by zval (old mysql behavior)
• execute() could use an automatic approach PARAM_AUTO, could be a BC break http://news.php.net/php.pdo/235
  • allows automatic convert to PARAM_INT if zval is integer / float

• Bug#49521 “PDO fetchObject sets values before calling constructor”
  • add note to FETCH_PROPS_LATE
  • allow setting FETCH_PROPS_LATE or assume it as default?

see http://news.php.net/php.pdo/233

• PDOStatement::getColumnMeta with a new parameter to get only one meta type back ml#123127892009423 wouldn't break the current api.
  • META_NAME => column name
  • META_TABLENAME => table name
  • ...

see http://news.php.net/php.pdo/268

For features not yet finalized: see http://news.php.net/php.pdo/286

PDO_Driver::getNative()::asyncQuery();

see http://news.php.net/php.pdo/318 see http://news.php.net/php.pdo/319

• Defaults to be portable as much as possible
• Allow to disable certain connection reset/cleanup features to gain even more speed.

• add fetchAll() FETCH_UNIQUE without FETCH_GROUP (PHP5.3 seems to support it already?)
  • allow the column id to be set
  • allow to receive the key column in the result
  • allow with FETCH_CLASS

see http://news.php.net/php.pdo/233

mysql:

firebird: Check if field allows null, for empty strings and field type is SQL_SHORT, SQL_LONG, SQL_INT64, SQL_FLOAT, SQL_DOUBLE, SQL_TIMESTAMP, SQL_TYPE_DATE, SQL_TYPE_TIME null is assumed as input

odbc: zval == IS_NULL or PDO_PARAM_NULL => always SQL_NULL_DATA

PostgreSQL: zval == IS_BOOL => always bool except if set to PDO_PARAM_NULL (Does reference check, and zval separation before convert_to_string if it isn't a reference)

for all bindValue/bindParam/execute input

(1) there is no _toType yet

(2) An Array of PDO_PARAM_AUTO could be added for Databases allowing Arrays? PostgreSQL?

(3) Allowing streams

For compatibility the execute() function could be changed to PDO_PARAM_AUTO for less BC breaks.