MySQL for the Internet of Things
Chapter 5 ■ MySQL priMer INSERT INTO plant_monitoring.readings VALUES (1, 220, 38.9, NULL, NULL); INSERT INTO plant_monitoring.r ...
Chapter 5 ■ MySQL priMer Notice I used NULL for the last two columns. This is habit of mine from my DBA days where I always supp ...
Chapter 5 ■ MySQL priMer ■Note i will enter the query by parts so you can read the results better. as you can see, it is much ea ...
Chapter 5 ■ MySQL priMer Testing the Complex Query For the complex query, we want to know the plants that need watering today. Y ...
Chapter 5 ■ MySQL priMer Great, seven rows! Now, we’re getting somewhere. Now let’s limit the output of that result with only th ...
Chapter 5 ■ MySQL priMer Aha! Now, we’ve got it. Well, almost. We have too much information. But at least we can see the informa ...
Chapter 5 ■ MySQL priMer Plan your queries: Always include the questions you want to ask of the database when designing tables. ...
Chapter 5 ■ MySQL priMer Normalize your database: Normalization is a big deal for a lot of database experts and rightly so, but ...
Chapter 6 Building Low-Cost MySQL Data Nodes Data nodes are a key component in IOT solutions. Your solution could use one or mor ...
Chapter 6 ■ Building low-Cost MysQl data nodes The Raspberry Pi 2B has a micro SD drive^2 that you can use to boot the computer ...
Chapter 6 ■ Building low-Cost MysQl data nodes In this section, you explore the origins of the Raspberry Pi 2B, take a tour of t ...
Chapter 6 ■ Building low-Cost MysQl data nodes Models The choices for Raspberry Pi boards have grown to include four models with ...
Chapter 6 ■ Building low-Cost MysQl data nodes Figure 6-4. Raspberry Pi Compute Module Development Kit (courtesy of Raspberrypi. ...
Chapter 6 ■ Building low-Cost MysQl data nodes What happeNeD tO the $20 raSpBerrY pI? if you have been following the release of ...
Chapter 6 ■ Building low-Cost MysQl data nodes There is also a camera connector located behind the Ethernet port for connecting ...
Chapter 6 ■ Building low-Cost MysQl data nodes If you have to purchase these items, stick to the commonly available brands and m ...
Chapter 6 ■ Building low-Cost MysQl data nodes ■Tip if you plan to experiment with the gpio pins or require access to the power ...
Chapter 6 ■ Building low-Cost MysQl data nodes a raSpBerrY pI LaptOp? the raspberry pi has made a significant contribution to ph ...
Chapter 6 ■ Building low-Cost MysQl data nodes to use the raspberry pi laptop, start by connecting the hdMi cable, then any peri ...
Chapter 6 ■ Building low-Cost MysQl data nodes the best part of this project is the cost. you can find used and surplus lapdock ...
«
6
7
8
9
10
11
12
13
14
15
»
Free download pdf