Arduino sensor data to MySQL

Saving sensor data directly to database is very important learning for any project dealing with IoT. Python is very powerful scripting language to automate the process. Getting data from Arduino as usual using Serial.

First run analog_read program on Arduino then run a python script to automate the SQL data insertion process. The major part is creating database in MySQL after installation. Get all the codes from my github link:

https://github.com/prasanpro/Arduino-MySQL-Sensor-DatabaseArduino_SQL

Inserted data can be checked either using query language on command line or HeidiSQL can be used to verify inserted data.

HeidiSQL

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s