Are you building an IOT solution and want to know how to store and retrieve your IOT data? Perhaps you're new to database systems and want to learn how to use them while you explore the exciting world of IOT.

This book is the answer for both scenarios; whether you're new to IOT and want to know how to leverage MySQL in your solution or you've wanted to learn more about MySQL, this book will provide many of the answers you seek.

The book also covers how to design your IOT solution around your data. Not only will you learn more about MySQL, but you will also see how best to deploy MySQL in your IOT solution using low-cost computer boards such as the Raspberry Pi, Beaglebone Black, Intel Galileo, and more.

Finally, the book will give you a thorough overview of how data can be augmented and annotated to make it easier to glean the golden nuggets of knowledge you seek while wading through your sensor data. …

The newest release of the MySQL Connector/Arduino library release-1.1 alpha is available for download. This new version represents a major step forward for the library in ease of use. Here are just a few of the important changes in this release.

• Added to Library Manager : yes, you can download and install the library from the Arduino IDE now. Just open the Library Manager and search for "MySQL".
• More Example Sketches : there are many more example sketches of how to use the new library from basic connections to complex queries and more! 
• Redesigned Classes : the library has been redesigned with new classes making it much easier to use a wider variety of shields and modules. Now, you pass in the Client class for your shield and so long as it adheres to the Ethernet.Client primitive, you can use any library to initiate …

I am very pleased to announce my latest book, "3D Printing with Delta Printers" (Apress 2015). This book is focused entirely on delta printers including how to properly, build, configure, calibrate, use, and maintain your delta printer. The book is a companion to my "Building and Maintaining Your 3D Printer" (Apress 2014).


You can find both books in bookstores and online book retailers.

Enjoy!

After several iterations and a long period of community evaluation, I am happy to report I've released the newest, stable release of the MySQL Connector/Arduino. This library is designed to allow you to connect your Arduino via an Ethernet or WiFi shield to a MySQL database server running on your network (or the Internet!).

New Documentation! Best of all, I've written a reference manual that includes examples of how to use the connector in a variety of ways. Included in the document are advice on how to write your sketches, troubleshooting tips, and a long FAQ compiled from the many questions from my blogs.

Changes The only code change in this release is to fix a defect when using the connector with the latest versions of MySQL.

Downloading the Connector To download the connector library and the new reference manual, visit …

I've completed a new release of the Connector/Arduino! The new release contains some minor improvements as follows.

• Code has been changed slightly to help with long latency issues over wifi and slow connections.
• A new cleanup method was added to cleanup a final OK packet after a stored procedure call with a result.
• Code now compiles without errors for the latest Beta Arduino IDE (const error).

Enjoy!

I've completed a new release of the Connector/Arduino! The new release contains some major improvements with memory handling.

• The library has been trimmed to save memory.
  • Static strings moved to PROGMEM strings
  • Unused structures removed (e.g. ok_packet)
  • Moved two more methods to optional compilation
• The WITH_SELECT is turned *OFF* by default. If you want to use select queries, be sure to uncomment this in the mysql.h file.
• Added a CHANGES.txt file to track changes between releases.

Memory, What Memory?
If you have used previous versions of the connector in medium to large sketches or have long query strings or even many variables, chances are you have hit the memory limit for your wee Arduino board.

This can manifest itself in a number of ways. Most notably, the sketch may work …

The wild and crazy guys over at S&T Geotronics, James Sanderson and Marc Tessier, have decided to go full tilt with a Kickstarter version of their DIY Open Enigma Project.  For those who missed the fanfare last year, they were featured on Instructables showing how to build an Arduino-based encryption machine that works exactly like a WWII era Enigma.  You know, the thing that Alan friggin' Turing and his team at …

I've completed a new release of the Connector/Arduino. The new version supports a few refinements and a new feature.

• New! disconnect() method - enables disconnect from server. Note: you must call mysql_connect() to reconnect.
• Better error handling for dropped packets. No more random reboots when bad packet appears.
• Library can recover from short-term loss of connectivity. Along with bad packets is a check to make sure what is received is valid making the connector ignore garbage packets associated with a dropped connection.
• Detection of Out of Memory condition. Should there not be enough memory to allocate the buffer for the Connector, you will see an OOM error (enable the serial monitor to see the errors). This reduces random reboots when memory gets too low.

I made this release because a number of people were running into problems with noisy, tenuous, or just plain …

Chuck Bell, one of my former colleague from MySQL AB, has created a connector for Arduino to MySQL. So this allows Arduino code to be a direct client of a MySQL or MariaDB server, with Ethernet and WiFi shields supported.

With Arduino boards being used more and more, this can come in really handy – not only for retrieving (for instance) centralised configuration data, but also for logging. Useful stuff. Thanks Chuck!

Links

• Introducing MySQL Connector/Arduino 1.0.0 beta (original article)
• MySQL Connector/Arduino on Launchpad
• Freetronics (Arduino gear)

There is a new release of the Connector/Arduino on Launchpad! See https://launchpad.net/mysql-arduino. The new version supports a number of refinements and a few new features. These include:

• Improved support for processing result sets
• Conditional compilation to omit result set handling features to save program space
• Support for the Arduino WiFi shield
• New version() method to check version of the connector
• Simplified download (no more patching SHA1!)

So What is It?
If you have never heard of Connector/Arduino, it is simply a library designed to allow the Arduino platform to connect to and issue queries to a MySQL Database server.

Simply add an Ethernet shield to your Arduino and use the library to connect your Arduino to a MySQL database server. Yes, no more web-based hand waving or third party systems! Cool.

New …