Book Image

Raspberry Pi Computer Architecture Essentials

By : Andrew K. Dennis, Teemu O Pohjanlehto
Book Image

Raspberry Pi Computer Architecture Essentials

By: Andrew K. Dennis, Teemu O Pohjanlehto

Overview of this book

With the release of the Raspberry Pi 2, a new series of the popular compact computer is available for you to build cheap, exciting projects and learn about programming. In this book, we explore Raspberry Pi 2’s hardware through a number of projects in a variety of programming languages. We will start by exploring the various hardware components in detail, which will provide a base for the programming projects and guide you through setting up the tools for Assembler, C/C++, and Python. We will then learn how to write multi-threaded applications and Raspberry Pi 2’s multi-core processor. Moving on, you’ll get hands on by expanding the storage options of the Raspberry Pi beyond the SD card and interacting with the graphics hardware. Furthermore, you will be introduced to the basics of sound programming while expanding upon your knowledge of Python to build a web server. Finally, you will learn to interact with the third-party microcontrollers. From writing your first Assembly Language application to programming graphics, this title guides you through the essentials.
Table of Contents (18 chapters)
Raspberry Pi Computer Architecture Essentials
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface
Index

Building a Flask-based website


You will be familiar with the basics of Flask from Chapter 9, Building a Web Server. Once again, we will be using this framework to create a website that can interact with a database.

You can always refer to the Flask documentation site if you find a feature you wish to learn more about: http://flask.pocoo.org/docs/0.10/

Our project will involve creating a number of web forms that can update our SQLite database with information on what items are stocked in our inventory.

First, we need to create a database to store our inventory data in.

Adding a database

In our previous SQL example, we logged in to SQLite to create the database. We can in fact write our SQL in a separate file and dump this into SQLite. This makes managing our source code a lot easier, and we can also re-run it against an empty database whenever we wish.

So we will therefore take our existing data model from Chapter 9, Building a Web Server and convert it into an SQL file. We will also include the...