1 

     2 Just a simple pure-data filesystem stored in a SQL database. Implementation using PostgreSQL.

     3 No weird dynamic magic.

     4 

     5 

     6 file_tree:

     7     offset              serial4                     ephemeral counter used to tell one file entry from another

     8     ino                 int4 -> inodes.ino          the file inode

     9     ino_dir             int4 -> inodes.ino          the file's inode if it's a dir, NULL otherwise

    10     name                varchar(256)                the filename

    11     parent              int4 -> file_tree.ino_dir   file entry's parent dir

    12     

    13     unique(ino_dir)

    14     unique(name, parent)

    15 

    16 inodes:

    17     ino                 serial4                 inode number

    18     type                char(3)

    19             REG                         normal file

    20             DIR                         directory

    21             LNK                         symlink

    22     mode                int2                    file access modes 

    23     data                oid                     type=REG -> file data, else NULL

    24     link_path           varchar(512)            type=LNK -> symlink target, else NULL

    25