Back…. Maybe

I had stopped updating this blog after I started seeing this domain name as the the virus instead of just a short hand for “beehive”.

But, seeing as this has been my most continuous web presence, I think I’ll just need to get over it. See the large bee in the header? Onward!

Tongue Twisters in SQL

I was playing round the other night can came up with this SQL to solve a popular tongue twister:

SELECT
COUNT(woodpile.is_chucked)
FROM
woodpile,
woodchuck
WHERE
woodchuck.can_chuck = 1
AND
woodpile.is_chucked = 1

Here is another one:

SELECT COUNT(pepper.picked) FROM pepper WHERE pepper.picked_by = ‘Peter Piper’

A couple more with the tongue twisters:

Which wristwatches are Swiss wristwatches?

SELECT watch.* FROM watch WHERE watch.make = ‘Swiss’

Which witch wished which wicked wish?

SELECT witch.name FROM witch WHERE witch.wish_type = ‘wicked’ AND witch.type = ‘wicked’

Who washed Washington’s white woolen underwear
when Washington’s washer woman went west?

SELECT
washer.name
FROM
washer
WHERE
washer.gender = ‘female’
AND
washer.went != ‘west’
AND
washer.washed = ‘underwear’
AND
washer.fabric = ‘wool’
AND
washer.washed_for = ‘Washington’

Do too many posts overwhelm readers?

Problogger asks: What makes you unsubscribe from a blog’s RSS feed?

There is some interesting insight in the comments. I have tried to compile a summary of the comments so far. (I’ve stared my peeves)
17 – Too many posts
12 – Topics not focused or changes topics too often
10 – Not enough posts
10 – Not full text feeds (*)
9 – Repeated stories or unoriginal (*)
6 – Reader not interested
6 – Too long of stories or bad post layout
4 – Negative stories or attitude
4 – Too much self promotion
4 – Low quality of posts
3 – Story keep reappearing (usually frequent editing) (*)

I find it funny that not enough and too many posts were in the top three answers.

theBuzz #001: Because I’m Lazy and Haven’t Created the Plugin I want

If you have noticed the “theBuzz” (bhiv = beehive.. bees.. they buzz, get it?) side bar and thought? Well, that seems a total waste of space, it is because I have been planning to roll my own WordPress plugin / Del.icio.us system. Mainly to emulate waxy.org because I think the idea of short and easy links is a great way around creating a full blown posts.

In the meantime, I will be consolidating all my links into a single entry, like so:

Anyway, I think you may get the idea of what theBuzz will be like, nothing special just a simple quick links. The next issue will be shorter without all this explanation.

Upgraded to WordPress 2.0

The upgrade was pretty painless. I did back up everything, which was a good thing after I dropped the drop directory into my FTP client and didn’t want to go and pick out each file. But other than that I only seem to have one error on the admin page. Not sure who’s fault that is, but I’ll track it down in the next couple days.

Why this is a big deal for me, is I have been waiting for 2.0 to start with a couple plugins that I have been thinking about and now I can start to finish this site.