May 24, 2022

- objective of the meeting is to help team members understand how to add data to ICE-D through the admin panel.

- Ryan gave Greg an example to upload and Greg walked members through how that is done on the admin page in the web app.

- members with windows computers were also shown a tutorial to connect their personal computers to the database through Matlab. Mac users will need to talk to Greg offline since Joe is much more familiar with windows computer procedures.

May 17, 2022

- Objective of the meeting is to get team members up to speed on ICE-D - how it works, how data is added to the database, etc.

- Greg began by laying out the structure of the database

- separating and recording the observations that are permanent (i.e., the lat lon elevation, 10Be conentration, etc.) in an easily accessible archive and then as new methods for calculating ages are updated, users don't need to keep publishing and handling spreadsheets of pre-existing data.

- further, the database needed a sort of back end infrastructure that stores the data live and can be updated and populated by multiple users. Data should also be readily available to be delivered dynamically when asked.

- the database is run through MySQL and is stored on a google virtual server that the grant pays for for a monthly fee.

- Briefly, the cost to connect multiple computers to the virtual server in google scales, and so along with security reasons it is easier to have users connect to a separate virtual server (stoneage) that has access to the server storing ICE-D.

- The connection to stoneage is set up through SSH tunnels. Specifically, we connect user's personal machines using key pairs, one that is public and one that users generate and store and privately on their own machines (see tutorials for more details on how to make those).

- Greg showed the tables plus MySQL connection page to demonstrate how users connect through stoneage to ICE-D using the SSH tunnel and how each user will be set up as a 'reader' (i.e., users will have read only privileges and won't be able to edit the database directly from their SQL clients).

- Now that everyone is connected to ICE-D as a reader, Greg is showing people what the data actually looks like in ICE-D.

- attendees spent a while talking about various queries that can be written in SQL clients to collect specific data (e.g., select all data that have both 10Be and 14C measurements, select and concat relevant sample info into a string of code that can be entered into the version 3 calculator).

- Goals for next meeting: attendees should familiarize themselves with SQL queries in their SQL clients. We might plan on configuring connections to the database through Matlab, and we can discuss data entry as well.