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

Go Back   MobileRead Forums > E-Book Readers > Kobo Reader

Notices

Reply
 
Thread Tools Search this Thread
Old 06-03-2010, 08:55 PM   #1
timlegge
Addict
timlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than mom
 
Posts: 305
Karma: 78651
Join Date: May 2010
Location: New Brunswick, Canada
Device: Kobo, Kobo Wifi, Kobo Touch
How are kobo books stored? - Technical

Hi

Has anyone looked at the format of how kobo books are stored in the database. Specifically how is the shortcover_page..FormattedPage field encoded.

I suspect that it is a compressed html file encoded in ascii.

I would like to be able to add a feature to calibre to allow you to backup the book to the hard drive. Preferably calibre could create a real epub out of it.

If I have to, I will look at saving the database rows to a files and zipping them as the book and allow them to be reimported that way but that is messy.

If you have any ideas feel free to shoot me a message at timlegge at gmail d0t com.

Tim
timlegge is offline   Reply With Quote
Old 06-04-2010, 05:03 AM   #2
reed
Junior Member
reed began at the beginning.
 
Posts: 5
Karma: 14
Join Date: May 2010
Location: Wellington, New Zealand
Device: Kobo
see http://wiki.durbn.net/koboko/index.php/DBSchemaV2
reed is offline   Reply With Quote
 
Enthusiast
Old 06-04-2010, 05:36 AM   #3
Stinger
Asha'man
Stinger has learned how to read e-booksStinger has learned how to read e-booksStinger has learned how to read e-booksStinger has learned how to read e-booksStinger has learned how to read e-booksStinger has learned how to read e-booksStinger has learned how to read e-books
 
Stinger's Avatar
 
Posts: 335
Karma: 844
Join Date: May 2010
Location: Canada
Device: Kobo
Quote:
Originally Posted by reed View Post
Tim is aware of darkadepts project reed. ATM the schema posted there does not contain details about the encoding method that Tim is seeking.
Stinger is offline   Reply With Quote
Old 06-04-2010, 07:33 AM   #4
mylesau
Enthusiast
mylesau began at the beginning.
 
Posts: 29
Karma: 12
Join Date: May 2010
Device: Kobo
Hi Tim,

Just in case you're not aware, books that are not encrypted are stored as plain html in the shortcover_page table. (eg. 'Crime And Punishment' - id = 0086fe75-afcd-4da1-8a1f-7f565916d074).

I'll have a look at the encryption key, if I come up with anything I'll let you know.

Myles.

Also the image files appear just to be jpegs renamed to .parsed - may help if reverse engineering the epub.

Last edited by mylesau; 06-04-2010 at 07:36 AM.
mylesau is offline   Reply With Quote
Old 06-04-2010, 03:38 PM   #5
timlegge
Addict
timlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than mom
 
Posts: 305
Karma: 78651
Join Date: May 2010
Location: New Brunswick, Canada
Device: Kobo, Kobo Wifi, Kobo Touch
Quote:
Originally Posted by mylesau View Post
Hi Tim,

Just in case you're not aware, books that are not encrypted are stored as plain html in the shortcover_page table. (eg. 'Crime And Punishment' - id = 0086fe75-afcd-4da1-8a1f-7f565916d074).

I'll have a look at the encryption key, if I come up with anything I'll let you know.

Myles.

Also the image files appear just to be jpegs renamed to .parsed - may help if reverse engineering the epub.
Hi

I thought I had seen some clear text books. However, since the content table says IsEncrypted = false for all the books and they are Gutenburg books I assumed that they were just compressed and not encrypted.

I don't plan on breaking encryption I just figured it would be nice to backup a book before deleting it.

Tim
timlegge is offline   Reply With Quote
Old 06-04-2010, 07:48 PM   #6
mylesau
Enthusiast
mylesau began at the beginning.
 
Posts: 29
Karma: 12
Join Date: May 2010
Device: Kobo
I'm not sure why they did it, but some of the 'free 100' books (Gutenburg) are actually encrypted and some aren't.

The overuse of the "content" table to store both the book (ContentType = 6) and each of it's 'ShortCovers' (ContentType = 9) is odd to me - it would have made more sense to store these in separate tables, but perhaps there are limitations on the device or some performance gain to do it this way.

It looks to me that the IsEncrypted field has no meaning for the book (ContentType = 6) as they are all set to false, but only has meanings for the 'ShortCovers' (ContentType = 9) where they are set either to true or false which is then reflected in the 'shortcover_page' table with encrypted or plain text.

I think it would still be of value to be able to 'extract' the epub of an unencrypted book, and certainly of value to be able to 'dump' a single book or selection of books out, encrypted or not, for either backup purposes or perhaps to be able to import back into another Kobo.
mylesau is offline   Reply With Quote
Old 06-04-2010, 10:49 PM   #7
timlegge
Addict
timlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than momtimlegge loves his/her reader more than mom
 
Posts: 305
Karma: 78651
Join Date: May 2010
Location: New Brunswick, Canada
Device: Kobo, Kobo Wifi, Kobo Touch
Hi

Thanks for that information. I kept looking at the book records not the chapters so I did not notice the encrypted field on the chapters. I just assumed they were simply compressed. The encoding makes more sense now.

Tim
timlegge is offline   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
How to change location books are stored on reader bdillahu Calibre 5 10-09-2010 10:09 PM
Ebook for technical books ziNde Which one should I buy? 13 02-21-2010 08:52 AM
technical books in epub wang960 ePub 3 10-07-2009 06:13 PM
Where are books stored in eBook Library? ponga163 Sony Reader 8 01-01-2009 09:36 PM
Best E-Reader for Technical Books rndinit0 Which one should I buy? 6 06-10-2008 07:07 PM


All times are GMT -4. The time now is 11:17 PM.


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