Patrick Clearwater opened issue #3: Create GWCandidate at CAS-eResearch / GWDC / GWLab GWCandidate

Patrick Clearwater
2024-02-12T00:31:16Z

GWCandidate is the data model for candidates, which may come from many sources.

Here is the roadmap we discussed in the meeting 2022-04-05:

Start by just doing the backend, not the front end

Use a relational database, following the schema (see attached and discussion below)

Don’t use MongoDB (not a science requirement either way but it seemed the consensus was M[ySQL/ariaDB] was easier)

Initially load the candidates from Viterbi

CWFollowup can then read in candidates from GWCandidate

We also support uploading directly via the API (didn’t actually discuss this but it seems like it would have to happen? - see CAS-eResearch/GWDC/projects/gwlab#9)

Support uploaded CSVs (separate issues for tracking this)

Must use Rust and/or a different programming language

The schema is attached. My proposal (for discussion) would be to create database fields for everything except the ones marked “Viterbi-specific”; those latter threemetadata-v1.1.ods can live in the JSON blob at the end.