Forked from ozgurkalan/Kobo Reader Highlights & Annotations
Created
December 31, 2019 03:27
-
-
Save raivivek/b8966dd3c255b71c8ed53e6a155b3c0e to your computer and use it in GitHub Desktop.
Kobo eReader - KoboReader.sqlite - SQL statement for listing books, highlights and annotations per chapter
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| '''''list highlights and annotations by ISBN and book: | |
| select | |
| ISBN, title, | |
| text, annotation | |
| from bookmark | |
| left outer join content | |
| on (content.contentID=bookmark.VolumeID and content.ContentType=6) | |
| where | |
| text is not null; | |
| '''''''Book details: | |
| SELECT | |
| ContentID as BOOKID, | |
| ISBN, title,subtitle, attribution, Language, Description | |
| FROM content WHERE contenttype=6 AND Accessibility=1 | |
| order by DateLastRead DESC; | |
| ''download KoboReader.sqlite from your eReader's drive: KOBOeReader > .kobo > KoboReader.sqlite |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment