Re: [SQL] OT: Pros and cons about using POSTGRESQL and MYSQL

On Thu, 26 Aug 1999, Chris Bitmead wrote:

>
> MySQL doesn't have transactions. MySQL isn't object-relational like
> Postgres. Postgres is more extensible. Postgres has more powerful
> querying facilities. MySQL can be faster for simple stuff.

Postgres Pros:
* Transactions
* Foreign keys ( via refint )
* Triggers
* Subselects
* Views ( mostly )
* User-defined datatypes
* User-defined functions in a variety of languages: sql, c, pl/pgsql, pl/tcl
* Sequences
* Proper date handling

Postgres Cons:
* Somewhat slow for inserts and updates when compared to mysql ( due to
pgsql having to check for triggers and such )
* Some SELECT queries may be slower than their counterparts in MySQL.

MySQL Pros:
* Extremely fast

MySQL Cons:
* See all of Postgres's Pros, s/^/Lack of /g
* Improper date handling; one can insert '1999-02-32' into a DATE field.

ive got a somewhat dated comparison at
[www.toodarkpark.org/computers/dbs.html]...

>
> Hector M Banda wrote:
> >
> > Hi all, I'd like to ask some of the experience users of this group what
> > advantages or disadvantages do I have in running POSTGRESQL against MYSQL?
> >
> > Is it faster?
> > Is it easier to manage?
> >
> > I already have mysql up and running with visual basic as the client but I've
> > seen many posts about postgresql and I'm getting curious about it since both
> > work with LINUX.
> >
> > -hb
> >
> > ************
>
> ************
>

---
Howie <caffeine(at)toodarkpark(dot)org> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."