On Wed, 2004-02-18 at 06: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. >
There's a little voice telling me this is a troll, but in case not, take a look at http://techdocs.postgresql.org/#convertfrom which has several article on converting from mysql to postgresql... not exactly what you're doing but might have some valuable info. You might also want to look at http://openacs.org/philosophy/why-not-mysql.html, which is an outdated comparison that breaks out several areas where mysql is not as robust as postgresql. Otherwise I guess I would recommend you ask the mysql community how they work around any missing postgresql features you might need for your apps. Well, actually I would recommend finding a new hosting company (http://techdocs.postgresql.org/hosting.php) but barring that I think your going to have to turn to the mysql community for information about their database. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])