Django select_related vs prefetch_related: The Visual Guide I realized I'd never actually seen anyone explain the django select_related and prefetch_related difference visually - showing what SQL each one produces, what data flows where, and why picking the wrong one doesn't just fail to help but can actually make things worse. So I drew it on a whiteboard. That whiteboard sketch eventually became this article. Django Databases
Database Indexing: The Performance Trick Nobody Explained Properly Your queries are slow because you don’t understand indexes. Let’s fix that in 15 minutes. Databases
Django select_related and prefetch_related Complete Guide This article will reveal advanced techniques for optimizing database queries, specifically on Django, and their impact on query performance. Django Databases
Django’s select_related Didn’t Fix My N+1 Queries Wrong optimization makes queries worse Django Databases
Monitor PostgreSQL Database Performance Simple parameters to check for optimal performance and reliability Monitoring
Relational Databases Explained How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases. Architecture Databases
Raw SQL vs Query Builder vs ORM After reading this article, you will know when to use raw SQL, a query builder and an ORM. You will also know how to use each of them in Python. All of the code in this article is runnable. You just need to initialize the database and add environment variables. Python Development Databases
