pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
OT: Pros and cons about using POSTGRESQL and MYSQL
4+ messages / 4 participants
[nested] [flat]

* OT: Pros and cons about using POSTGRESQL and MYSQL
@ 1999-08-26 03:13  Hector M Banda <hector@imperial.cc.ca.us>
  0 siblings, 2 replies; 4+ messages in thread

From: Hector M Banda @ 1999-08-26 03:13 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] OT: Pros and cons about using POSTGRESQL and MYSQL
@ 1999-08-26 04:12  Bruce Momjian <maillist@candle.pha.pa.us>
  parent: Hector M Banda <hector@imperial.cc.ca.us>
  1 sibling, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 1999-08-26 04:12 UTC (permalink / raw)
  To: Hector M Banda <hector@imperial.cc.ca.us>; +Cc: pgsql-sql

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> 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.
> 

Check www.postgresql.org documentation page for FAQ entry on this.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] OT: Pros and cons about using POSTGRESQL and MYSQL
@ 1999-08-26 04:38  Chris Bitmead <chris@tech.com.au>
  parent: Hector M Banda <hector@imperial.cc.ca.us>
  1 sibling, 1 reply; 4+ messages in thread

From: Chris Bitmead @ 1999-08-26 04:38 UTC (permalink / raw)
  To: Hector M Banda <hector@imperial.cc.ca.us>; +Cc: pgsql-sql


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.

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
> 
> ************



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] OT: Pros and cons about using POSTGRESQL and MYSQL
@ 1999-08-27 00:57  Howie <caffeine@toodarkpark.org>
  parent: Chris Bitmead <chris@tech.com.au>
  0 siblings, 0 replies; 4+ messages in thread

From: Howie @ 1999-08-27 00:57 UTC (permalink / raw)
  To: pgsql-sql@postgreSQL.org, Hector M Banda <hector@imperial.cc.ca.us>; +Cc: caffeine@toodarkpark.org

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."





^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~1999-08-27 00:57 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-26 03:13 OT: Pros and cons about using POSTGRESQL and MYSQL Hector M Banda <hector@imperial.cc.ca.us>
1999-08-26 04:12 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-08-26 04:38 ` Chris Bitmead <chris@tech.com.au>
1999-08-27 00:57   ` Howie <caffeine@toodarkpark.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox