[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:  Future
Component:  Database                             |  Release
 Severity:  normal                               |     Version:  3.5
 Keywords:  dev-feedback has-patch needs-        |  Resolution:
  testing                                        |
-------------------------------------------------+-------------------------

Comment (by RicaNeaga):

 Noticed that #5932 it's going to be, quote,''' ''tackled in 3.8, probably
 with mysqli at the same time.'' '''I feel the need to comment on this:

 '''1. I fully trust the decision of the wordpress team, to go either with
 PDO, either with mysqli.'''

 '''2. I hope the (potential) discussion mysqli vs. PDO will be very
 brief''', and a conclusion will be reached before wp 3.8 beta 1 lands, so
 ''full'' support for php 5.5 will be added in wp 3.8. Early adopters can
 react to PDO / mysqli (probable) bugs with php 5.5, before php 5.6 will
 land (that will not resume to only deprecated errors).

 '''3. I'm sure you're aware''' both major competitors (joomla & drupal)
 already support other databases (like PostgreSQL) - drupal via PDO, or
 that Oracle has a history of making [http://techcrunch.com/2012/08/18
 /oracle-makes-more-moves-to-kill-open-source-mysql/ weird decisions]
 regarding mysql, or that both major Linux distributions and Google
 '''NOW''' prefer [http://www.zdnet.com/google-quietly-dumps-oracle-mysql-
 for-mariadb-7000020670/ MariaDB over mysql].

 '''But I hope you'd also consider when choosing between mysqli and PDO
 which solution is the most ''future-proof''. '''Maybe at some point Oracle
 will give everyone reasons to look for alternatives, and when that time
 comes, a ''good'' decision taken now would help. For example, the
 possibility to use mysqli as an extension for php also with MariaDB is
 important, but is MariaDB sufficient when it comes to alternatives for
 mysql?

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