Tech Articles
Curated developer articles, tutorials, and guides – auto-updated hourly
晖莫2d ago • 3 min read
SELECT * and INSERT ... SELECT Broke Production at 3am
A backfill migration used SELECT * and INSERT ... SELECT, so a column added six months later silentl...
#sql#migrations#ci#postgres
0 0
Bolvrk.com3d ago • 4 min read
One line stops a migration from taking down production. Almost nobody adds it.
A single idle transaction, one ALTER TABLE queued behind it, and every read on the table queued behi...
#postgres#locks#migrations#incidents
5 0
Bolvrk.com3d ago • 3 min read
Why SQLite refuses your ALTER TABLE, and the twelve-step rebuild it wants instead
SQLite supports a fraction of ALTER TABLE and fails the rest at run time, in every environment. What...
#sqlite#migrations
5 0
Bolvrk.com3d ago • 4 min read
What 40 agent-written migrations got wrong
We asked a coding agent for forty ordinary Postgres migrations and ran the free rule set over the re...
#aiworkflows#postgres#migrations#data
5 0
Bolvrk.com3d ago • 4 min read
Deterministic checks for AI-written migrations
Coding agents write database migrations quickly and confidently, and the mistakes they make are the ...
#aiworkflows#postgres#migrations
5 0
Bolvrk.com3d ago • 4 min read
How a database password ends up in git history, and why rotating it is not enough
The four ways a credential gets into a migration file, what happens to it after the commit, and why ...
#credentials#security#migrations#aiworkflows
5 0
Bolvrk.com3d ago • 3 min read
Why ADD COLUMN NOT NULL fails on a full table, and the migration that does not
The most searched migration error in Postgres, what actually happens inside the server when it runs,...
#postgres#migrations#notnull
5 0
Nainik Mehta1d ago • 4 min read
Migration Canary: Continuous Verification for Schemas
Why a migration canary matters Schema changes used to be a single-team problem: run a...
#devops#sre#migrations#database
0 2
Bolvrk.com3d ago • 4 min read
Expand, migrate, contract: dropping a column without breaking the deploy that is still running
A column drop is safe in the schema and fatal in the running code. The two-release pattern that sepa...
#postgres#migrations#deploys#zerodowntime
5 0
Bolvrk.com3d ago • 3 min read
Adding a foreign key to a big table without locking both of them
A plain ADD CONSTRAINT ... FOREIGN KEY validates every row while holding locks on the child and the ...
#postgres#migrations#foreignkeys#locks
5 0
Bolvrk.com3d ago • 4 min read
Vibe coding without being reckless
Letting the model drive is fine. Letting it drive into production without a gate is not. A short, pr...
#aiworkflows#vibecoding#migrations#credentials
5 1
![Single File Web App SQLite [2026]: Migrations + Backups That Work](https://media2.dev.to/dynamic/image/width=1200,height=627,fit=cover,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F4jmdyz7soiorgz5fzwo2.png)
Kunal4d ago • 13 min read
Single File Web App SQLite [2026]: Migrations + Backups That Work
“One binary + one database file” is a great deployment model until you hit migrations under load and...
#sqlite#deployment#webarchitecture#migrations
0 0