On Thu, Oct 9, 2008 at 9:08 PM, Dave Ewart <firstname.lastname@example.org> 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.
thank you, it seems i prefer PostgreSQL
> Dave Ewart
> 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)
> -----END PGP SIGNATURE-----
MY IMs, Welcome to add me as a debian user or a web developer!
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact email@example.com