

Specifically, we'll build an application that allows users to create book titles by entering them as text, read all the book titles entered, update the titles, and delete them.

We'll build a very basic book database in this tutorial. You can clone that if you want to start from the end product instead of building each step.

If you want to learn more about the relation between SQL and SQLAlchemy, you can see my tutorial specifically on that over at Compose.io.Īll the code used in this tutorial is available as a GitHub repository. If you've run some SQL statements before, it might be easier to understand what's happening under the hood. We'll be using SQLAlchemy, which is an ORM that hides a lot of SQL logic. You can find detailed instructions on how to setup Python for different operating systems over at this Django Girls Tutorial. You need to have Python 3 installed on your computer and be able to install Python libraries through the Python package manager, pip. It'll also be helpful if you've used HTML before, or at least know what it is. We'll be explaining each step of this tutorial in detail, but you'll find it easier to follow along if you've coded in Python before.

