PostgreSQL. There is no question. I've used both (plus Informix). Stick to
open source databases! They place nice with a whole lot more things. Plus
PostgreSQL (PSQL) has I think the highest SQL Spec compliance.
MySQL is fast, provided you don't use transactions. It is a little more
friendly, but only because it makes a lot of assumptions. MySQL expects you
to verify your data before insert, PSQL doesn't. Triggers, operators, etc
are non-existent or experimental in MySQL. I don't think views exist either.
If you get a MySQL implementation and a PostgreSQL implementation, and
compare the two, you'll find similar speed over all, but the PostgreSQL
implementation will be more hardy.
If you're going to be basing your company (or a significant portion of it)
on a database, and you have to go between the two, go with PSQL!.
Just my $.02
> -----Original Message-----
> From: pgsql-advocacy-owner@postgresql.org
> [mailto:pgsql-advocacy-owner@postgresql.org]On Behalf Of Kaarel
> Sent: Tuesday, June 10, 2003 8:12 AM
> To: pgsql-advocacy@postgresql.org
> Subject: [pgsql-advocacy] Which database?
>
>
> Hi
>
> I am fairly new to databases, but my boss has assigned me to choose a
> database system for our company. I know of Oracle databases but they are
> way too expensive so it's not an option for us. I did some research and
> came up with two free database systems that seemed to be more popular -
> MySQL and PostgreSQL. The problem is that I can't make a decision
> between the two because I have practically no experience. Some say MySQL
> is easier to use, some say PostgreSQL is more robust etc. Most articles
> seem to celarly favor one or the other. It is very hard to find an
> objective comparison. And I have to explain my boss why I chose either
> one. So perhaps some of you can give me some reasons why to choose MySQL
> over Postgre.
>
> Thanks,
> Kaarel
> kaarel@future.ee
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
