access annotation database

I was looking at how to access the built-in PDF viewer's annotation database and only found this (https://www.zotero.org/support/kb/annotations_in_database). It mentioned "Zotero stores annotations in the Zotero database".

I went to my zotero directory (~/Zotero/zotero.sqlite) and indeed found a table called "itemAnnotations". From what I observed, it only contains the texts that are "highlighted", but not the ones I drew freely. And I didn't seem to find the db tables related to the other PDF annotation information. I wonder what tables contain those information? Or is there some other database I need to look at?

To have a bit background, I was looking at the possibility of syncing Zotero database with Remarkable tablet. I understand that this is not something currently being worked on by either side of the dev teams (https://forums.zotero.org/discussion/97517/remarkable-2-integration) and hence was considering doing it myself.

From what I understand right now, it seems possible to retrieve the PDF from Zotero API, transfer the file to rm2, annotate the PDF, convert the rm2 annotation into Zotero annotation, merge back with the Zotero annotation database. I don't think it is even needed to transfer the PDF file directly. This would make the sync process faster and compatible with Zotero annotation standard.

I would appreciate any comment or feedback. Thank you very much.
  • All annotations are in that table, including ink annotations, but for an integration you would want to use the web API anyway.
Sign In or Register to comment.