Skip to content

Category: Technology

Listing MySQL table sizes

This query lists the sizes of all tables in MySQL: SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), 'MB') DATA, CONCAT(ROUND(data_free / ( 1024 * 1024 ), 2), 'MB') FREE from information_schema.TABLES where TABLE_SCHEMA NOT IN ('information_schema','mysql', 'performance_schema'); Read More »

How to test

I haven't got much experience when it comes to testing web applications. Instead (and more so out of apathy than belief), I've always adhered to the ad-hoc test approach. However, the usage of pure Posgres unit tests back when I worked on a complicated investment database with Halfgaar did teach me the advantages of test-driven development. Read More »

Generating an SSL CSR and key

To generate an SSL certificate signing request (CSR) with key you can do this: openssl req -nodes -newkey rsa:2048 -keyout bla.key -out bla.csr Read More »

Creating a drbd for an existing Xen domain

I needed some VMs to be available on a backup node, which I accomplished with the distributed remote block device, or DRBD. My host machine is Debian 6. Read More »

Internet Explorer in VirtualBox 4.1 in Ubuntu 10.10

I've been needing IE for testing for some time now, but now I'm studying and I need it to work with some interactive Silverlight stuff. Read More »

What all programmers must know about character encoding

click. Read More »

Fixing mailscanner insecure dependancy

Mailscanner cut out on me, without errors in the log. It was only after turning on debug (which prevents backgrounding and it then only processes one batch) that it showed me. Read More »

Commenting fixed for

To my great surprise, thanks to Tobias Sjösten, I found out that commenting was broken on I couldn't pinpoint the exact problem, but it must have been introduced with some WordPress upgrade somewhere along the line. I never noticed it because it did work for logged in users. (If I must really guess, I suspect a silent ReCaptcha version compatibility problem.) Read More »

MediaWiki ConfirmEdit/QuestyCaptcha extension

Since I moved my LDAP wiki over from DokuWiki to MediaWiki, I've been burried by a daily torrent of spam. Just like with my tropical timber investments wiki, the ReCaptcha extension (with pretty intrusive settings) doesn't seem to do much to stop this shitstream. Read More »

Safari: don’t give gzipped content a .gz extension

Yesterday, while helping Caloe with the website for her company De Buitenkok, I came across the mother of all stupid bugs in Safari. Me having recently announced, I loaded it up in Apple's hipster browser only to notice that the CSS wasn't loaded. Oops! Read More »