3 ms·

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

by veyron 14y ago

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.

bbwharris 14y ago
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 14y ago
  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.
  - barefoot 14y ago
    No transactions support? http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transaction...
  - unoti 14y ago
    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 14y ago
      He was being sarcastic. It's the kind of thing people keep saying even though it hasn't really been true for a while.
    - deleted 14y ago
      [deleted]
  - bbwharris 14y ago
    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.
ecocentrik 14y ago
Try phpPgAdmin as an analogue to phpMyAdmin. Note: I've only used it for small projects.
yummyfajitas 14y ago
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.freewebmasterhelp.com/tutorials/phpmysql/4 http://www.techrepublic.com/blog/howdoi/how-do-i-use-php-with-postgresql/110 http://www.techrepublic.com/blog/howdoi/how-do-i-use-php-wit... I haven't used phpMyAdmin, so I won't comment on that.
- deleted 14y ago
  [deleted]

by veyron 14y ago

bbwharris 14y ago

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 14y ago
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.
- barefoot 14y ago
  No transactions support? http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transaction...
- unoti 14y ago
  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 14y ago
    He was being sarcastic. It's the kind of thing people keep saying even though it hasn't really been true for a while.
  - deleted 14y ago
    [deleted]
- bbwharris 14y ago
  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.

ecocentrik 14y ago

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

yummyfajitas 14y ago

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.freewebmasterhelp.com/tutorials/phpmysql/4 http://www.techrepublic.com/blog/howdoi/how-do-i-use-php-with-postgresql/110 http://www.techrepublic.com/blog/howdoi/how-do-i-use-php-wit... I haven't used phpMyAdmin, so I won't comment on that.

deleted 14y ago
[deleted]