This is all about db4free.net and the database systems that it offers. The main focus are practical examples of the new features of MySQL 5 and 6 that should show you how to use them for your advantage in your daily life ;-).
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 ;-).
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.
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?
ReplyDeleteRecently, 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 ;-).
ReplyDeletePostgreSQL stores its user information inside the database as well.
ReplyDeleteselect * 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.
Is it also possible to edit the user data in the pg_user table?
ReplyDeleteIt 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.
As I know MySQL much better than PostgreSQL
ReplyDeleteAfter that I stopped reading.
You can't seriously be saying MySQL rocks, because it seriously doesn't.