Book Image

Full Stack Web Development with Raspberry Pi 3

By : Soham Kamani
Book Image

Full Stack Web Development with Raspberry Pi 3

By: Soham Kamani

Overview of this book

Modern web technology and portable computing together have enabled huge advances in the Internet of Things (IoT) space,as well as in areas such as machine learning and big data. The Raspberry Pi is a very popular portable computer for running full stack web applications. This book will empower you to master this rapidly evolving technology to develop complex web applications and interfaces. This book starts by familiarizing you with the various components that make up the web development stack and that will integrate into your Raspberry Pi-powered web applications. It also introduces the Raspberry Pi computer and teach you how to get up and running with a brand new one. Next, this book introduces you to the different kinds of sensor you’ll use to make your applications; using these skills, you will be able to create full stack web applications and make them available to users via a web interface. Later, this book will also teach you how to build interactive web applications using JavaScript and HTML5 for the visual representation of sensor data. Finally, this book will teach you how to use a SQLite database to store and retrieve sensor data from multiple Raspberry Pi computers. By the end of this book you will be able to create complex full stack web applications on the Raspberry Pi 3 and will have improved your application’s performance and usability.
Table of Contents (13 chapters)
2
Getting Up-and-Running with Web Development on the Raspberry Pi

Running CRUD operations

CRUD is short for Create, Read, Update, Delete, which are the four essential operations that are run on any database.

Now that we have created tables to hold our temperature and humidity readings, let's run some basic operations on them to get the hang of SQLite and the SQL syntax.

For the purpose of this chapter, only the temperature table will be used, but the commands can be easily translated to be used on the humidity table as well.

Create

We start by inserting a dummy value into our temperature table:

    INSERT INTO temperature VALUES (datetime('now'), 16.7);

This is standard SQL syntax, where we direct SQLite to insert the current datetime and dummy value of 16.7 into our temperature...