[wp-trac] [WordPress Trac] #37252: Generic driver access to database

[WordPress Trac]

#37252: Generic driver access to database
--------------------------+-----------------------------
 Reporter:  alain91gmail  |       Owner:
     Type:  enhancement   |      Status:  new
 Priority:  normal        |   Milestone:  Future Release
Component:  Database      |     Version:  4.5.3
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+-----------------------------
Changes (by pento):

 * milestone:  Awaiting Review => Future Release


Comment:

 Thank you for the ticket, @alain91gmail! We've discussed implementing a DB
 driver system in the past (#21663, for example), but I think now's a good
 time to start that discussion again.

 Your implementation reminds me a lot of @markoheijnen's
 [https://wordpress.org/plugins/wp-db-driver/ WP DB Driver] plugin, I'd
 absolutely recommend looking at that.

 Ultimately, the primary requirements for this to get into core would be:

 * 100% backwards compatibility. The changes in #21663 bore most of the
 pain of getting plugins to switch to using WPDB (instead of the
 `ext/mysql` functions), so that shouldn't be too much of an issue, but it
 does need to be considered.
 * Ease of use. We cannot make the WPDB interface more complex than it
 already is. About the only exception to that would be to provide a real
 query prepare interface.
 * Performance. We would need a good set of benchmarks to show that the
 change doesn't have a negative effect on performance or memory usage.
 Ideally, I'd like to see performance improvements.

 As a side note, we won't be able to drop `ext/mysql` support until
 WordPress officially drops PHP 5.5 support, which isn't on the roadmap
 (and isn't the topic of this ticket).

--
Ticket URL: <https://core.trac.wordpress.org/ticket/37252#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform