Saturday, December 24, 2005

MySQL - PostgreSQL

This blog post has moved. Please find it at:

http://www.mpopp.net/2005/12/mysql-postgresql/.

5 comments:

Chris Miller said...

I am really interested in hearing more about the differences. It has been a couple months since you wrote this, do you have any updates?

Markus Popp said...

Recently, I didn't do so much with PostgreSQL (more with Java, at the moment) - but when I return to PostgreSQL, there will certainly be more about this topic ;-).

Anonymous said...

PostgreSQL stores its user information inside the database as well.

select * from pg_user;

Will show you certain non-private user information if you have enough privilege, for instance. I don't know of any documentation listing all the system tables and what they are for, though.

Markus Popp said...

Is it also possible to edit the user data in the pg_user table?

It wouldn't be that evil if it wouldn't be possible. However, I find it convenient that MySQL offers the option to directly edit privilege data.

Anonymous said...

As I know MySQL much better than PostgreSQL


After that I stopped reading.
You can't seriously be saying MySQL rocks, because it seriously doesn't.