search

lucawrabetz / opti-face

A suite of tools for automating experiments in computational research.
MIT License
9 stars 1 forks source link

Port initial datamodel to SQLModel. #16

Open lucawrabetz opened 3 weeks ago

lucawrabetz commented 3 weeks ago

Overview

Port datamodel that is reflected on the main branch to SQLModel.

Description

The SQLModel will be a row of the relational database for storing experiment results. In the pre-db (csv) opti-face MVP, this would have been equivalent to all the declared Features. We also need a layer of abstraction to allow the user to add and remove rows from the schema in the SQLModel, plus a simple interface to perform these tasks. We may keep something similar to the csv MVPs Feature class as the layer between user and SQLModel - see further comments on this issue.

Peter-Sanders commented 3 weeks ago
  1. add sqlmodel to source control
  2. upgrade python to 3.12
  3. upgrade other dependencies
  4. create dummy sqlite table using sqlmodel
  5. create a hardcoded version of a proper experimental db
  6. add user managed schema abstraction