Re: Which database?

From: Ewald Geschwinde <webmaster(at)geschwinde(dot)net>
To: Kaarel <kaarel(at)future(dot)ee>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Which database?
Date: 2003-06-10 12:15:56
Message-ID: 3EE5CBFC.2040009@geschwinde.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

Kaarel wrote:

> 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(at)future(dot)ee
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
Depends on your needs
Mysql for smaller things.

Postgresql for bigger projects.
Stored procedures, triggers.
Can handle big amounts of data (1 Billion I have seen ).
It's more ansi compliant than mysql.

The conclusion is: if you have a small non critical applikation that
have only selects you better go with mysql.
But if the thing will get bigger you will get to it's limits.

This problem you don't have with postgresql

Regards Ewald Geschwinde

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Merlin Moncure 2003-06-10 12:26:13 Re: Which database?
Previous Message Kaarel 2003-06-10 12:12:13 Which database?