Thread: Does Calibre really use SQLite?
View Single Post
Old 08-19-2022, 03:31 PM   #13
j.p.s
Grand Sorcerer
j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.
 
Posts: 5,816
Karma: 103362673
Join Date: Apr 2011
Device: pb360
Quote:
Originally Posted by kovidgoyal View Post
A hint for the future. If you want to have "productive" conversations dont start out by telling someone that has been using sqlite for 15 years highly successfully their API docs are wrong. And that too based on a cursory reading of documentation (which is exactly that, not a standard). Read section 3.1 of the documentation you linked to and you will be able to tell the type affinity of every column in the calibre database. Which is anyway entirely irrelevant since sqlite actually uses types per value not per column. You can store text in integer columns and integers in blob columns if you want.
I was browsing sqlite documentation a few years ago and that really stood out to me.
A column can be nominally double precision, but if the content of that column in a given row is inserted or updated as 1.0 it will actually stored as a short integer (or maybe even byte).
j.p.s is offline   Reply With Quote