[wp-trac] [WordPress Trac] #21663: Use PDO for MySQL queries when PDO is available

[WordPress Trac]

#21663: Use PDO for MySQL queries when PDO is available
--------------------------------------------------+------------------
 Reporter:  scottconnerly                         |       Owner:
     Type:  task (blessed)                        |      Status:  new
 Priority:  normal                                |   Milestone:  3.6
Component:  Database                              |     Version:  3.5
 Severity:  normal                                |  Resolution:
 Keywords:  dev-feedback has-patch needs-testing  |
--------------------------------------------------+------------------

Comment (by kurtpayne):

 From [https://irclogs.wordpress.org/chanlog.php?channel=wordpress-
 dev&day=2013-01-16&sort=asc#m534381 IRC today], the prevailing thought is
 to dump mysqli support and probably the driver system, too.

 My original thoughts when writing this:  Get off of the old mysql
 extension.  If PDO is available, great.  If not, jump onto mysqli.  The
 original cause for the ticket was "mysql is going to be deprecated."  I
 don't know of a firm method or date for that deprecation, though.

 mysqli doesn't buy us anything over PDO.

 What are our options?

 1. Keep the new system, it's fine
 2. Drop the mysqli driver
 3. Drop the new system and rewrite wp-db to just have PDO
 4. ???

 It doesn't look like !WordPress will easily support other database engines
 (e.g. sqlite) at this point without rewriting queries or abstracting out
 the database layer further.

 Considerations:  How will this impact hyperdb?  What can we do to add
 value while we're under the hood?

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/21663#comment:49>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software