Ferret File System/v0.1

Introduction

FileFerret is a software system intended to tackle the problem of keeping track of large numbers of files, including those archived to offline media. It can also provide services to other applications which may need to track large numbers of files for their own purposes.

My original notes are on HypertWiki, but the official documentation will be here (HTYP) as I create it.

Preliminary Table Designs

These are based on what I had created in MS Access 97.

"Filaments" is actually a portmanteau of "file elements", but I didn't want to spell it "filements" because the obvious pronunciation would be "file-ments". Maybe "felements" would have been better. <mysql>CREATE TABLE `filaments` (

 `ID`        INT NOT NULL AUTO_INCREMENT,
 `Title`     VARCHAR(255) COMMENT "unique name for the file, wherever it may be found",
 `AutoTitle` VARCHAR(255) COMMENT "automatically-generated title",
 `AutoDescr` VARCHAR(255) COMMENT "automatically-generated description",
 `FileSize`  INT          COMMENT "correct file size in bytes",
 `FileCkSum` INT          COMMENT "correct file checksum",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>

• Title will probably end up being some form of the filename, possibly with disambiguating text prepended.
• Instead of a Descr field, I think we'll want to point to a wiki page for more info, but I haven't worked out how to do this yet.
• AutoDescr can be generated by the application which first goes looking for the filament and which therefore may have more understanding of the filament's purpose in life
• It's not clear whether we need something more elaborate than just a 4-byte checksum, because there are so many different ways of generating this.