Thread: OT: Pros and cons about using POSTGRESQL and MYSQL
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
[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, Pennsylvania19026
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 > > ************
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."