Arduino Sensor Data History in MySQL
summary
An Arduino Wi‑Fi Uno reads a DHT11 sensor and sends temperature, humidity, dew point and heat‑index directly to a Google Cloud MySQL instance using Chuck Bell’s direct MySQL connector library, inserting a row every 15 minutes (about 780 rows in the demo). Code is on GitHub, serial monitor provides realtime debug, and a Python/matplotlib script pulls the last 24 hours for historical plots. Build cost is about $65; an Ethernet shield is offered as a wired alternative.
AI-written summary · about
chapters (23)
- 0:00Introduction
- 0:35About me
- 1:28Agenda
- 4:22Funnel Cloud
- 5:09Tornado
- 7:04Walking
- 8:51Debris
- 10:31Bathroom
- 13:17Initial Weather Station
- 13:53New Weather Station
- 14:37Single Board Controller
- 16:37Data Collection
- 17:45Project Components
- 19:02Build Out
- 20:53Software
- 21:41MySQL Connector
- 23:39My Repository
- 24:20The Code
- 29:51Arduino IDE Code
- 31:53Arduino Secrets
- 34:10Ethernet Shield
- 34:59Arduino IDE Query
- 39:55Serial Plotter
related talks
40mProcessing IoT sensor data with InfluxDB
43mCreating an IoT Data Layer for Collecting, Storing, Analyzing and Reacting
25mData in the Cloud
24mPut A Database On It!
28mBuilding an IoT Monitoring App with InfluxDB
25mBreton Industrial Datalogger
40mCheers to that! | Joel Lord | jdsay 2022
57mTaming IoT Data: Making Sense of Sensors with SQL Streaming