Last active
August 5, 2022 11:08
-
-
Save ozgurkalan/730f76e2ca7df552151c09a1df8d36bd 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