Ariejan.net

Just to put it out there: I’m available for iPhone development (preferably in the Netherlands).

If you’re interested in having an iPhone app developed, feel free to contact me to discuss your options.

I’m developing iPhone apps a an employee at Kabisa.

If you have a lot of mutations in your SQLite3 database the file size of the db file will increase a lot over time.

This can be annoying, so you’ll need to clean up old indices and other cruft that’s making your db heavy.

The solution is über-easy:

$ sqlite3 mystuff.db
SQLite version 3.6.6.2
sqlite> VACUUM;
sqlite> .quit

I just needed an OpenSSL DSA public key. This is not really difficult, you just need to know the right commands. On my Mac I ran the following commands to obtain both private dsa_priv.pem and public dsa_pub.pem keys.

openssl dsaparam 1024 < /dev/random > dsaparam.pem
openssl gendsa dsaparam.pem -out dsa_priv.pem
openssl dsa -in dsa_priv.pem -pubout -out dsa_pub.pem

Needless to say, keep your private key in secure location and make sure you have a backup of it!

Disclaimer: If you are reading this, chances are there is a hardware problem with your Mac. In my case it was a faulty logic board, which had to be replaced.

Use this guide to get your Mac up and running again and create a full backup of you system as soon as possible. If the problem repeats itself, I recommend you take your Mac back to Apple for a check-up.

Today I was happily working on some Java code, when I decided to relocate to a sunny spot in the backyard. I closed my MacBook Pro, walked outside and opened my MBP again to continue work: a black screen!

The screen of my Mac stayed black, although it did not indicate to be in a sleeping state. WTF? I restarted the Mac, removed the battery, reset PRAM/NVRAM and the PMU, but nothing worked! ARGH! Then, I found a solution that worked.