Our great sponsors
-
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
PostgreSQL
Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch
-
Bootstrap
The most popular HTML, CSS, and JavaScript framework for developing responsive, mobile first projects on the web.
All the code used in this tutorial is available as a GitHub repository. You can clone that if you want to start from the end product instead of building each step.
We'll be using SQLAlchemy, which is an ORM that hides a lot of SQL logic. If you've run some SQL statements before, it might be easier to understand what's happening under the hood. 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.
We want to remember our users' input, so we'll want to be able to add items to a database. We'll use the popular SQLite database, which comes bundled with the standard installation of Python. It is a file-based database, so we can store our data in a file on our file system, without needing to install a huge Relational Database Management System (RDBMS). We'll use SQLite through SQLAlchemy, which provides a higher level abstraction. This means that we could easily use a different database, such as PostgreSQL or MariaDB, and we wouldn't need to change our codebase. SQLAlchemy also allows us to do database level operations in a more Pythonic way.
Make the application more aesthetically pleasing by adding some CSS, either custom CSS or through a framework like Bootstrap.