pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedOT: 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