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@toodarkpark.org>   URL: http://www.toodarkpark.org    
"The distance between insanity and genius is measured only by success."