Tech Articles
Curated developer articles, tutorials, and guides – auto-updated hourly
Matty Stratton2d ago • 11 min read
The Past Keeps Changing
Apple Health revises days after they have closed, and 69% of the values my pipeline has watched land...
#postgres#database#sql#programming
3 0
Matty Stratton2d ago • 9 min read
Every Number I Didn't Measure Was Wrong
Five claims I wrote into a schema, a README and a set of docs without ever checking them against the...
#programming#testing#postgres#devjournal
2 0
Igor Potapenko11h ago • 5 min read
Your idempotency test probably cannot fail
My test for "do not announce the same payment twice" passed. Production sent two identical messages ...
#testing#webdev#postgres#node
6 1
conchaestradamiguelangel-droid6d ago • 2 min read
We found a bug that let our test suite write to production. Here's what we did about it.
Five days ago we opened Ekurhive — our trust network for AI agents — to outside nodes. This week,...
#ai#postgres#testing#security
0 2
Jakub Andrzejewski2d ago • 6 min read
Supabase in Vue Made Simple
Supabase has become one of the most popular choices for building modern web applications. It gives....
#vue#postgres#typescript#javascript
8 0
uninterrupted5d ago • 7 min read
Postgres LISTEN/NOTIFY in Production: Safe Reconnects & SSE
If your app needs to push live updates to connected clients — a job progress bar, a balance that...
#postgres
1 1
nicolas.vbgh6d ago • 12 min read
Faster Bulk Inserts in PostgreSQL
Two tables. band, and song pointing at it with a foreign key. Four tracks to an EP, twenty million.....
#postgres#database#performance#python
1 2
Subham3d ago • 8 min read
Dissecting Databases: CockroachDB Has Almost Every Postgres Feature - So Why Is It the Default Answer for Distributed SQL?
The Question Nobody Asks Out Loud Open CockroachDB's docs and the first thing you notice...
#cockroachdb#postgres#distributedsystems#database
1 0
Franck Pachot3d ago • 7 min read
OrioleDB Multi-Version Concurrency Control
MVCC not only tracks row history but also records the search-key space. To better understand...
#postgres#sql#database#orioledb
0 0
Anand Rathnas23h ago • 5 min read
DigitalOcean Postgres Has a Firewall Trap. We Walked Right Into It.
Adding a single trusted-source rule to a previously-open DO managed Postgres flips the entire DB int...
#digitalocean#postgres#devops#debugging
1 0
Son Tran5d ago • 11 min read
Schema Linting vs Migration Linting: Which Database Problems Each One Can See
Migration linters read the statement you are about to run. Schemity's schema lint reads the model yo...
#database#sql#postgres#architecture
0 0
Igor Potapenko5d ago • 6 min read
Five bugs AI wrote for me that never threw an error
None of them crashed. None of them showed up in the logs. Three of them were invisible in code revie...
#ai#webdev#testing#postgres
0 0
fr_trenton023d ago • 6 min read
Rebuilding the Cerebras Knowledge Base: adding hybrid search
Part 2: full-text search plus reciprocal-rank fusion. On this corpus, hybrid retrieval regressed aga...
#rag#vectordatabase#postgres#ai
0 0
libersand2d ago • 4 min read
A Postgres driver silently shifted my timestamps by 8 hours — and every test stayed green
A chunk of the timestamp columns in my database were quietly wrong. Not corrupted. Not null. Just —...
#postgres#node#typescript#webdev
0 0
André Wenceslau1d ago • 8 min read
Postgres RLS multi-tenancy: two leaks that survive correct policies
I wrote an earlier post about two traps that silently switch Postgres row level security...
#postgres#database#security#webdev
0 2
Sahib Alizada5d ago • 8 min read
Visual Search on pgvector + Gemini: Detect, Crop, Embed, Rank (and the Averaging Bug That Broke Exact Match)
Visual Search on pgvector + Gemini: Detect, Crop, Embed, Rank (and the Averaging Bug That...
#ai#postgres#python#machinelearning
0 0
Arnav Sharma6d ago • 5 min read
The Data Structure Behind Every Database Index: B+ Trees
B+ trees explained: how your database finds a row in 3 reads Thirty million rows. One...
#database#postgres#backend#programming
0 0
David Bartalos5d ago • 9 min read
Replace the Heuristic With a Boundary: Rebuilding a Leave Table as an Append-Only Ledger
We deleted the reconciliation step from a data migration and replaced it with a single timestamp....
#postgres#architecture#database#datamigration
0 0
Brian kiplangat2d ago • 5 min read
Five SQL Bugs That Never Threw an Error
A week cleaning 290 booking records taught me more about silent failure than any error...
#sql#postgres#dataengineering#analytics
0 0
fr_trenton023d ago • 5 min read
Rebuilding the Cerebras Knowledge Base: the naive vector baseline
Part 1: one pgvector table and cosine similarity over FastAPI code and issues. How far naive vector ...
#rag#vectordatabase#postgres#ai
0 0
David Bartalos5d ago • 10 min read
Nine of Thirteen Corrections Were Wrong: The Fix That Came With a Proof It Couldn't Work
Nine of the thirteen corrections our migration code had ever written in production were wrong. We...
#postgres#database#datamigration#debugging
0 2
Anand Rathnas5d ago • 6 min read
Backups That You Don't Restore Aren't Backups: A Weekly Restore Drill
We back up Postgres nightly to DigitalOcean Spaces. Every Sunday a separate workflow restores the la...
#postgres#devops#githubactions#database
0 1
Valentin Podkamennyi5d ago • 5 min read
Databricks buys Electric to embed local Postgres in AI agents
Databricks is acquiring the startup Electric to integrate WebAssembly-based Postgres databases...
#databricks#postgres#aiagents#databasearchitecture
4 0
💻 Arpad Kish 💻3d ago • 2 min read
Demystifying Vector Distance in PostgreSQL
A look into sliding window comparisons for image analysis. When you need to perform complex...
#algorithms#database#postgres#sql
1 0