Re: Differences between postgres and mysql
От | Paul Thomas |
---|---|
Тема | Re: Differences between postgres and mysql |
Дата | |
Msg-id | 20040218122053.A10703@bacon обсуждение исходный текст |
Ответ на | Differences between postgres and mysql ("Mark Cubitt" <mark.cubitt@applegate.co.uk>) |
Список | pgsql-general |
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 | +------------------------------+---------------------------------------------+
В списке pgsql-general по дате отправления: