Skip to content

Instantly share code, notes, and snippets.

@soapdog

soapdog/Kobo Reader Highlights & Annotations

Forked from raivivek/Kobo Reader Highlights & Annotations
Created January 24, 2024 18:40
Show Gist options
  • Save soapdog/61c2cb6b8dd8e87e87f7360bcedaf047 to your computer and use it in GitHub Desktop.
Save soapdog/61c2cb6b8dd8e87e87f7360bcedaf047 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @ozgurkalan ozgurkalan revised this gist Apr 9, 2018. 1 changed file with 10 additions and 1 deletion.
    11 changes: 10 additions & 1 deletion Kobo Reader Highlights & Annotations
    View file
    Original file line number Diff line number Diff line change
    @@ -1,10 +1,19 @@
    '''''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
    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
  2. @ozgurkalan ozgurkalan revised this gist Apr 9, 2018. 2 changed files with 7 additions and 15 deletions.
    14 changes: 7 additions & 7 deletions Kobo Reader Highlights & Annotations
    View file
    Original file line number Diff line number Diff line change
    @@ -1,10 +1,10 @@
    select
    distinct(content.BookTitle) as book,
    title as chapter,
    bookmark.text as highlights,
    bookmark.Annotation as notes
    from content left join bookmark
    on content.ChapterIDBookmarked = bookmark.ContentID
    where content.ContentType=899 and (bookmark.text is not null or bookmark.Annotation is not null)
    ISBN, title,
    text, annotation
    from bookmark
    left outer join content
    on (content.contentID=bookmark.VolumeID and content.ContentType=6)
    where
    text is not null

    ''download KoboReader.sqlite from your eReader's drive: KOBOeReader > .kobo > KoboReader.sqlite
    8 changes: 0 additions & 8 deletions kobo_export_highlights.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,8 +0,0 @@
    select
    distinct(content.BookTitle) as book,
    title as chapter,
    bookmark.text as highlights,
    bookmark.Annotation as notes
    from content left join bookmark
    on content.ChapterIDBookmarked = bookmark.ContentID
    where content.ContentType=899 and (bookmark.text is not null or bookmark.Annotation is not null)
  3. @ozgurkalan ozgurkalan created this gist Apr 7, 2018.
    10 changes: 10 additions & 0 deletions Kobo Reader Highlights & Annotations
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,10 @@
    select
    distinct(content.BookTitle) as book,
    title as chapter,
    bookmark.text as highlights,
    bookmark.Annotation as notes
    from content left join bookmark
    on content.ChapterIDBookmarked = bookmark.ContentID
    where content.ContentType=899 and (bookmark.text is not null or bookmark.Annotation is not null)

    ''download KoboReader.sqlite from your eReader's drive: KOBOeReader > .kobo > KoboReader.sqlite
    8 changes: 8 additions & 0 deletions kobo_export_highlights.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,8 @@
    select
    distinct(content.BookTitle) as book,
    title as chapter,
    bookmark.text as highlights,
    bookmark.Annotation as notes
    from content left join bookmark
    on content.ChapterIDBookmarked = bookmark.ContentID
    where content.ContentType=899 and (bookmark.text is not null or bookmark.Annotation is not null)