On Gwe, 2004-02-06 at 15:25, Post, Mark K wrote: > Recent versions of Postgresql (the last year or two) have matched, if not > exceeded MySQL in terms of speed. > > To directly answer the original question, there a probably literally > millions of Linux systems in the world running MySQL, to the point where > "LAMP" has become a recognizable name in the field: Linux-Apache-MySQL-PHP. > > Set it up, test it well for your application, and I think you'll be pleased > with it.
For small data sets mysql definitely works nicely, and does good things. Postgresql is a little more featureful in some respects. MySQL client libraries for MySQL4 and onwards are GPL which can be a problem if you are distributing applications using it to others, or in some other situations where licenses clash, however there are commercial supported MySQL licenses available for money which don't have that restriction, as well as support options.
