MobileRead Forums - View Single Post

mfaine · 01-06-2011, 03:12 PM

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.

01-06-2011, 03:12 PM	#1
mfaine Member Retired 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 03:14 PM.