POSTER P614: AstroDB Toolkit: A Collaborative Data Management Tool

ADASS posters are displayed all week

When

11:14 p.m., Nov. 8, 2023

Theme: Software, tools and standards for Solar System, heliophysics, and planetary research

pretalxeposter

We present the AstroDB Toolkit, a collaborative database management tool, intended for small-to-medium sized projects to manage their living datasets. The database management relies on a review using GitHub, thus integrating itself into the existing workflows of many Astronomers. The Toolkit relies on the astrodbkit2 python package to convert back and forth between a non-relational and relational database that can be used with established packages like SQLAlchemy. This facilitates a novel way of reviewing, updating, and version-controlling the contents of medium-scale databases while still integrating with existing tools. We have also developed a web app which presents the database contents as an interactive, queryable website. The proof-of-concept application is the SIMPLE Archive of low mass stars, brown dwarfs, and exoplanets (https://simple-bd-archive.org/). In this poster, we present the architecture of the AstroDB Toolkit, the document-store model, and the GitHub workflow for reviewing and approving database modifications.

Contacts

Kelle Cruz