Ferret File System/v0.1: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
("files" table)
m (Woozle moved page FileFerret to Ferret File System/v0.1: obsolete)
 
(17 intermediate revisions by the same user not shown)
Line 1: Line 1:
==Introduction==
[[category:project]]
[[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.
==About==
 
[[FileFerret]] is a software system intended to manage large numbers of files, including those on 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 [[htwiki:FileFerret|HypertWiki]], but the official documentation will be here (HTYP) as I create it.
==Status==
==Preliminary Table Designs==
'''2022-09-23''' This project may have been supplanted by [[Ferret File System]], or it may also turn out to be a useful sub-goal which can be implemented fairly easily via [[Futilities/human|The Human Futilities]] toolkit.
These are based on what I had created in [[MS Access]] 97.
==Pages==
 
* [[/process]]: what it does
"[[/filaments|Filaments]]" is actually a portmanteau of "file elements", which is supposed to stand for "elemental file", but I didn't want to spell it "filements" because the obvious pronunciation would be "file-ments". Maybe "felements" would have been better. Or maybe something more like "dataset" or "byteset" or "pattern".
* [[/SQL]]: tables
<mysql>CREATE TABLE `filaments` (
* [[/terms]]: terminology
  `ID`        INT NOT NULL AUTO_INCREMENT,
* [[/archive]]: obsolete documentation
  `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>
* Basically, if you want to describe a file, you don't; you describe the filament. Files are localized instances (possibly imperfect copies) of filaments.
* '''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.
<mysql>CREATE TABLE `files` (
  `ID`          INT NOT NULL AUTO_INCREMENT,
  `ID_Folder`  INT NOT NULL    COMMENT "Folders.ID of parent folder",
  `ID_Filament` INT DEFAULT NULL COMMENT "Filaments.ID for this file",
  `FileName`    VARCHAR(255)    COMMENT "just the filename.ext, not the full path",
  `FileSize`    INT DEFAULT NULL COMMENT "number of bytes in file",
  `FileCksum`  INT DEFAULT NULL COMMENT "file's checksum (algorithm to be worked out later)",
  `WhenCreated` DATETIME DEFAULT NULL COMMENT "file's creation timestamp",
  `WhenChanged` DATETIME DEFAULT NULL COMMENT "file's modification timestamp",
  `FirstFound`  DATETIME NOT NULL    COMMENT "time/date when file was first found during a scan",
  `LastFound`  DATETIME NOT NULL    COMMENT "time/date when file was most recently found during a scan",
  `isFound`    BOOL DEFAULT FALSE    COMMENT "TRUE = was found on most recent scan",
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;</mysql>

Latest revision as of 13:40, 25 February 2024

About

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

Status

2022-09-23 This project may have been supplanted by Ferret File System, or it may also turn out to be a useful sub-goal which can be implemented fairly easily via The Human Futilities toolkit.

Pages

Retrieved from "https://wooz.dev/mw/index.php?title=Ferret_File_System/v0.1&oldid=7056"