database 41
- The callback that quietly doubled our database
- Zombie PostgreSQL replicas: the WAL segment removed deadlock
- Why pg_dump backups on a PostgreSQL replica fail intermittently
- Postgres conflict with recovery: why replicas cancel queries
- Redis High Availability: Shared Sessions and Fault Tolerance
- Polymorphic Indexes in MySQL: Type-First or ID-First?
- Zero-downtime GKE upgrades with PostgreSQL failover
- Transactions, touch, and async rollups for derived data in Rails
- PostgreSQL on Ubuntu: install, user setup, and auth debugging
- load_async in Rails 8: loading associations concurrently
- PostgreSQL MD5 to SCRAM-SHA-256: a zero-downtime migration
- PostgreSQL 18: What's New and How to Upgrade
- Designing a Schema for an Optional Attribute
- Managing Temporary Data in Multi-Step Rails Forms
- PostgreSQL JSONB vs Linking Tables for Relationships
- MySQL vs PostgreSQL: Foreign Key Deadlock Contention
- Idempotent Rails Requests with a Redis Semaphore Lock
- Redis Sentinel Split-Brain: Fixing It on Kubernetes
- Avoiding Duplicate Record Errors in Rails Under Concurrency
- Handling Out-of-Order Updates in Async Rails Workflows
- Deadlocks in MySQL and PostgreSQL: Foreign Keys vs Performance
- Catching Database Configuration Drift Between Microservices
- API Design for Time Slot Replacement in Booking Systems
- Kubernetes Node Upgrades: Cordon, Drain, and Failover
- Ordering by an Associated Column Without Breaking includes
- N+1 Queries in Rails: What Silently Breaks `includes`
- Laravel Model: `save()` vs. `saveOrFail()`
- Common MySQL Commands: Databases, Users, and Grants
- Materialized Views: Speeding Up Queries with a Tradeoff
- PostgreSQL Sequence Conflicts After an Upgrade: How to Fix Them
- Speeding Up Nested JSON Serialization in Rails
- delete_all vs destroy_all in Rails: Callbacks and Associations
- Zero-Downtime PostgreSQL Upgrades With Logical Replication
- Redis Sentinel: How Automatic Failover Actually Works
- Rails N+1 Queries: joins vs preload vs eager_load vs includes
- Fragment Caching a Large List That Changes Constantly
- Scaling PostgreSQL on Kubernetes with Kubegres
- Shared Databases Between Microservices Are a Code Smell
- Soft Delete in Rails: Discard vs ActsAsParanoid
- Rails unscope: removing default scope conditions
- Database Auditing: pg_audit vs audited vs paper_trail