SQLAlchemy 2 In Practice - Solutions to the Exercises
Solutions to SQLAlchemy 2 exercises covering database queries, relationships, and async features.
Miguel Grinberg is a software engineer and Python expert known for in-depth articles on Flask, web security, Python performance, and backend development. He shares practical tutorials, benchmarks, and insights drawn from real-world open-source and framework work.
23 articles from this blog
Solutions to SQLAlchemy 2 exercises covering database queries, relationships, and async features.
Final chapter of SQLAlchemy 2 in Practice book covering integration with Flask and FastAPI for web applications.
Learn how to use SQLAlchemy 2 with asynchronous programming using asyncio for modern web applications like FastAPI.
Explains how Bitwarden and Vaultwarden encrypt and decrypt secrets using a master key and user passphrase, with Python code examples.
Building a web traffic analytics solution with SQLAlchemy 2, covering blog articles and authors database models.
Advanced many-to-many relationships in SQLAlchemy 2, covering join tables with extra columns and order management.
Tutorial on implementing many-to-many relationships in SQLAlchemy 2, using products and countries as an example.
Tutorial on eliminating data duplication in SQLAlchemy 2 using one-to-many relationships in relational databases.
Learn how to create, update, and query database tables using SQLAlchemy 2, covering Core and ORM modules.
First chapter of a hands-on book on SQLAlchemy 2, guiding readers through initial Python project and database setup.
Author introduces his book 'SQLAlchemy 2 In Practice', sharing the preface and outlining chapters on the popular Python ORM.
A technical guide on setting up a self-hosted email server for sending transactional emails, covering DNS, Postfix, and authentication.
Discusses the discovery of LLM-generated commits in the CPython repository and the implications for open-source development.
A guide to performing date and time arithmetic in bash scripts, covering numerical expressions and practical use cases like backup rotation.
A tutorial on adding a free, interactive map to any website using the Leaflet library and OpenStreetMap in three simple steps.
An independent analysis of the Flask web framework's activity in 2025, showing a decline in releases and merged pull requests.
Exploring a modern, tokenless approach to CSRF protection using the Sec-Fetch-Site header in web frameworks.
A guide on protecting API keys and secrets from malware by avoiding environment variables and using a password manager with CLI integration.
Benchmark results comparing the performance of Python 3.14 against older Python versions, PyPy, Node.js, and Rust on pure Python code.
A developer benchmarks MicroPython performance on various microcontrollers, comparing them to a Raspberry Pi 4 and a laptop.