Customized Suzuki Intruder in French village
Photo: Copyright © 2014 Eelke Blok

Everything is a remix

I heard about it, but had never watched the videos before (or even knew it was a series of four). Very interesting documentary explaining how "original work" is usually only a combination of existing ideas, "remixed" in a certain way (which doesn't make the invention or creation any less impressive, it's just that attributing something to a single inventor or creator doesn't exactly reflect reality). There are nice references to pop culture and it ends with an explanation why the current US patent system is a monstrosity that does not help its original intent at all. Below are the videos,...

Debugging Drush with Eclipse and XDebug

Update 15/4/2017: This is a fairly old post, by now. I've done a more recent post on debugging drush on a setup with PhpStorm and Vagrant.

Drush is a command line tool to interact with the Drupal Open Source CMS (Get it? DRUpal SHell). It is an invaluable tool that many Drupal developers love once they start using it. Another tool I personally love greatly is the XDebug PHP debugger. I use it almost daily to quickly find out what is going on in a PHP website I am working on. It can be a pain to set up, but once you have it, firing up a debugging session is as easy as hitting a...

Changing a user's password in OpenX 2.8

The user management of OpenX is a little confusing if you are used to other systems. There is a blog-post about the user system on the OpenX-blog giving a good overview.

One aspect that they seem to have forgotten is dat users may want to change their password. A "I forgot my password" link is provided, but other than that there is no way to change your password.

No more multi-language

So you may see a few weird menu items, blog posts and/or categories. This is because I disabled the WPML (multi-language) plugin. Recently, they went commercial and since then (or thereabouts) I've had trouble updating. Then, my server was hacked. I am not in the least way implying this was due to WPML, but the fact is that it was out of date along with three other plugins. The others I could update. WPML, not so much.

Since it really is not much more than a gimmick, I decided to switch off the plugin, which means all content is now mixed on the one site. Not sure what to do with...

Lego MindStorms digital clock

I can't wait until my kid will be old enough to play with Lego (OK, so that may be slightly premature, considering we're due in april). Maybe I shouldn't look for excuses and just get some. This stuff is so cool. Incidentally, the numbers are black on white. Believe it or not, I took a few seconds to realize that.

.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-container iframe, .embed-container object, .embed-container embed { position: absolute; top: 0; left: 0; width: 100%; height: 100%; }

Finding number of Drupal-nodes created per hour in a single query

For a customer I've been running an import of old content into a Drupal installation and I got the feeling that the process seemed to run slower and slower. We say "meten is weten" in Dutch ("measuring is knowing"), so I wondered if it was possible to write a single SQL query to find out how many nodes were created per hour since the start of the import. This is the query I came up with: