Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Raspberry Pi Computer Architecture Essentials
  • Table Of Contents Toc
  • Feedback & Rating feedback
Raspberry Pi Computer Architecture Essentials

Raspberry Pi Computer Architecture Essentials

By : Andrew K. Dennis, Teemu O Pohjanlehto
4.5 (2)
close
close
Raspberry Pi Computer Architecture Essentials

Raspberry Pi Computer Architecture Essentials

4.5 (2)
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 (13 chapters)
close
close
12
Index

Adding database support

Rather than having simple static pages like our hello world page, we can display text stored in a database. This allows us to have a page that dynamically updates, depending on the data we have stored.

SQLite

We are going to use a lightweight relational database management system called SQLite to demonstrate how our web server can display content stored in a database. We will use SQLite version 3 for this project.

SQLite version 3 can be installed via the following command:

sudo apt-get install sqlite3

Once installed, you can create a new database by simply specifying a file name after the call to the SQLite shell program:

sqlite3 webserverdb.db

With SQLite 3, every database is simply a file on the system, so go ahead and run the preceding command. This will now drop you into the SQLite shell. From here, we can use SQL to create a database and populate it with dummy data.

Let's quickly look at some SQL features in order to aid us.

SQL – a quick overview

SQL stands...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Raspberry Pi Computer Architecture Essentials
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon