Is anyone switching from MySQL?

[David Gerard]

2009/5/20 Scott <sclewin at sgaming.ca>:
> On May 1, 2009 09:58:21 am Samuel Thurston, III wrote:

>> I seriously recommend looking into ADODB for php.
>> http://adodb.sourceforge.net/  It not only greatly simplifies the
>> process of writing database code, but it also makes your app more
> or
>> less database agnostic.  If more people used an abstraction layer,
>> potential sea-changes wouldn't be such a big deal.  The other nice
>> thing is that it leaves the option of what database backend to use
> to
>> the end-user, and aren't we all about free choice around here?

> I am sorry about the late reply, but I thought I would just mention I am
> going to take your advice and try ADODB.  Thanks for the suggestion.


Note that there is, as one would expect with a little thought, a
performance penalty over writing DB-specific queries, and this can
affect large sites - there was discussion of ADODB on the wikitech-l
list (Wikimedia technical discussion) and someone there put using
ADODB instead of hideously overoptimised and tweaked MySQL at ~14-15%,
IIRC. The MediaWiki solution is its own app-specific DB access class
which translates the queries you'll need into DB-tweaked code for each
supported DB.


- d.