Safari, the world’s most comprehensive technology and business learning platform.

Find the exact information you need to solve a problem on the fly, or go deeper to master the technologies and skills you need to succeed

Start Free Trial

No credit card required

O'Reilly logo
Beginning Sensor Networks with Arduino and Raspberry Pi

Book Description

Beginning Sensor Networks with Arduino and Raspberry Pi teaches you how to build sensor networks with Arduino, Raspberry Pi, and XBee radio modules, and even shows you how to turn your Raspberry Pi into a MySQL database server to store your sensor data!

First you'll learn about the different types of sensors and sensor networks, including how to build a simple XBee network. Then you'll walk through building an Arduino-based temperature sensor and data collector, followed by building a Raspberry Pi-based sensor node.

Next you'll learn different ways to store sensor data, including writing to an SD card, sending data to the cloud, and setting up a Raspberry Pi MySQL server to host your data. You even learn how to connect to and interact with a MySQL database server directly from an Arduino! Finally you'll learn how to put it all together by connecting your Arduino sensor node to your new Raspberry Pi database server.

If you want to see how well Arduino and Raspberry Pi can get along, especially to create a sensor network, then Beginning Sensor Networks with Arduino and Raspberry Pi is just the book you need.

What you'll learn

  • How to build sensor nodes with both Arduino and Raspberry Pi!

  • What is XBee?

  • What methods you have for storing sensor data

  • How you can host your data on the Raspberry Pi

  • How to get started with the MySQL database connector for Arduino

  • How to build database enabled sensor networks

Who this book is for

Electronics enthusiasts, Arduino and Raspberry Pi fans, and anyone who wants hands-on experience seeing how these two amazing platforms, Arduino and Raspberry Pi, can work together with MySQL.

Table of Contents

  1. Title Page
  2. Dedication
  3. Contents at a Glance
  4. Contents
  5. About the Author
  6. About the Technical Reviewer
  7. Acknowledgments
  8. Introduction
  9. CHAPTER 1: Introduction to Sensor Networks
    1. Anatomy of a Sensor Network
    2. Communication Media
    3. Types of Sensor Nodes
    4. Sensors
    5. Summary
  10. CHAPTER 2: Tiny Talking Modules: An Introduction to XBee Wireless Modules
    1. What Is an XBee?
    2. XBee Primer
    3. An XBee Wireless Chat Room
    4. Building an XBee-ZB Mesh Network
    5. Component Shopping List
    6. Troubleshooting Tips and Common Issues
    7. Summary
  11. CHAPTER 3: Arduino-Based Sensor Nodes
    1. What Is an Arduino?
    2. Arduino Tutorial
    3. Hosting Sensors with Arduino
    4. Project: Building an Arduino Temperature Sensor
    5. Project: Using an Arduino as a Data Collector for XBee Sensor Nodes
    6. Component Shopping List
    7. Summary
  12. CHAPTER 4: Raspberry Pi-based Sensor Nodes
    1. What Is a Raspberry Pi?
    2. Raspberry Pi Tutorial
    3. Hosting Sensors with Raspberry Pi
    4. Project: Building a Raspberry Temperature Sensor Node
    5. Project: Building a Raspberry Barometric Pressure Sensor Node
    6. Project: Creating a Raspberry Pi Data Collector for XBee Sensor Nodes
    7. Component Shopping List
    8. Summary
  13. CHAPTER 5: Where to Put It All: Storing Sensor Data
    1. Storage Methods
    2. Local Storage Options for the Arduino
    3. Local Storage Options for the Raspberry Pi
    4. Remote Storage Options
    5. Component Shopping List
    6. Summary
  14. CHAPTER 6: Turning Your Raspberry Pi into a Database Server
    1. What Is MySQL?
    2. Getting Started with MySQL
    3. Building a Raspberry Pi MySQL Server
    4. Component Shopping List
    5. Summary
  15. CHAPTER 7: MySQL and Arduino: United at Last!
    1. Introducing Connector/Arduino
    2. Building Connector/Arduino-Enabled Sketches
    3. Troubleshooting Connector/Arduino
    4. A Tour of the MySQL Connector/Arduino Code
    5. Project: Building a MySQL Arduino Client
    6. Project Example: Inserting Data from Variables
    7. Project Example: How to Perform SELECT Queries
    8. Component Shopping List
    9. Summary
  16. CHAPTER 8: Building Your Network: Arduino Wireless Aggregator + Wireless Sensor Node + Raspberry Pi Server
    1. Data-Aggregate Nodes
    2. Component Shopping List
    3. Summary
  17. CHAPTER 9: Planning Wireless Sensor Networks
    1. Sensor Networks Best Practices
    2. Choosing Sensor Nodes
    3. Project: Home Temperature-Monitoring Network
    4. Optional Component Shopping List
    5. Summary
  18. APPENDIX: Shopping List
  19. Index