Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
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
Old 01-06-2011, 04:46 PM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,350
Karma: 5382313
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Nope, you have to read the schema, or the calibre source. custom column tables all fall into one or two very similar categories depending on the datatype.

You do know you can dump the entire schema at once, right?
kovidgoyal is offline   Reply With Quote
 
Advertisement
Old 01-06-2011, 05:29 PM   #3
mfaine
Enthusiast
mfaine began at the beginning.
 
Posts: 36
Karma: 10
Join Date: Oct 2009
Device: nook
Quote:
Originally Posted by kovidgoyal View Post
Nope, you have to read the schema, or the calibre source. custom column tables all fall into one or two very similar categories depending on the datatype.

You do know you can dump the entire schema at once, right?
Yes, and I'm getting closer now that I've installed a gui browser to view the tables. If anything the exercise will improve my sql skills.

Thanks
mfaine is offline   Reply With Quote
Old 01-07-2011, 02:26 PM   #4
mfaine
Enthusiast
mfaine began at the beginning.
 
Posts: 36
Karma: 10
Join Date: Oct 2009
Device: nook
I promise I'll stop asking questions (in this thread) about the database but I'm curious as to why author_sort is a field in books and sort is also a field in authors?
mfaine is offline   Reply With Quote
Old 01-07-2011, 03:01 PM   #5
itimpi
Wizard
itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.
 
Posts: 4,095
Karma: 780247
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
A combination of legacy and practicality.

The one in the books has always been there.

The one in the authors table is newer, and is the default value applied to new books. However you can over-ride the value at the book level if you want to. This tends to be of most use in multiple author books where you want a particular author to be the primary sort key.

That is one of the reasons the Edit Metadata dialog highlights the author-sort field in pink when the value on the books table is different to the value on the authors table. Just a hint that you should check that you want the book sorted by the value currently displayed.

Last edited by itimpi; 01-07-2011 at 03:03 PM.
itimpi is online now   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Documentation for Sigil Valloric Sigil 15 11-12-2010 07:37 PM
Server Documentation? Joe McPlumber Calibre 4 07-06-2010 12:34 AM
Technical Documentation Gremlin HanLin eBook 4 07-16-2009 03:24 AM
Wiki documentation mrdini OpenInkpot 1 10-14-2008 10:50 AM
More Detailed Documentation? TedPark Sony Reader Dev Corner 3 06-10-2008 10:06 PM


All times are GMT -4. The time now is 03:55 PM.


MobileRead.com is a privately owned, operated and funded community.