On: The Decline of MySQL?

[veyron]

It's not really a functionality issue. MySQL just works.

The PHP API is incredibly direct and there's little development overhead.

Postgres on the other hand always felt kludgy for small projects. Just getting it up and running and creating databases took longer than with mysql. And phpMyAdmin is a tool most people are familiar with, for which I can't even think of the postgres analogue.

Pardon my butchering of the phrase but postgres is a hammer and mysql is a scalpel, and most projects call for a scalpel.

[yummyfajitas → veyron]

Compare:

    $ sudo aptitude install mysql-server
    $ echo "CREATE DATABASE dbname;" | mysql

    $ sudo aptitude install postgresql-9.1
    $ createdb -U postgres dbname

    mysql_query("SELECT * FROM foo...");

    pg_query($db_handle, "SELECT * FROM foo...");

http://www.freewebmasterhelp.com/tutorials/phpmysql/4

http://www.techrepublic.com/blog/howdoi/how-do-i-use-php-wit...

I haven't used phpMyAdmin, so I won't comment on that.

[bbwharris → veyron]

Right. The same scalpel that when told to not insert a null value will make a decision to insert an empty string.

MySQL works but it was always a hack. PostgreSQL is superior and has been a superior solution for quite some time.

I'm sad to see MySQL go, but I find that Postgres works just as well.

[rimantas → bbwharris]

You forgot to mention, that MySQL has no transactions support.

Seriously, before claiming your beloved choice as "superior solution" would you mind as much as to learn something about competition you dismiss as inferior?

For one I cannot wait PG go become popular—maybe when more people start to use it and start to shoot themselves in the feet will they shut-up about superiority.

[unoti → rimantas]

Mysql has had quite solid transaction support for many, many years. It hasn't been the play database you think it is for a very long time. This seems like an important topic to you so you should seriously consider looking in to it.

[randallsquared → unoti]

He was being sarcastic. It's the kind of thing people keep saying even though it hasn't really been true for a while.

[bbwharris → rimantas]

MySQL was great, we all loved it. It allowed many real businesses to make real money without the overhead. Then the oracle thing happened. In the end they are all just tools. Its not really interesting to have a religious debate over tools.

[barefoot → rimantas]

No transactions support?

http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transaction...

[ecocentrik → veyron]

Try phpPgAdmin as an analogue to phpMyAdmin. Note: I've only used it for small projects.