MobileRead Forums - View Single Post - Convert Irex Notes of new firmware 2.0 BETA

Mr. X · 04-12-2010, 01:12 PM

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.

04-12-2010, 01:12 PM	#8
Mr. X Connoisseur 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.