=====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