title: XML format in Kobo Sqlite database for bookmarks
body: <p>I am to extract bookmarks from an <code>.epub.annot</code> file from a Kobo ebook reader. It is an xml file with annotations, and the annotations have a tag <code>fragment</code> with the following as an example:</p>
  
  <pre><code>&lt;fragment
     start="OEBPS/9781118087220c07.xhtml#point(/1/4/2/134/1:2)"
     end="OEBPS/9781118087220c07.xhtml#point(/1/4/2/134/1:100)"
  progress="0"&gt;
  </code></pre>
  
  <p>Some said that this is a <a href="http://www.idpf.org/epub/linking/cfi/" rel="nofollow noreferrer">epub canonical fragment identifier</a> but another person noted that this is better <a href="https://www.adobe.com/hu/solutions/ebook/rmsdk.html" rel="nofollow noreferrer">Adobe RMSDK</a> which does not have an open description.</p>
  
  <p>What does this</p>
  
  <pre><code>(/1/4/2/134/1:2)
  </code></pre>
  
  <p>and</p>
  
  <pre><code>(/1/4/2/134/1:100)
  </code></pre>
  
  <p>mean?</p>
  
  <p>The very last number seems to be a character count as I inspected the database but the other numbers' role is less clear.</p>
  
  <p>EDIT: the header of the xml file is this:</p>
  
  <pre><code>&lt;annotationSet xmlns:xhtml="http://www.w3.org/1999/xhtml" 
     xmlns:dc="http://purl.org/dc/elements/1.1/" 
     xmlns="http://ns.adobe.com/digitaleditions/annotations"&gt;
  </code></pre>
  
  <p>The purl.org link gave a file with xml namespace description but it did not include the <code>fragment</code> tag, while the adobe link was broken. I searched for "adobe annotations xml" but in vain.</p>