This one time, at band camp, Alex McLintock wrote:
I too just discovered that SQLite is not a replacement for a proper database. I wanted to use it as a replacement for some temporary tables put into a Sybase database. Unfortunately SQLite was unable to do the same maths as Sybase and I got the wrong answers. Will that matter for an OpenGuides installation? I don't really know.
There is something in the sqlite FAQ about its treatment of 00 type strings as zero.