On Thu, 6 Apr 2000, Federico Sevilla III wrote:
..
> In what ways is MySQL better than PostgreSQL, and in what ways is it
> the other way around? This also brings us to: for what applications
> (real world) will MySQL be a better solution compared to PostgreSQL,
> and for what applications will it be the other way around?
MySQL:
- faster
- simpler
- easy to install
- very reliable (try www.persiankitty.com :)
- very usable ODBC drivers (ODBC 2.5)
but:
- no transactions
- no subqueries
PostgreSQL:
- has transactions
- has subqueries
- better SQL92 conformance
but:
- slower
- allegedly less reliable
- troublesome to install (until you see Oracle.. :)
- subpar ODBC drivers (ODBC 1.0/2.0)
> No, I don't need this to answer some paper in school (hahaha). I need
> some help deciding which to use for the office. :-)
If I were you and your data is worth any amount of money, I would stay
away from PostgreSQL. The ODBC drivers are only ODBC 1.0/2.0 level (which
means Access97 will function suboptimally with them) and I've heard bad
things about the reliability of PostgreSQL.
MySQL is fine, but it has a tendency to thrash under high read/write
conditions, sometimes locking up. When it does lock up, the tables are
left in an inconsistent state, and if you forget to run isamchk you'll
lose data..
MySQL 3.23.x has a built-in myisamchk (it automagically runs the isamchk
on startup if the tables are inconsistent, so this should be less of an
issue) but 3.23.x is still in alpha-level (Monty calls it alpha, but it's
beta-level actually, it passes the test suite).
> - web via PHP3 / PHP4 (hope I get it to work)
> - web via Perl
Almost all databases can be accessed with the above methods.
> - M$ Acce$$ 97 via ODBC
PostgreSQL problematic here. MySQL is tested and works 99% (MS Access 97
actually requires ODBC 3.0 compliance, since MySQL is only 2.5-level, you
get occasional weirdness, e.g. "#Deleted#" rows appearing in linked
tables).
The only 3.0-compliant ODBC drivers I've seen are the MS SQL (updated, in
the data access kit) and Oracle (in the 8.0.5 distribution CD for NT).
> Perhaps also it may help us to limit this comparison to MySQL 3.22.32
> and PostgreSQL 6.5.3, both running on a Linux box running on a Celeron
> 400MHz with 128MB of RAM. :-)
You might want to wait for the final release of Interbase 6.0. It has a
complete ODBC and Delphi driver suite, open source, and the US 911 system
uses it, so it _must_ be reliable.
---------------------------------------------------------------------
Orlando Andico <[EMAIL PROTECTED]> +63 (2) 937-2293
Mosaic Communications, Inc. +63 (917) 531-5893
Any sufficiently perverted technology is indistinguishable from Perl.
-
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
