A simple webapp developed in Python to register rock samples collected from a well or borehole. This tool was developed to use the existing data-entry forms of an MS Access database (published here) as a front-end client connected to a remote MySQL database. It includes a Django data model for a MySQL database, as well as scripts to migrate data from Microsoft Access to MySQL. The data model was developed the package Pydantic, helps to describe relationships between entities without having to rely on a specific implementation, webapp or database. This data model can also be used to generate schemas.
Initially, this webapp would have been used to register samples from the geothermal well installed on TU Delft campus (https:www.tudelft.nl/geothermalwell) but drilling activities ended before the tool was completed. However, this sample registration tool could be of interest for other borehole drilling projects.
The webapp was developed by Jose Urra Llanusa, software developer from TU Delft Digital Competence Centre (DCC), and the pydantic data model is based on the data model from the MS Access database developed by Liliana Vargas Meleza, Data Manager of the geothermal well.
ER -