Archive for » August, 2009 «

Friday, August 14th, 2009

SQLite3 is truly dynamically typed. To a fault:

sqlite> select count(*) from posts where external_id = 199252;
0
sqlite> select count(*) from posts where external_id = '199252';
1
sqlite> select count(*) from posts where external_id = 199793;
1
sqlite> select count(*) from posts where external_id = '199793';
0

One day I suppose I will find it useful to store different data types in the same column, and without implicit conversion. I look forward to that day. Right now, I will have to spend a few hours cleaning up the mess that this caused.

Category: Programming  | Tags:  | Comments off
Wednesday, August 05th, 2009

After last week’s got.rb meeting we went out to grab a beer and continue our geeky discussions.  I just want to make a note to myself that the wonderful beer I had (after CJ refused it) was a Gueuze Fond Tradition from Belgium.  It’s not available at Systembolaget, much like this summer’s first favourite, Gjutarns Bästa Bitter (et al.) from Skebo Bruksbryggeri.  Note within note: according to the homepage, Skebo’s beers should be available at Delirium and three more venues in Gothenburg!

Category: Life outside work  | Tags:  | Comments off