[Webdev] [Fwd: [ILUG] MySQL vs PostgreSQL]

[Niall O Broin]

On Mon, Nov 13, 2000 at 01:10:44PM -0000, Adam Beecher wrote:

> > > On saying that if he's applications require sixteen queries to
> > > generate a page he really should go do a sql 101 course.
> >
> I know. As soon as I get over two or three I start to worry.

Be fair here - you don't know what his application does, so how can you
judge whether or not his applications should not require sixteen queries to
generate a page. I have pages which require 5 queries to generate. I have
other pages which require multiple queries because MySQL doesn't support
subselects so I have to program my way around that with multiple selects.

I haven't read the piece mentioned yet, although I hope to later. Like many
people here, I'm considering switching from MySQL to Postgres because MySQL,
much as I like it for its speed and simplicity, has too many little niggly
bits, and I'd be very interested in reading other people's views.



Regards,


Niall