I like a hierarchy, too. Presumably the underlying engine could be a database but it would at least appear to the user as a tree. But with the option to find files with SQL or a SQL-like language. I would love to be able to find files based on all kinds of metadata that was available for searching with the OS’s file system, and not using any special tools. I’m thinking things like EXIF data, audio file metadata, text file line count, and so on.
The tree-view is practical for users but seems impractical for relational database performance.
SELECT * FROM files p
LEFT JOIN files c ON p.id = c.parent_id
LEFT JOIN files gc ON c.id = gc.parent_id
LEFT JOIN files ggc ON gc.id = ggc.parent_id
....
where p.id = 123
Comments
I like a hierarchy, too. Presumably the underlying engine could be a database but it would at least appear to the user as a tree. But with the option to find files with SQL or a SQL-like language. I would love to be able to find files based on all kinds of metadata that was available for searching with the OS’s file system, and not using any special tools. I’m thinking things like EXIF data, audio file metadata, text file line count, and so on.
The tree-view is practical for users but seems impractical for relational database performance.
SELECT * FROM files p LEFT JOIN files c ON p.id = c.parent_id LEFT JOIN files gc ON c.id = gc.parent_id LEFT JOIN files ggc ON gc.id = ggc.parent_id .... where p.id = 123
Datalog could handle it, though.