On Thursday, 09.10.2008 at 19:38 +0800, Star Liu wrote: > >> I'm new to PostgreSQL and MySql, which database server should i use > >> first? thanks! > > > > What do you want to do ? Which requisites do you need ? PostgreSQL > > is a community only database server and MySQL has a community and > > enterprise version (with support and you need to pay for it). > > I'm a web developer, I have just moved myself from windows platform to > linux platform, so i need a database to replace microsoft sql server. > Is there any difference in code/usage/performance between the > community and enterprise verion of mysql server? How to compare mysql > and postgresql? This discussion is a notorious can of worms ;-) MySQL and PostgreSQL are both good enough for most basic web development cases, generally speaking. The major differences, in my experience of using both, are: - MySQL tends to be used by many out-of-the-box web applications; - PostgreSQL is generally considered a more robust database, whereas (certainly in the past) MySQL has had accusations of playing fast and loose with data integrity on occasions. This may no longer be true; - MySQL is probably faster for simple largely read-only scenarios, although this will be implementation- and application-dependent; - PostgreSQL has a BSD-style license, meaning it can be used in some situations when MySQL cannot, e.g. when selling/bundling/distributing an application you have written (This issue is complicated and a gross simplication: there are no restrictions on actual use, of course); - etc. Dave. -- Dave Ewart davee@ceu.ox.ac.uk Computing Manager, Cancer Epidemiology Unit University of Oxford / Cancer Research UK PGP: CC70 1883 BD92 E665 B840 118B 6E94 2CFD 694D E370 Get key from http://www.ceu.ox.ac.uk/~davee/davee-ceu-ox-ac-uk.asc N 51.7518, W 1.2016
Attachment:
signature.asc
Description: Digital signature