Idea #21844
openadd file_properties column for per-file metadata in a collection
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.
Updated by Peter Amstutz about 1 month ago
- Target version changed from Development 2024-07-24 sprint to Development 2024-08-07 sprint
Updated by Peter Amstutz about 1 month ago
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).
Updated by Peter Amstutz 21 days ago
- Target version changed from Development 2024-08-07 sprint to Future
Updated by Peter Amstutz 21 days ago
- Target version changed from Future to Development 2024-08-21 sprint
Updated by Peter Amstutz 21 days ago
- Target version changed from Development 2024-08-21 sprint to Future