The first iteration of our script focuses on performing the task at hand with a standard module, sqlite3
, in a more manual fashion. This entails writing out each SQL statement and executing them as if you were working with the database itself. Although this is not a very Pythonic manner of handling a database, it demonstrates the methods used to interact with a database with Python. Our second iteration employs two third-party libraries: peewee
and jinja2
.
Peewee is an object-relational mapper (ORM), which is a term used to describe a software suite that uses objects to handle database operations. In short, this ORM allows the developer to call functions and define classes in Python, which interprets them into database commands. Peewee is a light ORM, as it is a single Python file that supports PostgreSQL, MySQL, and Sqlite3 database connections. Because the framework API is uniform across the database types, few modifications are required to change the database backend...