MetaTagger

Expert Mode

The Expert Mode gives you access to the underlying BASIC like interpreter and to a command line interface to the SQLite database.

I will not attempt explaining the Expert Mode here.

But I will highlight some of the database tables used by this application.

TagTable contains one row for each tag. A row contains:

• a tag group
• a tag        must be unique within a tag group
• tag text     a free text field to hold whatever you want about the tag

Master contains one row for each file. A row contains:

• filesystem information: path / name / ext , access dates
• MD5 hash of the file
• RectPicasa     only used by a add-in
• RectMeta        used by the regions tool
• for each tag group, a column (ending in the text Tag) that holds the tags assigned to the file. Tags are delimited by a 2 character string:
  • a non-printable character 0x01e, non-printable to prevent it being used in a tag.
  • a printable character § so that when browsing the table it serves as a visible delimiter between tags.

SavedEnv contains application internal data that enables some configuration information to survive over sessions.

The SQLite module was compiled so that the function like is case insensitive.
If you start writing your own queries on the tables then I recommend using like and not the operator = so that on queries you do not have to be so carefuly with upper/lower case typing.
This is especially true if you use update and insert statements with case errors, if you use like in select statements and where sub-statements you will avoid one source of errors.

There are some videos on youtube about the general SQLite / BASIC capabilites (search for PlodWare).