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 6 months ago
- Target version changed from Development 2024-07-24 sprint to Development 2024-08-07 sprint
Updated by Peter Amstutz 6 months 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 6 months ago
- Target version changed from Development 2024-08-07 sprint to Future
Updated by Peter Amstutz 6 months ago
- Target version changed from Future to Development 2024-08-28 sprint
Updated by Peter Amstutz 6 months ago
- Target version changed from Development 2024-08-28 sprint to Future