Build a Programming Journal with Python and SQLite

In this section we'll be building a command-line app with Python that lets us write a post every day to keep track of what we've learned.

Through this we'll learn the fundamental required knowledge of Relational Databases and the Structured Query Language (SQL).

We'll be using SQLite, a lightweight Relational Database Management System (RDBMS). SQLite can do most of the things PostgreSQL (another RDBMS) can do, but is much simpler to get started with as it doesn't require installation and initial set-up.

We'll begin the section by getting a SQLite reader--a program that allows us to interact with SQLite databases. Then we'll go through the main bits of SQL syntax, such as how to create tables, insert, find, and delete data, and more. While we do this, we'll be writing Python code that executes our queries.

By the end of this section you'll be confident with relational databases, with SQL syntax, and you'll be able to interact with a database in order to effectively store and retrieve data.