Attended: Jaeden, Jon, Lyon

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

• Gateway maintenance

• Tuesday, Thursday: 1:00-3:30pm

Contributing authors:

Created by jchang on 2022/10/25 23:20.