Is anyone switching from MySQL?
Samuel Thurston, III
sam.thurston at gmail.com
Fri May 1 14:58:21 BST 2009
On Sat, Apr 25, 2009 at 8:12 PM, Scott <sclewin at sgaming.ca> wrote:
> With the uncertain future of MySQL due to Oracle's purchase I am
> thinking about using PostgreSQL instead of MySQL for my PHP
> applications. I am still fairly new to database programming so I was
> thinking about changing now should be easier than waiting to see what
> happens. I was just wondering if anyone else was thinking anything
> similar and if anyone haves any words of wisdom or suggestions.
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?
> If possible, I don't want to start a flame war. Personally, I have no
> special connection or love for MySQL and have only briefly looked at
It's kind of funny, I think most people who haven't invested heavily
in MySQL training agree that Postgres is more full-featured.
(cascading deletes and updates! WOW!) 99% of applications don't
really bottleneck on database performance anyway. But I think that
MySQL is still used by a lot of folks out of sheer convenience... it's
what i learned first, it's what I know, etc.This is just my anecdotal
experience though, no facts to back it up.
More information about the sounder