Apologies if anyone’s had trouble with the blog in the last few days.
I recently escaped Stalag MySQL and the postgresql schema load zeroed the id field sequences , so comments (ok, spam) probably weren’t publishable.
Articles certainly weren’t.
I must’ve lucked out on my test post – id 1 must have been free, so the constraint didn’t grumble.
Other than that and a wierd timewarp thing I’m really glad I switched. I’ve always disliked mysql, but on TextDrive there are more good reasons to switch.
- you don’t need to supply a password to psql, so you can cron backups in without all the worries about password safety
- dedicated db boxes are on the cards. I want to be on the pgsql server with the 2 dozen other guys rather than the mysql server with a bazillion php users (no offence boys, just a load thing).