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. Be able to quickly build web applications using Python and Flask.Know how databases work and how to integrate these into your web app.Understand what a web application is and how to build one.We will therefore keep the example application as simple as possible, so that you can focus on the tools themselves instead of application-specific details.Īfter going through this tutorial, you'll: However, once you can write a basic web application that takes user input and stores this in a database, you are well on your way to writing any web application that you can imagine.

The application that we build here is not intended to be useful on its own. We'll use SQLAlchemy in conjunction with SQLite to store information about books. In this tutorial, we'll walk through building a minimal web application using Flask.

Flask app builder no such column