View Single Post
Old 04-12-2010, 02:12 PM   #8
Mr. X
Connoisseur
Mr. X is on a distinguished road
 
Posts: 68
Karma: 64
Join Date: Mar 2010
Location: Philadelphia
Device: iRex DR800SG
metadata.db is a sqlite3 database. All the code for it is open, see libermetadb. The Scribbles are stored as "blobs" (generic binary data) in the "annotations" table:

Code:
CREATE TABLE annotations (
  annotation_id    INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  annotation_type  TEXT NOT NULL,
  file_id          INTEGER NOT NULL,
  layer            TEXT NOT NULL,
  file_position    INTEGER NOT NULL,
  title            TEXT,
  start_anchor     TEXT,
  end_anchor       TEXT,
  data             BLOB
);
Presumably the blob is what you need to put into a .note file after finding the right annotation record.
Mr. X is offline   Reply With Quote