pwnt.be

I just implemented post tagging, which means that I will be categorizing posts from now on. I have no intention of categorizing old posts though.

In case you’d like to know how I implemented it, this site is still open source. It should be noted, however, that the code is insanely complicated. I insisted on using a single query to fetch both posts and their tags, which meant multiple rows for one post, which meant my LIMIT clause no longer applied. Since MySQL doesn’t support LIMIT in subqueries, I ended up fetching the necessary IDs in advance and then retrieving the posts by ID. Yeah, it sucks, but I wonder if it’s any slower than a single query for every post’s tags.

Also, if you speak Dutch, you may be interested in B.’s shenanigans now that he’s arrived in the Land of Hope and Glory. I know I’m looking forward to reading all about it.