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 |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
