Migrate ARTIS database from SQL to lightweight single file

[theamarks]

Problem/Observation

Difficult to setup and maintain local SQL database. Uncertainty introduced around corresponding table versions. Corresponding metadata difficult to find.

Proposed Solution

Create a .duckdb single file database

Alternatives Considered

SQLite

To-do

• determine where (github repo) to setup duckdb file
• create database metadata that also lives in .duckdb - linkML may be an option documentation here