terom@24: 
terom@24: Just a simple pure-data filesystem stored in a SQL database. Implementation using PostgreSQL.
terom@24: No weird dynamic magic.
terom@24: 
terom@24: 
terom@24: file_tree:
terom@38:     offset              serial4                     ephemeral counter used to tell one file entry from another
terom@38:     ino                 int4 -> inodes.ino          the file inode
terom@38:     ino_dir             int4 -> inodes.ino          the file's inode if it's a dir, NULL otherwise
terom@38:     name                varchar(256)                the filename
terom@38:     parent              int4 -> file_tree.ino_dir   file entry's parent dir
terom@38:     
terom@38:     unique(ino_dir)
terom@38:     unique(name, parent)
terom@24: 
terom@24: inodes:
terom@24:     ino                 serial4                 inode number
terom@24:     type                char(3)
terom@24:             REG                         normal file
terom@24:             DIR                         directory
terom@38:             LNK                         symlink
terom@24:     mode                int2                    file access modes 
terom@38:     data                oid                     type=REG -> file data, else NULL
terom@38:     link_path           varchar(512)            type=LNK -> symlink target, else NULL
terom@24: