Thanks to Matt, and my persistence, [Squib][1] now works and plays well with a SQLite database.
There were a few little tricks like SQLite is case-sensitive and search where `something = true` need to be written `something = 1`.
Matt’s de-normalization for the dates made this all possible.
[1]:http://squib.rubyforge.org/