Project 4: Using MySQL to Store Data

Abstract

IoT solutions, by definition if not implementation, can generate a lot of data. Indeed, most IoT solutions observe the world in one or often several ways. Those observations generate data at whatever rate the solution specifies (called a sample rate). To make the data most useful for historical or similar analytics, you have to save the data for later processing. Database systems provide a perfect solution for storing IoT data and making it available for later use. The project in this chapter takes the same project goals from the last chapter and stores the data generated in a MySQL database. The chapter also demonstrates how to retrieve that data.