MySQL "Table Doesn't Exist" After Migration
Getting a "table doesn't exist" error right after running a migration that supposedly created that exact table almost always means the migration either didn't...
Search
125 results for "Migration"
Password Hashing Algorithm Selection and Work Factor Tuning
Store passwords with a slow, salted, purpose-built hashing algorithm, not a fast general hash. Argon2id is the usual first choice for new systems, with scrypt,...
MySQL Online Schema Changes Without Locking Large Tables
Many schema changes on large MySQL tables can run online with InnoDB's native online DDL, using ALGORITHM=INPLACE or INSTANT and an explicit LOCK clause so the...
Python Gradual Typing Strategy for Large Codebases
The way to adopt type hints in a large Python codebase is gradually: run a type checker in a permissive mode, annotate the code that matters most first, and...
Git Revert vs Reset for Shared Production Branches
Revert records a new commit that undoes a change, while reset moves a branch reference. Start with a clearly defined correctness invariant and workload....
Go database sql Connection Pool Tuning for Gin APIs
Go's database/sql package manages a connection pool for you, and its default settings are rarely right for a production API. Set a maximum number of open...
PostgreSQL Advisory Locks vs SELECT FOR UPDATE for Job Queues
For a job queue in PostgreSQL, SELECT FOR UPDATE SKIP LOCKED inside a transaction is usually the simplest and safest way to let many workers claim jobs without...
PostgreSQL Table Partitioning by Time for Large Event Tables
Partitioning a large PostgreSQL event table by time splits it into smaller child tables, usually one per day or month. The main benefits are fast data...
PostgreSQL Concurrent Index Creation and Deployment Safety
CREATE INDEX CONCURRENTLY reduces blocking of ordinary writes, but has special transaction and cleanup constraints. Begin with an invariant that the service...