Home Messages Index
[Date Prev][Date Next][Thread Prev][Thread Next]
Author IndexDate IndexThread Index

Re: [wp-hackers] alternative database support

On 10/8/06, Matt Mullenweg <m@xxxxxxxxxxxxx> wrote:

WordPress doesn't do anything that fancy with the database. There is feature-comparable software driven purely by text files.

OTOH, that ought to make DB-independence easy. :P

1) Infinitely more complex testing (we have enough trouble with W/LAMP)

*cough* Unit tests. *cough*

Lastly, as someone pointed out, $wpdb is structured as such that all the
hard work could be done as a $wpdb replacement with some clever regex,
with no core modifications. (Aka, a plugin.)

There might still be other problems: does `dbDelta()` need to be fully pluggable?

The dynamic query replacement could be better. If WordPress made use
of prepared statements, for example, frequently-used queries could be
substituted with a single lookup in a hash table.

I mean, something like this (PDO style):

   $stmt = $wpdb->prepare("SELECT post_status, comment_status
                           FROM :post_table WHERE ID = :comment_post_ID");

   $stmt->bindParam(':comment_post_ID', $comment_post_ID);
   $stmt->bindParam(':post_table', $wpdb->posts);

   $status = $stmt->execute();

The query sent to `prepare()` could be a key in a MySQL->SomeOtherSQL
map array -- much faster. That's on top of the other benefits of
prepared statements, obviously, like automatic escaping and repeated
queries.
_______________________________________________
wp-hackers mailing list
wp-hackers@xxxxxxxxxxxxxxxxxxxx
http://lists.automattic.com/mailman/listinfo/wp-hackers

[Date Prev][Date Next][Thread Prev][Thread Next]
Author IndexDate IndexThread Index