Differences

This shows you the differences between two versions of the page.

--- ust:meeting_minutes_november_22_24_2022 [2022/10/25 23:20]
jchang created
+++ ust:meeting_minutes_november_22_24_2022 [2022/12/05 23:22] (current)
jchang [Updates]
@@ Line 4: / Line 4: @@
 =====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