Forked from raivivek/Kobo Reader Highlights & Annotations
Created
January 24, 2024 18:40
-
-
Save soapdog/61c2cb6b8dd8e87e87f7360bcedaf047 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 hidden or 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