09-14-2013, 05:21 PM | #1 |
Member
Posts: 11
Karma: 6632
Join Date: Apr 2010
Device: Kindle PW2, Onyx i62HD Firefly
|
Found sqlite annotations database in Kindle for Android
This afternoon I have tried to figure out where recent versions of Kindle for Addroid stores annotations for .mobi got from somewhere else than Amazon.
From this forum I learned that the bookmarks/annotations used to be saved in .mbp files. However Amazon decided to encrypt the file so .mbp became .embp. For my Kindle for Android app I cannot find neither .mbp nor .embp. There is no file that seems to contains annotation neither in /sdcard/kindle nor /sdcard/Android/data/com.amazon.kindle/files. However there is a file in protected folder: /data/data/com.amazon.kindle/databases/annotations.db (You must gain root to access the file.) The file is a plain SQLite database. Annotation table contains the following columns: BOOKID - the part of the string is ASIN TYPE - 0 stands for a bookmark, 2 is an annotation START_POS, END_POS are integers that seems to define an annotation"position" range. The screenshot of SQLite viewer showing content of the file is attached. I don't know how to relate the position to the contents of the .mobi file. Possibly it is similar to .mbp format, which specification I cannot find. My Perl is too rusty to analyze sources of mbp reader script (http://www.angelfire.com/ego2/idleloop/mbp_reader.html)... so I decided to ask for giving me a hand. The aim of exercise is to retrieve annotations from ebooks called by Amazon "personal" - ones purchased in other bookstores or got from public domain cloud. As we know there is no highlights from "personal" documents at https://kindle.amazon.com/your_highlights. I think it is okay, as this is a convenience feature that Amazon is not obliged to support for books purchased from other vendors. What I don't quite understand why Amazon decided to encrypt annotations for non-encrypted ebooks. Finally annotations storage completely disappeared from user accessible folders in case of Kindle for Android app, which includes Kindle Fire as far I know. Last edited by beeblebrox; 09-14-2013 at 05:37 PM. |
09-14-2013, 08:59 PM | #2 |
Going Viral
Posts: 17,212
Karma: 18210809
Join Date: Feb 2012
Location: Central Texas
Device: No K1, PW2, KV, KOA
|
I think you are in the wrong forum.
This forum is for development of software for the e-ink screen Kindle devices, not for any of the "Kindle for ..." programs. Try the home page index of this site, you should be able to find a better forum to pose your questions about the book reader application. |
09-14-2013, 10:01 PM | #3 | |
Member
Posts: 11
Karma: 6632
Join Date: Apr 2010
Device: Kindle PW2, Onyx i62HD Firefly
|
Quote:
BTW: How Paperwhite stores annotations for "personal documents"? I preordered PW2 and look forward to have annotation synchronized between my Android tablet and Kindle w/o "for". It's quite easy with "Send to Kindle". The hard part is to get such annotations out of Amazon cloud. Last edited by beeblebrox; 09-15-2013 at 03:54 AM. |
|
09-15-2013, 08:02 AM | #4 | |
Going Viral
Posts: 17,212
Karma: 18210809
Join Date: Feb 2012
Location: Central Texas
Device: No K1, PW2, KV, KOA
|
Quote:
Try: https://www.mobileread.com/forums/forumdisplay.php?f=168 |
|
09-15-2013, 08:09 AM | #5 |
( ͡° ͜ʖ ͡°){ʇlnɐɟ ƃǝs}Týr
Posts: 6,586
Karma: 6299991
Join Date: Jun 2012
Location: uti gratia usura (Yao ying da ying; Mo ying da yieng)
Device: PW-WIFI|K5-3G+WIFI| K4|K3-3G|DXG|K2| Rooted Nook Touch
|
*moved*
|
09-16-2013, 03:19 AM | #6 |
Member
Posts: 11
Karma: 6632
Join Date: Apr 2010
Device: Kindle PW2, Onyx i62HD Firefly
|
|
12-04-2013, 06:17 AM | #7 |
Junior Member
Posts: 1
Karma: 10
Join Date: Nov 2013
Device: Kindle Paperwhite, Kindle for Android
|
Hello, beeblebrox,
I've been looking into this issue of extracting annotations from Personal Documents in the Kindle app in Android devices, and I'm interested in this information you got about the sqlite db. In the mbp reader perl script you mention, it is possible to set a parameter that divides that location by 150, thus giving the Kindle location position (with an offset of 1). Can you try that with the number you got from the sqlite db? (My phone is not rooted, and I don't intend to do so, so I don't have access to that file here) Just for the record, and slightly unrelated to your question, I found a way of getting the mbp file without encryption by downgrading the app to the version 3.6.0.87. I'm thinking about making a python wrapper script to the mbp reader perl script to try to convert the notes into a format that is compatible with the My Clippings.txt, so that it can be uploaded to those services such as ClippingsConverter. Let's see Cheers! |
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Kobo sqlite database | darkadept | Kobo Reader | 38 | 09-08-2013 08:12 PM |
How to transfer bookmarks and comments to a new SQLite database | mjost | Kobo Reader | 4 | 08-31-2013 03:07 AM |
Sqlite database replacement instructions | pholy | Kobo Reader | 62 | 10-11-2012 09:19 AM |
Sqlite database clean up | mapline | Kobo Reader | 2 | 08-01-2012 11:12 PM |
Kobo Database Browser - SQLite | JBlyth | Kobo Reader | 2 | 06-06-2010 09:27 PM |