Miles Dyson, #2964
https://www.youtube.com/watch?v=6x_5pi7v65k
Slide 24
Slide 24 text
No content
Slide 25
Slide 25 text
76 million
data points
Slide 26
Slide 26 text
No content
Slide 27
Slide 27 text
No content
Slide 28
Slide 28 text
No content
Slide 29
Slide 29 text
No content
Slide 30
Slide 30 text
pointcast
fixed sensors
Slide 31
Slide 31 text
No content
Slide 32
Slide 32 text
No content
Slide 33
Slide 33 text
No content
Slide 34
Slide 34 text
solarcast
fixed/mobile sensors
Slide 35
Slide 35 text
drop and forget
driving principle
Slide 36
Slide 36 text
- particulate + radiation
- global wireless
- solar power
- weatherproof
Slide 37
Slide 37 text
No content
Slide 38
Slide 38 text
Dual particulate
temp & humidity
sensors
Dual radiation sensors
Battery pack and solar power controller
Cellular module
LoRa module
GPS
Accelerometer
High-voltage
supply
On/off & external power
Weatherproof
IP6X box with
tripod mount
Air outlet
Air inlet
Main CPU
w/BLE
Slide 39
Slide 39 text
Devices: we have many, lots of data
• bGeigie Nano (and friends)
• Pointcast
• Solarcast
• Large community with other devices as well
Slide 40
Slide 40 text
the infrastructure
Slide 41
Slide 41 text
api.safecast.org
Slide 42
Slide 42 text
ingest.safecast.org
Slide 43
Slide 43 text
ingest.safecast.org
Slide 44
Slide 44 text
Ruby @ Safecast
Slide 45
Slide 45 text
The pros
Slide 46
Slide 46 text
good DB hygiene
RUBY: THE PROS
Slide 47
Slide 47 text
interconnectivity
RUBY: THE PROS
Slide 48
Slide 48 text
approachability
RUBY: THE PROS
Slide 49
Slide 49 text
The cons
Slide 50
Slide 50 text
performance (sometimes)
RUBY: THE CONS
Slide 51
Slide 51 text
high rate of change
RUBY: THE CONS
Slide 52
Slide 52 text
high market rate
RUBY: THE CONS
Slide 53
Slide 53 text
the upgrades
6 years of them
Slide 54
Slide 54 text
No content
Slide 55
Slide 55 text
- love your test suite
- mind your CI
- deploy frequently
KEY LEARNINGS
Slide 56
Slide 56 text
the data
6 years of that too
Slide 57
Slide 57 text
- ~30G postgis db
- growing rapidly
- mostly two tables
LONG TERM TIME SERIES