Is anyone switching from MySQL?

[Samuel Thurston, III]

Hi Scott,

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
> PostgrSQL.
>

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.

Regards,
Samuel Thurston
http://diasadesign.com/