use absolute file paths in sql lookups
switch sequence based ids to use uuid instead
v0.2