search

IKSG / nsf-file-server

SFTP server backed by an NSF
Apache License 2.0
3 stars 0 forks source link

Consider alternative storage mechanisms #3

Open jesse-gallagher opened 4 years ago

jesse-gallagher commented 4 years ago

The storage system is designed to use a couple views for document lookup. It'd be potentially more efficient to modify file storage (maybe using just binary data blobs) and potentially the hierarchy (it could be done graph-style).

On the other hand, the way it works now is explicable and provides nice "diagnostics" in the Notes client.

jesse-gallagher commented 4 years ago

It may be worth organizing documents documents in a response hierarchy, keeping the current benefits of explicability in Notes and even improving upon that with cut/paste behavior. With "store specialized response hierarchy", this would essentially be the "graph" idea but supported by Notes.

The trouble would be that looking up a document by path would either require duplicating the path in a field in the doc (which would be tedious and fault-prone) or making multiple NIF calls to walk down the path. That would either be done by walking down the response hierarchy (which would likely require manual filtering, since I don't think it would do multiple key lookups) or maintaining a "files by parent" view to repeatedly look up by $REF value.