Packt+ | Advance your knowledge in tech

0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Raspberry Pi 3 Home Automation Projects

You're reading from Raspberry Pi 3 Home Automation Projects Bringing your home to life using Raspberry Pi 3, Arduino, and ESP8266

Product type Paperback

Published in Nov 2017

Publisher Packt

ISBN-13 9781783283873

Length 226 pages

Edition 1st Edition

Languages

JavaScript

Tools

Arduino

Concepts

Home Automation

Authors (2):

Bhadoria

Ruben Oliva Ramos

View More author details

Table of Contents (13) Chapters

Title Page

Credits

About the Authors

About the Reviewer

www.PacktPub.com

Customer Feedback

Preface

1. Creating a Raspberry Pi-Powered Magic Mirror FREE CHAPTER

2. Automated Gardening System

3. Integrating CheerLights into a Holiday Display

4. Erase Parking Headaches with OpenCV and Raspberry Pi

5. Building Netflix's The Switch for the Living Room

6. Lock Down with a Windows IoT Face Recognition Door System

Logging spaces in a database

In this section, we will describe how to create and configure web and database servers to enable logging spaces in a parking lot using vehicle information.

Configuring a MySQL database server

In this section, you will learn how to configure a MySQL server in order to create a database and integrate everything in your dashboard in order to record data in a database.

Installing MySQL

Our Raspberry Pi 3 is being configured like a web server. In this section, we will install a MySQL database server with the following command so we can receive connections from clients, display data stored in the database, and use queries in SQL:

sudo apt-get install mysql-server

It will ask you for the password of the root user:

Connect to MySQL and type the following command:

mysql –u root -p

Type the following command:

show databases;

Here we can see databases of the system that are now installed on the server:

Installing the MySQL driver for PHP

You need the MySQL driver for PHP to access the...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at £13.99/month. Cancel anytime

Authors (2)

Bhadoria

Bhadoria

Shantanu Bhadoria is an avid traveler and the author of several popular open source projects in Perl, Python, Golang, and Node.js, including many IoT projects. When in Singapore, he works on paging and building control systems for skyscrapers and large campuses in Singapore, Hong Kong, and Macau. He has authored and contributed to public projects dealing with control over gyroscopes, accelerometers, magnetometers, altimeters, PWM generators, and other sensors and controllers, as well as sensor fusion algorithms such as Kalman filters. Shantanu's work in IoT and other fields can be accessed on his GitHub account with the name shantanubhadoria. He is also the author of Device::SMBus, a popular Perl library used to control devices over the I2C bus.

See other products by Bhadoria

Ruben Oliva Ramos

Ruben Oliva Ramos

Ruben Oliva Ramos is a computer systems engineer from Tecnologico de Leon Institute, with a master's degree in computer and electronic systems engineering and a specialization in teleinformatics and networking from the University of Salle Bajio in Leon, Guanajuato, Mexico. He has more than 5 years of experience of developing web applications to control and monitor devices connected with Arduino and Raspberry Pi, using web frameworks and cloud services to build the Internet of Things applications. He is a mechatronics teacher at the University of Salle Bajio and teaches students of the master's degree in design and engineering of mechatronics systems. Ruben also works at Centro de Bachillerato Tecnologico Industrial 225 teaching subjects such as electronics, robotics and control, automation, and microcontrollers. He is a consultant and developer for projects in areas such as monitoring systems and datalogger data using technologies (such as Android, iOS, HTML5, and ASP.NET), databases (such as SQlite, MongoDB, and MySQL), web servers, hardware programming, and control and monitor systems for data acquisition and programming.

See other products by Ruben Oliva Ramos

Other recommended products

Related to this chapter

Internet of Things Programming with JavaScript

Internet of Things Programming with JavaScript

This book is for developers who?d like to learn how to set up an IoT system and communicate with connected devices in JavaScript. Both advanced and entry-level developers will find everything they need to explore the potential of JavaScript for IoT programming.

Feb 2017 9h 56m

Building Bluetooth Low Energy Systems

Building Bluetooth Low Energy Systems

Technology is expanding and so are our networks. The coming era is the age of the Internet of Things and it requires a seamless integration of software with hardware. The need for power-efficient connectivity is greater than ever. Bluetooth Low Energy presents a low-cost, small-distance communication platform that completely solves this problem. This book will introduce you to the technical aspects and implementation of BLE, which will enable you to create customized Bluetooth Low Energy Systems for day-to-day use.

Intelligent IoT Projects in 7 Days

Intelligent IoT Projects in 7 Days

