This is the story of using SQL and NoSQL in the same project without creating a tangled mess. We'll explore how the Repository Pattern provides one menu for our two database baristas PostgreSQL and MongoDB, resulting in a clean architecture.

Learn how to use SQLAlchemy ORM Events to automate tasks like password hashing, sending emails, and updating timestamps. This guide covers Mapper, Session, and Attribute events with practical examples to write cleaner, more maintainable backend code.

A comprehensive guide for Python developers on scaling PostgreSQL with sharding. Learn the fundamentals, how to choose a shard key, and see practical, application-level sharding examples using SQLAlchemy to effectively manage massive data growth.

Database queries slowing down? Tame your monolithic tables with PostgreSQL Partitioning! A practical guide for Python & SQLAlchemy developers. We break down how to partition large tables using an e-commerce example and automate maintenance.

Learn how to create powerful, expressive data models through practical e-commerce examples, from basic implementations to advanced query patterns.