Database Archives - Page 11 of 18

Soft Delete Pattern in Database: Safe Record Deletion, Recovery, and Index Optimization with PostgreSQL and MySQL

May 21, 2026

Soft delete pattern lets you mark records as deleted instead of physically removing them — enabling safe recovery, audit trails, and GDPR-compliant data retention. This guide covers practical implementation in PostgreSQL and MySQL, including partial indexes, unique constraint handling, and cleanup strategies.

Database

Optimistic Locking vs Pessimistic Locking: Handling Concurrent Database Access in Real Applications

May 20, 2026

After six months of handling race conditions in a production e-commerce app, here's a practical breakdown of optimistic vs pessimistic locking — when to use each, the real trade-offs, and working Python/PostgreSQL code you can drop into your project.

Database

Database Testing with pgTAP in PostgreSQL: A Guide to Unit Testing Functions, Triggers, and Schema

May 20, 2026

Learn how to use pgTAP to write native unit tests for PostgreSQL. This guide covers testing database schema, functions, and triggers to ensure your data logic remains robust and bug-free.

Database

Defeating Cache Penetration: Why I Switched to Redis Bloom and Cuckoo Filters

May 18, 2026

Is your database crashing from cache misses? Discover how Redis Bloom and Cuckoo Filters can block bot attacks and save your backend from Cache Penetration.

Database

PostgreSQL Bulk Imports: How to Move Millions of Rows Without the Wait

May 17, 2026

Tired of slow database migrations? Learn how to use the COPY command, multi-row inserts, and WAL tuning to import millions of records into PostgreSQL in minutes.

Database

MySQL on Fire: Rescuing Production with Percona Toolkit

May 17, 2026

Database meltdowns don't have to be disasters. Learn how to use Percona Toolkit to identify slow queries, change schemas without downtime, and fix replication drift in high-load MySQL environments.

Database

MySQL Schema Migrations at Scale: A Deep Dive into gh-ost

May 17, 2026

Schema migrations on large MySQL tables don't have to cause downtime. This guide explores the triggerless approach of gh-ost, comparing it with native DDL and pt-osc while providing a step-by-step migration workflow.

Database

MySQL Sharding at Scale: A Practical Guide to Vitess on Kubernetes

May 16, 2026

Scaling MySQL horizontally doesn't have to be a nightmare. This hands-on guide walks you through sharding your database using Vitess on Kubernetes, from setup to VSchema configuration.

Database

Beyond Lat/Lon: A Pro Guide to Mastering PostGIS on PostgreSQL

May 16, 2026

Learn how to move beyond basic latitude and longitude storage. This guide covers PostGIS installation, GEOGRAPHY vs GEOMETRY types, and how GIST indexing can make your spatial queries 100x faster.

Database

Zero-Downtime Database Upgrades: A Survival Guide to Blue-Green Deployment

May 16, 2026

Forget the 2 AM panic. I walk through how to use Blue-Green deployment and logical replication to upgrade PostgreSQL and MySQL with zero downtime and total control.