WordPress, a database and a Geek
The Good
Launching your own blog these days got to the point where it’s easier done than writing ‘Hello World!’ in perl and with the ongoing nagging of some specific friends I’ve decided to finally give in and join millions of geeks, nerds, gamers and the occasional normal person and social reject in socializing and communicating the Web 2.0 way.
Of course there’s still a lot to do, but I seem to be heading in the right direction. Atleast no one has tried to fire or sue me yet for certain contents on my blog and I’d really really appreciate it if it stayed that way. As for me, yes - a thorough about page is in the works and a picture might also appear in the middle of your screen while you’re reading your favorite Harry Potter book instead of taking out the garbage.
Introduction been made, the garbage taken care of, let’s get down to business:
The Bad
Apparently the people over at WordPress are of the enthusiastic opinion that MySQL is the way to go and that PostGRE is nowhere to be found on their priority lists, so they scrapped a decent ORM altogether and decided that enforcing sticking with MySQL is the choice that is the most appealing to the average users.
Beeing quite the geek myself, I would really like to see the person who made this call. I desperately tried to figure out whether WordPress is salvagable or not, if an ORM implementation would be possible and how long it would take to get it running on a level which doesn’t crash the interwebz™.
So as every other coder out there with a brand new idea and too much time on hand does, the first thing you do before you start drooling over your new baby is Googling and finding out if anybody has tried to invent the hot water before you. Apparently they have. And they’ve failed. Not only are some of the implementation even sloppier than the default MySQL one (which is plain horrible), you also have to work with archaic versions of WordPress and are forced into an underdog spot of waiting for some poor social reject to finally port the version which came out 5 months ago. This suspiciously smells of Linux-Gaming-Syndrome.
Despising the latter with utter hate, me, my insanity and the voices in my head decided that the odds are against us and we’re better off just going with the flow…
Welcome to my WordPress Blog
The Ugly
Having a hardcore geek mentality, it’s a real pain in the rectum to run something as wonderful as this blog on something so badly written (I won’t even go to the part with deprecated functions, more on that in future posts) although it’s rather extensible and shiny when you give it some loving templates.
It’s occasionally quite slow for some apparent reason, primarily due to the second-grade caching which is decent at best. Selective caching of certain pieces of the page anyone? Yes please! (Goes right unto the to-do list… Actually a to-do list plugin would be awesome too.) Certainly I have plans to make some minor upgrades sooner or later, which I’ll gladly make public and share with other ranting codemonkeys.
This place could surely use some optimizations, some new nifty tools and features, plug in some jQuery and gracefully degrade the whole story for all the Lynx and Mobile viewers. Given my current blogging-fever, most of these should pop up rather soon and if WP Super Cache is willing, you’ll actually get to see it the next time you’ll wander onto this site.


July 9th, 2008 at 12:32 am
Welcome to the Web 2.0 world. You were missed
July 9th, 2008 at 11:40 am
“It’s occasionally quite slow for some apparent reason” .. apparent reason is hosting service and not badly written software … get Slovenian hosting and see the difference.
I like MySQL
postgree is an elephant.
July 9th, 2008 at 11:54 am
@ruph: “get Slovenian hosting and see the difference”
Slovene hosting is bulky, ‘cept if I get something of my own up. Still, 100-150ms to the server doesn’t account for the occasional slow-downs here and on the admin panel. Fake cache included.
July 9th, 2008 at 3:10 pm
believe you me it’s the hosting (or the line to the states)… pick slovenian wordpress blog and do the f5 tests.
July 9th, 2008 at 3:14 pm
Hmmm … it’s the hosting in most of the cases, most probably in yours also. I can imagine that is slow in some cases that include 3rd party services.
Oh, yeah… Congrats on the blog! looks nice… very web 2.0.
July 23rd, 2008 at 5:03 pm
This kinda reminds me of my very own first blog post