I have looked at both for an MMO I am looking into making. However, from a beginner’s standpoint, which is the best to use. eg: can support the most people etc, is more useful.
Just which is best?
There is a comparison of features of various databases here. MySQL is the database traditionally used with PHP (in fact web applications generally) and so you are likely to have a wider choice of hosts than with PostgreSQL. On the other hand, PostgreSQL is a semi-academic project which aims for completeness of implementation (SQL features, indexing options, etc) so this might be a better choice if you expect to make complex queries.
Cheers mate, I’l try out PostgreSQL, it seems to have a lot of helpful documentation.
just to add an option for you, i got into the MMO class going on over at 3D Buzz, and they have chosen to use Raven DB over any sql’s, might want to look into that.