Re: Differences between postgres and mysql - Mailing list pgsql-general

From Jeff Davis
Subject Re: Differences between postgres and mysql
Date
Msg-id 1077142754.23097.45.camel@jeff
Whole thread Raw
In response to Differences between postgres and mysql  ("Mark Cubitt" <mark.cubitt@applegate.co.uk>)
List pgsql-general
On Wed, 2004-02-18 at 03:50, Mark Cubitt wrote:
> the reason I ask is I have always used postgres at home and work, but my new
> web host only has mysql :(
>

If you have ssh or other shell access, you can install postgresql as a
user (you may want to check with your ISP first). It will require a
little extra disk space though.

> I want to know what sort of differences I will have in regards to
> programming php/perl webpages using the database.

There are too many issues here to make a brief reply. I'd just look
around for migration tips pg->mysql (although I get a feeling that case
is more rare than mysql->postgres...). In general, don't assume too much
when working with MySQL. MySQL tends to throw fewer errors, so testing
the results will be more important.

Regards,
    Jeff


pgsql-general by date:

Previous
From: "Cyril VELTER"
Date:
Subject: Prepared statements and cursors
Next
From: "Ed L."
Date:
Subject: wishlist: dynamic log volume control