The database browser should be more advanced.
Desired features:
- selection of custom fields for columns
- sorting by column
- filtering by particular values or value ranges (of metadata)
- filtering by existence of particular fields (of metadata or trace variables)
- filtering by analytical values - e.g. length of run, range in trace values - this may be contingent on implementation of such analysis scripts and having had them automatically run on the data when uploading
- pagination? Perhaps, depending on how we envision the interface being used
- selection of time-zone by user and displaying test times accordingly, instead of UTC
Most of these functions should not have to be "hand-rolled". There are probably libraries that do that sort of thing, such as:
https://ant.design/components/table/#components-table-demo-filter-search
https://react-bootstrap-table.github.io/react-bootstrap-table2/
Efficiency at this point is not hugely important, as our database will be quite small (relative to what is "out there"), as is our user base.