Internet of Things (IoT) is a ground-breaking technology that involves connecting numerous physical devices to the Internet and controlling them. Analyzing data from Internet of Things devices and converting it into something meaningful is currently driving the next level of IoT learning.

Sep 2017 6h 52m

Arduino for Kids

Arduino for Kids

Arduino is an open-source electronics prototyping platform based on flexible, easy-to-use hardware and software. It's intended for artists, designers, hobbyists, and anyone interested in creating interactive objects or environments.

Mar 2017 7h 16m

Azure IoT Development Cookbook

Azure IoT Development Cookbook

It is important to develop robust and reliable solutions for your organization to leverage IoT services. Microsoft's end-to-end IoT platform is the most complete IoT offering. It empowers enterprises to build and realize value from their IoT solutions for innovative business outcomes with Microsoft Azure IoT. This book will teach you how to connect multiple devices to the Azure IoT hub, develop, manage the IoT hub service, and integrate the hub with the cloud.

Aug 2017 8h 28m

ESP8266 Robotics Projects

ESP8266 Robotics Projects

The ESP8266 WiFi module is a self-contained SOC with integrated TCP/IP protocol stack that can give any microcontroller access to your WiFi network. This book is all about robotics projects based on the original ESP8266 microcontroller board and some variants of ESP8266 boards. You will learn how to use a different type of chassis kits, motors, motor drivers, power supplies and distribution boards, sensors, and actuators to build the robotics projects that can be controlled via WiFi. In addition to it, you will understand how to use line sensors, ArduiCam, Wii Remote, Wheel encoders, and Gripper kit to build more specialized robots.

DIY Microcontroller Projects for Hobbyists

DIY Microcontroller Projects for Hobbyists

This book is a project-based introduction if you're new to electronics, microcontroller boards, and C and C++ programming that will have you quickly building practical and real-world projects. Throughout the book, you'll discover how to connect easy-to-use sensors and displays to microcontroller boards and learn how to test them.

Jul 2021 10h 40m

ESP8266 Internet of Things Cookbook

ESP8266 Internet of Things Cookbook

The ESP8266 Wi-Fi Module is a self contained System on Chip (SOC) with an integrated TCP/IP protocol stack and can give any microcontroller access to your Wi-Fi network. It is capable of either hosting an application or offloading all Wi-Fi networking functions from another application processor.

Apr 2017 8h 56m

Learning AWS IoT

Learning AWS IoT

The Internet of Things market increased a lot in the past few years and IoT development and its adoption have showed an upward trend. Analysis and predictions say that Enterprise IoT platforms are the future of IoT. This book will help you get up-and-running with the AWS IoT Suite, which will be helpful in building IoT Projects.

Jan 2018 9h 16m

Learn Arduino Prototyping in 10 days

Learn Arduino Prototyping in 10 days

The Arduino platform is well-known for creating innovative micro-controller-based devices starting from a simple digital clock to a sophisticated drone. This book will teach you to prototype standalone and wireless devices through various hands-on projects.

Jun 2017 9h 36m

Wearable-Tech Projects with the Raspberry Pi Zero

Wearable-Tech Projects with the Raspberry Pi Zero

Are you interested in wearable-tech and gadgets? Do you want to know more about how you can use the Raspberry Pi Zero computer? This book has a series of projects which will show you some of the possibilities with wearable-tech and the Pi Zero, guiding you through each one from start to finish. The Raspberry Pi Zero is a revolutionary product, designed and manufactured in the United Kingdom by the Raspberry Pi Foundation. This tiny computer provides powerful features, in spite of being such a small size; it measures a mere 65 x 35 mm! One of the advantages of its tiny size is that it is ideal to be used in wearable-tech projects.

Mastering Arduino

Mastering Arduino

Mastering Arduino is a practical, no-nonsense guide teaching you the electronics and programming skills that you need to create advanced Arduino projects. It is packed full of real-world projects leading up to the final project where you will build and control a basic robot.

Sep 2018 12h 24m

Personalised recommendations for you

Based on your interests and search pattern

Mastering Embedded Linux Development

Mastering Embedded Linux Development

This comprehensive guide is aimed at those who want to take the leap from low-power microcontrollers to high-speed system-on-chips that can efficiently run Linux. Look no further, this book has everything you need to start your journey.

May 2025 23h 40m

The Embedded Linux Security Handbook

The Embedded Linux Security Handbook

This book will guide you through every step of the development process, from design to building, testing, validation, and ultimately supporting the appliance's lifecycle to strengthen the security of your embedded Linux systems.

Apr 2025 9h 16m