Quote:
Originally Posted by kovidgoyal
Yes it really uses sqlite. sqlite doe snt use types, the types in the schema are for documentation, not for sqlite.
|
That's a strange thing to say, given SQLite has a whole section of documentation on types they support and don't support (I provided a link in my original post).
I'm also currently trying to open the Calibre DB in an SQLite framework that won't accept it because I can't match the schema, so saying that "schemas are for documentation" is off the mark.
Anyways, I dug a bit deeper and found that while SQLite3 doesn't support those types, SQLite2 does. So I'm guessing that the Calibre DB is based on the latter.