Identify additional tool development needed for shipping .duckdb to users

[theamarks]

Description

We need to test the new duckdb data base format and metadata schema.

• Do we currently have the tools required for users to query data and metadata smoothly?
• Existing R or python packages? exploreARTIS:: package? duckplyr:: package? etc.

Ideally in the future we would develop new functions in existing R package to help users interact with .duckdb
Seafood-Globalization-Lab/exploreARTIS Github repo

To-Do

• Upload .duckdb protype to Google Drive to share with Jessica and Althea
• Write example .R script to simulate a basic ARTIS analysis using the .duckdb prototype (how would a user query or extract data from .duckdb

# example script could include: 

# connect to .duckdb
# query tables using R package duckplyr

# Get SAU Production dataframe
prod_sau <- dbGetQuery(con, "SELECT * FROM sau_production") %>%
  select(-record_id) 

# Get Species metadata into local environment object
sciname_metadata <- dbGetQuery(con, "SELECT * FROM sciname") %>%
  select(-record_id)

• Write R function to extract/query EML metadata