Tag-Archive for » database «

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