SQL, Shell & Data Science

37+ min ago   (713+ words) ParadeDB shipped pg_search 0.26.0 on 3 October, and the changelog describes it as a rewrite of how the extension stores BM25 field-length data for scoring. The company's own framing is that search got faster. I wanted to know faster at what, and slower at…...

45+ min ago   (656+ words) The rehearsal below is labeled sample SQL and is not an executed production result: hashtext is a convenience, not a cryptographic guarantee, and collisions remain possible across poorly chosen names. Teams that take this path should keep a registry of…...

45+ min ago   (450+ words) The staging failure below is a reconstructed example, not a measured incident from this account's history. A checkout service asked an agent to draft a backfill after refunds.amount became a stored generated column. The prompt still held an older…...

45+ min ago   (851+ words) Teams that let models reach PostgreSQL tend to land on one of two tool designs. The first design publishes a small set of stored contracts and refuses any other statement text. The second design lets the agent read the live…...

47+ min ago   (596+ words) When you need to store data in the browser, IndexedDB is usually the first API that comes to mind. It's a browser database with object stores, indexes, and transactions, so you don't have to build any of that yourself. Then…...

47+ min ago   (1732+ words) A composite warehouse incident, rather than a claimed personal outage, is enough to frame this operational choice. An exploratory agent drafted a wide analytical query against a shared reporting database during an ordinary afternoon. The statement sorted a large fact…...

1+ hour, 30+ min ago   (1081+ words) Think of a restaurant. Your Django code is the waiter, PostgreSQL is the kitchen, and the disk is the pantry. When dinner is slow, people blame the waiter’s handwriting (the ORM). Far more often the waiter is making 200 separate trips…...

1+ hour, 19+ min ago   (493+ words) Nakodo has an operator panel at /admin: accounts, plans, campaigns, the inbound mail that failed to forward, the job queue, and a run log of the background pipeline. Its front page is a wall of numbers, and the first version…...

1+ hour, 25+ min ago   (542+ words) query-inspector is a Claude Code skill that extracts the SQL/ORM queries from your project's source, then diagnoses and tunes missing indexes / N+1 problems / anti-patterns. Queries that run fine until the data piles up. N+1 problems that sail through code…...

1+ hour, 28+ min ago   (557+ words) Recently I've made a Zig based CLI argument parser called argh I've even written myself a roadmap I'd like to follow with this project. And so far I have been following it pretty well. However last week I began working…...