Interface Arduino to MySQL using Python




Here’s a brief tutorial that should get you up and running interfacing your Adruino with a MySQL database. For the sake of this tutorial, I am assuming you know how to set up and use MySQL. This tutorial does not require much Python experience, but you will be required to install two Python libraries for this project.
Interface Arduino to MySQL using Python




Glad we’re on the same page, let’s get to it!

Step 1: Downloading and Installing the Python Libraries

First I’ll point you in the right direction for installing the required Python libraries. First you’ll need to install the pySerial library. Simply put, the pySerial library allows your Python script to talk with the serial port in which the Arduino is connected. I.e. you can kind of think of it as a stream connecting the Arduino code to the Python code (insert other silly analogies here).

1. You can download the pySerial library here:
https://pypi.python.org/pypi/pyserial

2. For mac or linux users, download the file and extract it. Open terminal and cd into the extracted folder and run the following command:

python setup.py install

This will install the pySerial package. (screen shot below)

Next, we will install the library to allow Python to talk with MySQL called MySQLdb.
I just want to note, this step can be very annoying, but very rewarding once completed. I have included a guide for you to follow, but I recommend you have MySQL, python, and XCode(or the latest GCC) installed before you try and install MySQLdb.

1. download the library from source forge:
http://sourceforge.net/projects/mysql-python/?source=dlp

READ  Android talks to Arduino board

2. If you’re lucky enough, you should just be able to download it, extract it, open Terminal, cd into the folder and run python setup.py install, just as you did before. If this works, you’re awesome and you should awesome, but if not, this guide should help. Note, I had to do step 6 before step 3.

http://stackoverflow.com/questions/1448429/how-to-install-mysqldb-python-data-access-library-to-mysql-on-mac-os-x

Step 2: Fewf, now let’s set up our Arduino!

Fewf, now let's set up our Arduino!

All right. Now that we’ve gotten all of the annoying steps out of the way, let’s get to the fun parts!

For the sake of getting you up and running, I’ll keep this short and concise.

1. Let’s get our Arduino sending some output.

What we’re going to do is essentially send data from our Arduino for our Python code to process, so let’s first get our Arduino to send some data.

I have a temperature/humidity sensor lying around, so I’m going to take the readings from this and send them to my Python code.

Here’s the sample code:

//you can ignore this part, just for the temperature sensor
#include “DHT.h”
#define DHTPIN 2
#define DHTTYPE DHT22
DHT dht(DHTPIN, DHTTYPE);

void setup() {
Serial.begin(9600);
dht.begin(); //start the temp reading (agian only for temperature sensor
}

void loop() {
//read the temperature and humidity (temperature sensor specific code)
float h = dht.readHumidity(); //read humidity
float t = dht.readTemperature(); //read temperature (C)

// check if returns are valid
if (isnan(t) || isnan(h)) {
Serial.println(“Failed to read from DHT”);
} else {  //if it read correctly
Serial.print(h);     //humidity
Serial.print(” \t”); //tab
Serial.println(t);   //temperature (C)
}
}

It should be pretty straight forward. Again, I’m using a temperature/humidity sensor to get some data to send to the Python, but this could obviously be substituted with anything other data; it’s just used as an example!

READ  Add Linux, WiFi, Ethernet and USB to Arduino

Note: the Serial.print lines are the data that is being sent to the serial port that the Python code will be grabbing and doing all the wonderful things with it.

Step 3: Let’s go ahead and set up our MySQL

Now that we have the code running on our Arduino, we need some Python code to talk to it, but first we need a MySQL database and table to store this data.

For more detail: Interface Arduino to MySQL using Python




This Post / Project can also be found using search terms:

  • send data from Arduino to python and mysql
  • how to put arduino serial port data to mysql python
  • https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1840 DpWmoGOUBPVvouYWJ6RqycAYxVbD799L4MgEfkZlYNVbCeFnIHKmGrGAWdij3407 57606785a8b9dfb94c489febf91802f84e5ad2cf&uuid=&state=_BLhILn4SxNIvvL0W45KSic66uCIg23qh8iRG98qeIXme
  • https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1842 t8OtKuFZEcPiGEhJYJh0Hddi4QiXx-bhUltJ0hsPQYsaeWKvZwtGqiIJugk3gQJE 6a3d2f1f66c4e078318baa71104acc72f427b484&uuid=&state=_BLhILn4SxNIvvL0W45KSic66uCIg23qh8iRG98qeIXme

Leave a Comment

*
= 3 + 2

(Spamcheck Enabled)

Read previous post:
Arduino light seeking robot
LDR Robot using an Arduino

LDR Robot with IR and a Servo The LDR/IR Robot is designed to seek out light and avoid obstacles. The...

Close
Scroll to top