Heatmap doesn't update after creating new record

[Daethyra]

For some reason the Streamlit application shows the heatmap with the data as loaded when the application started. The heatmap doesn't properly refresh when new entries are added to the database. The ingestion script is accurately creating the number of entries per smoke found in a given spreadsheet's row.

Facts:

• ingest_spreadsheets.py successfully adds entries, entries are reflected in the heatmap upon loading the application

• main page 'Record Event' button shows success message, however the entry is not reflected in the heatmap

  • tried 'CTRL + R', rebooting application
    • heatmap does not change

• Either:

  • The record button doesn't properly record entries
    • I verified that new entries DO show in the habitrack.db file, but are NOT reflected in the heatmap
  • The heatmap is loading cached data
  • There's a database connection problem at the time of loading data for the heatmap

[Daethyra]

IMPORTANT: The heatmap works perfectly on the Streamlit Community Cloud deployment of HabiTracker

Problem seems to be tied to local development environment