GCT-Rest

A sample repository to support New To Tech sessions exploring databases for Gem City Tech.

Basic app structure shamelessly stolen from here.

See relevant presentations:

• RDBMS
• Data Structures
• Database Decisions

How to run

Prerequisites

You must have Python 3.12 and Poetry installed.

Execution

Ensuring that you have Poetry available in your terminal, run

poetry shell

to use Poetry's virtual environment, and then

poetry install

to install Streamlit and the other dependencies. Then, run the app using Streamlit:

streamlit run main.py

Suggested Exercises

Starting Out

• Add the 'address' field to the database (which model class does it belong in?)

• Add a page (reachable from the sidebar) which allows you to search for and display a Geo

• Display all measurement sites in the above Geo both in a table and on a map

• Add forms where Geos and/or Measurement Sites can be created, updated, and deleted

• Display measurement data

More Involved

• Add caching to the application where appropriate

• Grab measurement data for previous years here and incorporate them into the app

• Create a map of measurement sites where measurements (selectable from a dropdown) exceed a threshold (set by a slider)