What can PostgreSQL learn from MySQL

Previous | Next

By bloid
via postgresonline.com
Published: May 04 2008 / 14:16

There has been a lot of talk lately about PostgreSQL and what MySQL can learn from the PostgreSQL clan. We would like to look at the reverse of that. This article is a bit of a complement to Joshua Drake's What MySQL (and really, Sun) can learn from PostgreSQL. First of all a lot of staunch advocates of PostgreSQL wonder what exactly is it that MySQLers see in that beast of a database or as Martin Mickos likes to call it The Ferrari of databases?

Vote up

Vote down

21
0
1961
617

Save Send Tags: database

Upcoming Links

See all the newest links

Comments

Add your comment

Kenneth Downs replied ago:

0 votes

An extremely insightful article. I'm a postgres user myself, and I use it for the technical merits -- mySQL just doesn't have the brains for what I do.

But with that said, I sure as hell wish the postgres developers would figure out that it is a SERIOUS BUG that we have to dump and reload our databases on every upgrade. They claim the merits of each new version as being worth the trouble, but it is a staggering lack of recognition of the value of my time and my customers' time. Postgres punishes you for using it, the more you use it, the stiffer the punishment.

If they read this article and took it to heart the results would be, as Steve Jobs loves to say, "insanely great." We'd have all of the killer power of Postgres with respect for the time and efforts of the people who depend on it. I still hold out hope, but when mySQL catches up on the technical front it will be harder to stay with Postgres.

planetmcd replied ago:

-1 votes

Good point Ken. I too am an avid postgres user, but the upgrade is a pain. Does anyone know how easy or hard an upgrade is with Oracle, DB2, or SqlServer? When I worked in an Oracle shop we had a top notch DBA nad she just took care of it. If it was easy or hard, it was invisible to the developers.

Lately I've been finding myself using SQLite3 instead of MySQL where I'm not as worried about database robustness. I wonder how much SQLlite is/will take away the userbase for MySQL that uses it as a basic storage engine.