Hands-On Docker for Microservices with Python

Working with SQLAlchemy

SQLAlchemy (https://www.sqlalchemy.org/) is a powerful Python module to work with SQL databases. There are two approaches to dealing with databases with a high-level language such as Python. One is keeping the low-level approach and doing raw SQL statements, retrieving the data as it is in the database. The other is to abstract the database using an Object-Relational Mapper (ORM) and use the interface without getting into the details of how it is implemented.

The first approach is well represented by the Python database API specification (PEP 249—https://www.python.org/dev/peps/pep-0249/), which is followed by all major databases, such as psycopg2 (http://initd.org/psycopg/) for PostgreSQL. This mainly creates SQL ...