ust:meeting_minutes_november_22_24_2022 [Smart Campus Energy Lab Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

=====Firmware Team Meeting - November 22, 24, 2022=====
**Attended: Jaeden, Jon, Lyon**\\

=====Updates=====
**November 22, 2022**
  * New simplified schema -> using the one last semester's team is coming up with
    * CREATE TABLE weather_node (
            weatherbox INTEGER,
            node_addr INTEGER,
            overflow_num INTEGER,
            uptime_ms BIGINT,
            n INTEGER,
            batt_mv INTEGER,
            panel_mv INTEGER,
            bme280_pressure_pascals INTEGER,
            bme280_temperature_kelvin INTEGER,
            bme280_humidity_percent INTEGER,
            apogee_w_m2 FLOAT,
            sp215_irradiance_watts_per_square_meter BIGINT
        )
  * Create an SQL file (or migration script) to add the new table
  * Test this new table locally
  * Migrate the gateway to store all packets into this unified table
  * Deploy the gateway to staging to test it
  * Deploy the gateway to production
  * Change the firmware to use the new format
  * Deploy firmware on boxes
  
**November 24, 2022**
  ** Troubleshot with Apple and Guava 


===== Goals =====
  * Gateway maintenance 

===== Meeting =====
  * Tuesday, Thursday: 1:00-3:30pm