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
PostgreSQL Connection Pooling: Django Native Pools and PgBouncer Optimizing the Most Critical Connection in Your Stack 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
Django’s @atomic Decorator Didn’t Prevent My Race Condition The insane reality where wrapping everything in @transaction.atomic still allows two users to book the same seat, and “all or nothing” doesn’t mean “one at a time.” Django Databases
How show raw SQL queries for your django queries or querysets Django ORM makes querying the database easier. But how to know what is happening behind the scenes or what SQL query is executed for certain django query. Here are some ways that might be useful to know that. Django Databases
Relational Databases Explained How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases. Architecture Databases
Database Sharding Explained More features, active users, and data are collected daily. Your database is slowing your application. Many people don't understand database sharding, which could solve their difficulties. This article explains database sharding, its benefits, including how to use it and when not to. Architecture Databases
Better SQLAlchemy In this article, I will dive into the world of SQLAlchemy, uncovering the best practices for optimizing database interactions in Python applications. From designing efficient data models to managing transactions, I will guide you through a range of techniques that will help you build scalable and high-performing applications. Python Databases Development
Database integration tests with Pytest, SQLAlchemy and Factory Boy with Faker In this little example, I’m going to show a possible procedure to easily test your piece of code that interacts with a database. Python Development Databases
How to delete or remove a MySQL/MariaDB user account on Linux/Unix In this quick tutorial, you will learn how to delete ore remove user account in MySQL or MariaDB database on Linux or Unix-like system. Databases
