View Single Post
Old 01-06-2011, 04:12 PM   #1
mfaine
Enthusiast
mfaine began at the beginning.
 
Posts: 36
Karma: 10
Join Date: Oct 2009
Device: nook
Database Documentation

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.
mfaine is offline   Reply With Quote