Tag Archives: mysql

MySQL vs PostgreSQL

At work, we’ve just started converting one of our projects to use MySQL instead of the present PostgreSQL. Due to client orders, you understand. Unfortunately, after using PostgreSQL, coming up against MySQL reveals how bizarre, baroque and arbitrary it is. CREATE TABLE automatically creates a transaction. So much for that schema loading script undoing its […]

Makeovers

I’ve just switched the theme on this blog to Origami, winner of the typo theme contest. Whilst I think it looks good, it feels a bit slow. And I really dislike the Flash technique for replacing the texts of the headlines. It means you can’t select the text properly any more. So the theme may […]

Blogging Software

It started innocently enough, but as usual turned into yak shaving rather quickly. I wanted to try out some graphical editors for posting to my blog. Sounds simple enough. Except that a while back, I chose wordpress-pg. Its a version of wordpress, but it talks to PostgreSQL instead. Except that for some reason, my copy […]

SiteBar

SiteBar looks useful. And it has a firefox extension… But their server software needs MySQL. I like PostgreSQL. Bah. That sounds like work. Thankfully, their database abstraction looks reasonably clean. Oh well, here we go. Update: no, the mysqlisms are too deeply embedded. Or at least, I don’t know how to sensibly deal with assumptions […]

wordpress & backslashes

One of my pet peeves about wordpress is that because it’s based on PHP and MySQL it doesn’t like backslash characters at all. It just eats them up and screws up your post. But I’ve found a simple answer. Use numeric entities instead. Just type in \ or \ to get a nice \backslash.