SoftwareApplication
name: rockin-webapp
description: RockIn - A webapp for rock sample registration
description: 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.
code repository: https://data.4tu.nl/v3/datasets/33ef5067-bfd7-46a0-aff8-edbe70773374.git
author: Person
  given name: Jose
  family name: Urra Llanusa
  name: Jose Urra Llanusa
author: https://orcid.org/0000-0002-6880-1539
keywords: cuttings
keywords: geoenergy
keywords: webapp
keywords: borehole
keywords: drilling cuttings
keywords: database
keywords: sample inventory
keywords: borehole drilling
keywords: rock sample
keywords: core
keywords: geothermal well
keywords: shallow borehole
keywords: deep borehole
programming language: HTML
programming language: JavaScript
programming language: Markdown
programming language: Other
programming language: Python
programming language: Shell
programming language: YAML
license:
  creative work: creativeWork
    name: MIT

https://orcid.org/0000-0002-6880-1539
type: Person
given name: Liliana
family name: Vargas Meleza
name: Liliana Vargas Meleza