Is the calibre library structure documented somewhere? I'm looking to do direct sqllite queries against the a library but it is slow going doing .schema on every table and writing down what columns are contained and how they relate. Surely there is a faster way? An ERD would also be great.
My goal is a single select statement that will retrieve values for specific columns (including some custom columns) for all the books in the library.
Last edited by mfaine; 01-06-2011 at 04:14 PM.