Re: How about MySQL in 64bit Debian?
On Thu, Oct 9, 2008 at 9:08 PM, Dave Ewart <davee@ceu.ox.ac.uk> 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
> 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
>
> -----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) starliu@live.com
(xmpp) minxinjianxin@gmail.com
Reply to: