Beginning Sensor Networks with Arduino and Raspberry Pi

✍ Scribed by Bell, Charles

• Publisher: Apress
• Year: 2013
• Tongue: English
• Leaves: 407
• Category: Library

✦ Synopsis

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 ArduinoHow 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

Title......Page 2
Copyright......Page 3
Dedication......Page 4
Contents at a Glance......Page 5
Contents......Page 6
About the Author......Page 12
About the Technical Reviewer......Page 13
Acknowledgments......Page 14
Introduction......Page 15
Examples of Sensor Networks......Page 19
The Topology of a Sensor Network......Page 24
Wireless Networks......Page 26
Data Nodes......Page 27
Sensors......Page 28
How Sensors Measure......Page 29
Examples of Sensors......Page 33
Summary......Page 36
What Is an XBee?......Page 38
Choosing XBee Modules......Page 39
Interacting with an XBee-ZB Module......Page 41
Pin Layout......Page 45
Configuring Modules......Page 46
For More Information......Page 56
Loading the Firmware for the Modules......Page 57
Capturing Serial Numbers......Page 59
Configuring the Coordinator......Page 60
Configuring the Router......Page 61
Let the Chat Begin......Page 62
Building an XBee-ZB Mesh Network......Page 64
Forming Test Messages......Page 65
Testing the Network......Page 67
Component Shopping List......Page 71
Things to Check......Page 72
Common Issues......Page 73
Summary......Page 74
What Is an Arduino?......Page 76
Arduino Models......Page 77
Arduino Clones......Page 83
Where to Buy......Page 90
The Arduino IDE......Page 92
Project: Hardware “Hello, World!”......Page 95
Hosting Sensors with Arduino......Page 101
Project: Building an Arduino Temperature Sensor......Page 102
Hardware Setup......Page 103
Writing the Sketch......Page 105
Test Execution......Page 109
XBee Sensor Node......Page 110
Arduino with XBee Shield......Page 116
Testing the Final Project......Page 125
Component Shopping List......Page 126
Summary......Page 127
What Is a Raspberry Pi?......Page 129
Noble Origins......Page 130
Models......Page 131
A Tour of the Board......Page 132
Required Accessories......Page 134
Recommended Accessories......Page 135
Where to Buy......Page 138
Installing a Boot Image......Page 141
Booting Up......Page 143
GPIO Pin Mapping......Page 147
Required Software......Page 150
Project: Hardware “Hello, World!”......Page 151
Project: Building a Raspberry Temperature Sensor Node......Page 157
Hardware Setup......Page 158
Testing the Hardware......Page 160
Software Setup......Page 161
Testing the Sensor......Page 164
Project: Building a Raspberry Barometric Pressure Sensor Node......Page 165
Hardware Setup......Page 167
Testing the Hardware......Page 168
Software Setup......Page 169
Testing the Sensor......Page 171
Project: Creating a Raspberry Pi Data Collector for XBee Sensor Nodes......Page 172
Hardware......Page 173
Software......Page 175
Testing the Final Project......Page 178
Component Shopping List......Page 179
Summary......Page 180
Storage Methods......Page 182
Local Storage Options for the Arduino......Page 183
SD Card......Page 184
Project: Saving Data in Nonvolatile Memory......Page 185
Project: Writing Data to an SD Card......Page 196
Local Storage Options for the Raspberry Pi......Page 206
Project: Writing Data to Files......Page 207
Remote Storage Options......Page 208
Storing Data in the Cloud......Page 209
Component Shopping List......Page 232
Summary......Page 233
What Is MySQL?......Page 234
Getting Started with MySQL......Page 237
How and Where MySQL Stores Data......Page 238
How to Start, Stop, and Restart MySQL......Page 242
Creating Users and Granting Access......Page 243
MySQL and Python—MySQL Utilities......Page 244
Building a Raspberry Pi MySQL Server......Page 247
Partitioning and Formatting the Drive......Page 248
Setting Up Automatic Drive Mounting......Page 251
Project: Installing MySQL Server on a Raspberry Pi......Page 253
Advanced Project: Using MySQL Replication to Back Up Your Sensor Data......Page 259
Summary......Page 268
Introducing Connector/Arduino......Page 270
Hardware Requirements......Page 271
How to Get MySQL Connector/Arduino......Page 274
Database Setup......Page 277
Setting Up the Arduino......Page 279
Starting a New Sketch......Page 280
Testing the Sketch......Page 283
Troubleshooting Connector/Arduino......Page 289
MySQL Server Configuration......Page 290
MySQL User Account Problems......Page 291
Networking Configuration......Page 293
Connector Installation......Page 294
Other......Page 295
Library Files......Page 296
Field Structure......Page 298
Public Methods......Page 299
Example Uses......Page 300
Project: Building a MySQL Arduino Client......Page 303
Hardware Setup......Page 304
Setting Up the Sensor Database......Page 306
Writing the Code......Page 307
Test Execution......Page 309
For More Fun......Page 311
Project Example: Inserting Data from Variables......Page 312
Displaying a Result Set in the Serial Monitor......Page 313
Writing Your Own Display Method......Page 314
Example: Getting a Lookup Value from the Database......Page 317
Summary......Page 318
Data-Aggregate Nodes......Page 320
Local-Storage Data Aggregator......Page 321
Project: Data-Aggregate Node with Local Storage......Page 322
Project: Arduino Data-Aggregate Node with Database Storage......Page 343
Project: Raspberry Pi Data-Aggregate Node with Database Storage......Page 355
Component Shopping List......Page 363
Summary......Page 364
Considerations for Data-Aggregate Nodes......Page 366
Considerations for Sensor Network Databases......Page 370
Other Considerations......Page 374
Wired Or Wireless?......Page 379
Arduino or Raspberry Pi?......Page 380
Alternative Hosts......Page 382
Planning the Nodes......Page 388
Cost Considerations......Page 389
Conclusion......Page 391
Summary......Page 392
Appendix: Shopping List......Page 394
Index......Page 397

✦ Subjects

Nonfiction