Can I put items in a MySQL database directly from my Arduino?

Question

Is it at all possible to send data to a MySQL database from an Arduino with an Ethernet shield?

Currently I have data outputting to a webpage, but I would like to record a history of that data - can I send the data directly to a databse?

Alternatively, can I use PHP to capture the data and send it to a database without having a page constantly open, as I would like to record data over a series of days.

As long as you can throw the data onto a web page in the Arduino, consider creating a page on the Arduino with the data in a standard format like XML or JSON. Then you can use pretty much anything else to grab the details regularly and stuff them in a database. Everything from your phone to an IBM mainframe will have tools available to grab data from a web page by http, and throw it into a database with ease. I'd do as much heavy lifting outside the Arduino as you can; there's not a lot of headroom for complex work on them. — Matt Gibson
– Matt Gibson, Commented Jun 23, 2014 at 17:46

Mchl · Accepted Answer · 2012-11-21 00:08:05Z

4

Yes you can, although it might be tediouis. The details of client/server protocol are here: http://dev.mysql.com/doc/internals/en/client-server-protocol.html so it's just a matter of implementing it in Arduino. Given program memory limitations, it might a difficult task though.

The other option, having database exposed as a webservice would be a lot easier. You can define the protocol however you wish, and leave all MySQL handling to PHP.

edited Nov 21, 2012 at 0:08

answered Feb 26, 2012 at 21:58

Mchl

62.4k9 gold badges121 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

juanrpozo · Accepted Answer · 2012-02-26 21:45:31Z

2

Without a web server and PHP, you would need a MySQL client library for the Arduino, but I don't think one exists. AFAIK it's not possible to communicate directly with the MySQL server otherwise.

If you install a web server with PHP alongside MySQL, you can set up a PHP script that listens to the Arduino's requests and stores the passed-in data into the database. Those connections are between the Arduino and the web server, so you don't have to keep any page constantly open.

Note that the PHP script won't listen just to your Arduino but to anyone sending a request to it, so you should make sure that you can trust the passed-in data before storing it in the database.

answered Feb 26, 2012 at 21:45

juanrpozo

6974 silver badges8 bronze badges

Comments

Charles Bell · Accepted Answer · 2013-09-27 20:42:33Z

2

This is now possible with the new Connector/Arduino MySQL Database connector. Check it out at: https://launchpad.net/mysql-arduino. Also, see my blog at: http://drcharlesbell.blogspot.com/2013/04/introducing-mysql-connectorarduino_6.html

answered Sep 27, 2013 at 20:42

Charles Bell

211 bronze badge

Collectives™ on Stack Overflow

Can I put items in a MySQL database directly from my Arduino?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related