Re: Postgresql vs. Mysql

From: "Kris-Jon Fenton" <kfenton(at)pcpro(dot)net(dot)au>
To: <tom(dot)kemp(at)philips(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Postgresql vs. Mysql
Date: 2002-01-03 23:16:09
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

Hi Tom,

I was asked the same thing by my boss. I work for an Electricity Company in
Australia that bought the ISP I work for and they use multiple platforms. I
used PostgreSQL and they wanted to use MySQL. All of our databases where
running PostgreSQL and they had MySQL. There has been a complete re-shuffle
in the business with our guy being trained in the IT area and their guys
appear to have just fallen into the position. Here was part of my reply:

In planning what to use remember the following:

If 98% is sucking data - MySQL is the best solution - Has transaction logs
to replay backup databases.
MySQL - 1400% not a typo 1400% - faster than Oracle.

If you want a solution for general data entry, integrity, more generalised
system, transaction support and a little more robust system - PostgreSQL is
the best solution.

We can use either, what we do not want is to be trapped into dead-end

The thing we will need to modify are the replace and update statements for
the different languages but in general they are not that distant.

PostgreSQL and MySQL are multiplatform programs. The major problem with
Microsoft is that it is Microsoft based. You become trapped into using
Microsoft Programs but still remembering, PHP can call data from an SQL

BREAKDOWN: MySQL is faster. PostgreSQL has more functionality but is a
little slower.


-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of
Sent: Friday, 4 January 2002 7:49 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Postgresql vs. Mysql

Hi All,

I'm sure that this question gets asked a lot. Can someone reference me to
good material on why one would choose one vs. another? I greatly appreciate

I am designing a database (first ever, after reading a couple of texts) for
a company department that currently doesn't have one. I'm pretty
comfortable with the correctness of the structure and have a script ready to
build the database with SQL
commands. The table structure is such that it appears that many queries
would be calling other sub-queries (functions?). Other than that, there is
nothing special about the database. I plan to use php to interface the
database server with the internal
web and will run it on an HPUX environment machine with an Apache web

Thanks for the help.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fothergill 2002-01-04 13:22:53 test message
Previous Message Jason Earl 2002-01-03 22:40:27 Re: Postgresql vs. Mysql