View Single Post
Old 06-18-2013, 12:38 PM   #12
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,553
Karma: 950151
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
Quote:
Originally Posted by mike_bike_kite View Post
Well that wasn't too hard. I've installed SQLite, I found the Calibre database and I'm now trying out some queries. It might take me a week or so to learn SQLite and write the queries etc but it seems doable.

If I change the database, say perhaps swap a book title and an author name then will this show up cleanly in Calibre or do I need to do more? Can I just copy the metadata.db file to keep a backup of everything?

Mike
I think you can only use this to identify the titles that need changing, but still need to do the changes through the Calibre GUI. The folder/filenames used to store the eBooks are constructed from the author/title fields so changing them only in the database is likely to mean that Calibre loses track of the actual underlying eBook files.
itimpi is offline   Reply With Quote