MySQL Connector/Arduino

Fun demos; do not put DB credentials and 3306 on microcontrollers in production.

Connector/Arduino can INSERT sensor rows straight into MySQL. Good teaching toy.

Problems in production

  • Credentials in firmware
  • No pooling discipline
  • Database exposed to a device network
  • Weak TLS story on small MCUs of that era

Prefer

device → MQTT/HTTP ingest → validated service → MySQL/MariaDB

Least-privilege writer role. Protocol designed for devices. Database behind an application boundary.