Last stuff

Determine sqlite table size on disk

I took me a while to find out that it’s not very easy to find out how big a sqlite table is on disk. But luckily the sqlite creators have a simple tool for that. It’s called sqlite3_analyzer and is available in precompiled format for Linux, Windows and OSX on SQLite’s Download section Confusing: There […]

Install Qt and compile Capybara webkit on Linux and mac OSX

To automate browser style testing in Ruby you can use Qt webkit caompatible browser with CapyBara. When you try to install it you’ll get this error when qmake isn’t found: An error occurred while installing capybara-webkit (1.1.0), and Bundler cannot continue. Make sure that `gem install capybara-webkit -v ‘1.1.0’` succeeds before bundling. To solve this […]

Rode kool op grootmoeders wijze

Dit is een klassiek rode kool met appeltjes recept dat je lekker lang moet stoven in een vuurvaste pan. Waarschuwing: Als je dit 1x geproefd hebt eet je nooit meer rode kool uit een potje of zakje. Ingrediënten 1 rode kool 4 goud reinet appels 1 kleine ui 1 scheutje wijn azijn 1 afgestreken eetlepel […]

Downloading OpenStack images with Glance

When you create OpenStack snapshots you’ll also need to download the snapshot to a safe location. There are a couple of ways to do this; I’ll describe an easy way by using the command line tools. First install it: sudo add-apt-repository ppa:glance-core/trunk sudo apt-get update sudo apt-get install glance You’ll need a keystonerc file to […]

Passwordless login via ssh in just 2 commands!

I already wrote some earlier posts on this topic; but I found a new command: ssh-copy-id; it’s brilliant. First create your SSH Keypair by running ssh-keygen this will create an id_rsa and id_rsa.pub file. The pub file is what goes on the servers, the private key (id_rsa) is what stays with you and is how […]