Re: Differences between postgres and mysql

On 18/02/2004 11: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 :(
>
> I want to know what sort of differences I will have in regards to
> programming php/perl webpages using the database.
>
> I current use sequences in postgres and understand this will be different
> in
> mysql, so can you tell me what the difference will be and if there are
> any
> other differences I should look out for.

I think MySQL has auto-increment columns instead. As for the rest of the
differences, I couldn't supply a full list but from what I know:

- transactions are only supported on InnoDB tables
- foreign keys only supported on InnoDB tables
- no sub-queries
- no stored procedures
- no triggers or constraints
- crap/non-existent range checking
- no views
- don't expect adherence to SQL standards

No doubt others will be able to correct/expand this list. I haven't used
MySQL for about 4 years and always _detested_ it. Happily, on migrating to
Linux, I discovered PostgreSQL  and I've not touched MySQl since :)

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+