Re: [GENERAL] interesting PHP/MySQL thread

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Eric Frazier" <ef(at)kwinternet(dot)com>
Cc: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Josh Berkus" <josh(at)agliodbs(dot)com>, "Joe Conway" <mail(at)joeconway(dot)com>, "Advocacy (PostgreSQL)" <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: [GENERAL] interesting PHP/MySQL thread
Date: 2003-06-23 04:29:40
Message-ID: 022e01c33940$11a37100$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general

> 3.2.23 was a LONG time ago. One thing I like about mysql is that they are
> constantly making major improvements.

What?? What "major" improvements? They haven't had a major improvement for
years! Their roadmap has had "foreign key support" on it back when I first
started using it 5 years ago!!!

In that same time, PostgreSQL has added:

* write-ahead log
* full subselect support
* almost all sql92 constructs
* schemas
* domains
* constraints
* triggers
* rules
* casts, conversions
* full support for different encodings
* prepared queries
* dependency tracking
* set-returning-functions
* table statistics based query planner
* full transaction support
* unlimited field sizes, all of it can be indexed instead of the first n
bytes!
* thousands of nameless improvements
* information_schema
* hash aggregates
* PLUS we already had all the "new" stuff that MySQL is adding (eg. GIS,
rtree indexes)

And what has MySQL done? Replication and built-in full text indexing?
UNIONs as well - hooray! Big deal.

> I have asked this before, where is
> Replication with PostgreSQL? If there was a system that could handle more
> than one master without hacking, I would seriously look into switching to
> PostgreSQL again. Currently mysql can't handle more than one master
cleanly.
> Lack of built in Replication is the main thing that continues to keep us
> from using PostgreSQL. All of the little, "baby can't learn how to
program
> or write SQL functions" don't do crap for me, but Replication is a large
> part of our network structure, we can't do without it and we certainly
don't
> want to use a third party product. Patching together tools like what
happens
> with a qmail install is not a system I want to be responsible for. And yet
I
> like qmail a great deal, and I like what I have seen of PostgreSQL.

Replication is a big feature, and it happens to be one that PostgreSQL
doesn't really have. If you NEED it, then PostgreSQL might not be for you.
However, the entire .org domain is run of replicated PostgreSQL servers
using eRserver I think. Why don't you want to use a 3rd party product?

Chris

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Tom Lane 2003-06-23 04:35:24 Re: [GENERAL] interesting PHP/MySQL thread
Previous Message Sean Chittenden 2003-06-23 04:22:59 Re: [GENERAL] interesting PHP/MySQL thread

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-06-23 04:35:24 Re: [GENERAL] interesting PHP/MySQL thread
Previous Message Sean Chittenden 2003-06-23 04:22:59 Re: [GENERAL] interesting PHP/MySQL thread