Idea #21844
open
add file_properties column for per-file metadata in a collection
Added by Peter Amstutz about 1 month ago.
Updated 1 day ago.
Description
https://www.postgresql.org/docs/current/datatype-json.html
Since Postgres 12, JSON path queries can dig into JSON structures and can be indexed. This should give us a path to implementing per-file properties on collections that can be queried.
Investigate and propose a detailed design for per-file metadata.
- Description updated (diff)
- Description updated (diff)
- Target version changed from Development 2024-07-24 sprint to Development 2024-08-07 sprint
I want to think about this one a bit. I think there's a couple ways to approach about this. One is tagging of individual files, which is what we've sketched out here.
Another another approach would be to design a more general table model for metadata -- a primary key (sample id / patient id or whatever) and a number of fields, which can include references to files.
As a data scheme, it needs to reasonably efficient for browsing in workbench, and basic filtering (ideally should be able to efficiently look up by any field).
- Target version changed from Development 2024-08-07 sprint to Future
- Target version changed from Future to Development 2024-08-21 sprint
- Target version changed from Development 2024-08-21 sprint to Future
Also available in: Atom
PDF
Updated by