On Thu, Oct 9, 2008 at 9:08 PM, Dave Ewart <[EMAIL PROTECTED]> wrote: > 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. thank you, it seems i prefer PostgreSQL :) > -- > Dave Ewart > [EMAIL PROTECTED] > 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 > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.6 (GNU/Linux) > > iD8DBQFI7gJobpQs/WlN43ARAnCnAJ9taJV8nUxAT0g3yrJaQneQdxY7CQCgjaZp > r35z4o/WwZYuHsK/Y1lUsGE= > =VioS > -----END PGP SIGNATURE----- > >
-- MY IMs, Welcome to add me as a debian user or a web developer! (msn) [EMAIL PROTECTED] (xmpp) [EMAIL PROTECTED] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]