miguelgrinberg-com

This article provides solutions to all exercises from the SQLAlchemy 2 in Practice book by Miguel Grinberg, encouraging readers to purchase the book for full support.

SQLAlchemy is recommended as a database solution for Python web applications. This chapter demonstrates integrating SQLAlchemy with Flask and FastAPI, two popular Python web frameworks, serving as examples for use with other frameworks as well.

This chapter covers asynchronous programming support in SQLAlchemy 2 using the asyncio package, available for both Core and ORM modules since version 1.4, enabling SQLAlchemy to be used in modern applications like those built with FastAPI.

The article explains how Bitwarden and its self-hosted clone Vaultwarden encrypt and decrypt secrets stored in a SQLite database. The author explores rolling their own secret management tooling and provides working Python code for decryption, partly motivated by a recent supply chain attack on the official Bitwarden CLI client.

Chapter 6 of the SQLAlchemy 2 In Practice book guides readers through building a web traffic analytics solution, using concepts from previous chapters to create a realistic, complex database design.

The article discusses date arithmetic in bash scripts, noting that many programming languages have notoriously problematic date and time libraries. It aims to help readers learn how to perform date calculations in bash while warning about potential challenges.

Miguel Grinberg is moving his paid courses site to a new platform at learn.miguelgrinberg.com. The article provides instructions for existing customers on how to transfer their accounts to the new site.

A social media trick shows that blocking the "claude" user on GitHub reveals projects using Claude Code. The CPython repository, one of the world's most popular open-source projects, now displays contributions from this AI coding agent.

The author explains how they set up their own email server for their new platform instead of using paid services like Mailgun or SendGrid. They describe the process of configuring email sending and receiving capabilities that are accepted by major email providers.

The author is publishing his 2023 book "SQLAlchemy 2 In Practice" for free on his blog, starting with the preface. He will release all eight chapters over the coming weeks, though the book is also available for purchase in electronic or paper formats.

This first chapter of the SQLAlchemy 2 in Practice book focuses on setting up a database system to run examples and exercises. It provides practical guidance for working with relational databases in Python applications.

This chapter covers the fundamental usage of SQLAlchemy for creating, updating, and querying database tables. It is part of the "SQLAlchemy 2 in Practice" book series.

This chapter covers one-to-many relationships in SQLAlchemy 2, building on previous query techniques. It addresses how to handle product manufacturers without requiring duplicate removal through grouping.

This chapter covers many-to-many relationships in SQLAlchemy 2, explaining how to handle database connections where neither side can be identified as a "one" side. It continues the discussion of relationships from previous chapters in the SQLAlchemy 2 in Practice book.

This chapter explores advanced variations of many-to-many relationships in SQLAlchemy 2, building upon fundamental database design concepts. It demonstrates how to adapt basic relationship patterns to achieve specific goals in database modeling.