Skip to Content
Raspberry Pi 3 Cookbook for Python Programmers - Third Edition
book

Raspberry Pi 3 Cookbook for Python Programmers - Third Edition

by Steven Lawrence Fernandes, Tim Cox
April 2018
Beginner content levelBeginner
552 pages
13h 58m
English
Packt Publishing
Content preview from Raspberry Pi 3 Cookbook for Python Programmers - Third Edition

Getting ready

To capture data in our database, we will install SQLite so that it is ready to be used with Python's sqlite3 built-in module. Use the following command to install SQLite:

sudo apt-get install sqlite3  

Next, we will perform some basic operations with SQLite to see how to use SQL queries.

Run SQLite directly, creating a new test.db database file with the following command:

sqlite3 test.db
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>  

This will open an SQLite console, within which we enter SQL commands directly. For example, the following commands will create a new table, add some data, display the content, and then remove the table:

CREATE TABLE mytable ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Raspberry Pi for Python Programmers Cookbook - Second Edition

Raspberry Pi for Python Programmers Cookbook - Second Edition

Tim Cox

Publisher Resources

ISBN: 9781788629874Supplemental Content