internals:pdo:brainstorming

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
internals:pdo:brainstorming [2009/11/19 22:31] – added some more infos on binding related issues lsmithinternals:pdo:brainstorming [2010/01/08 21:11] – external edit 127.0.0.1
Line 12: Line 12:
   * 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 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.   * How do we deal with different behavior like transaction errors causing a rollback on some RDBMS but not on others.
 +  * How to deal with missing functionality available inside the native extensions? Is the goal to eventually replace the native extensions? Is there any chance to share connections between PDO and the native extensions? 
 +  * How do we handle cross connection transactions? ( 2 phase commit across multiple databases - need to add more information later )
  
 ===== PDO Bugs / PDO2 Improvements ===== ===== PDO Bugs / PDO2 Improvements =====
Line 20: Line 21:
   * document finally remaining FETCH constants like FETCH_KEY_VALUE, FETCH_FUNC   * document finally remaining FETCH constants like FETCH_KEY_VALUE, FETCH_FUNC
   * better document fetchAll() constants   * better document fetchAll() constants
 +  * add support table for ATTR_FETCH_TABLE_NAMES (sqlite still has a pending patch)
 +  * ATTR_FETCH_CATALOG_NAMES unused?
 +  * FETCH_FUNC should mention it is only allowed with fetchAll
 +  * Mention PDOStatement can be used in foreach, but won't call an overloaded fetch as the internal iterator is used.
  
 === Parameter binding & explicit data type set === === Parameter binding & explicit data type set ===
Line 47: Line 52:
 see [[http://news.php.net/php.pdo/268]] see [[http://news.php.net/php.pdo/268]]
  
-For features not yet finalized: +<del>For features not yet finalized: 
-see [[http://news.php.net/php.pdo/286]]+see [[http://news.php.net/php.pdo/286]] PDO_Driver::getNative()::asyncQuery(); </del>
  
-PDO_Driver::getNative()::asyncQuery();+Most drivers allow some kind of async query except MySQL, 
 +additional connections could be created to allow concurrent queries.
  
 +see [[http://news.php.net/php.pdo/330]]
  
 === PDO Persistent Connections === === PDO Persistent Connections ===
Line 71: Line 78:
 see [[http://news.php.net/php.pdo/233]] see [[http://news.php.net/php.pdo/233]]
  
 +=== Transaction ===
 +PDO transaction object
 +see [[http://news.php.net/php.pdo/322]]
 +
 +Possible problems:
 +  * error handling
 +  * nested transaction (emulation)
  
 ===== PDO Binding behaviour (5.3) ===== ===== PDO Binding behaviour (5.3) =====
internals/pdo/brainstorming.txt · Last modified: 2017/09/22 13:28 by 127.0.0.1

Page Tools