Frameworks, languages, and the dev stack worth using — plus AI agents for software builders.
1105 dispatches — ranked, compared, and verified.
Cumulative statistics per normalised query answer the only question that matters when a database is slow: what is actually consuming it. Nothing else gets you there as fast.
Code · January 12, 2026Honest 2026 comparison of the four payment platforms indie SaaS founders actually use. Includes the tax-handling math that decides which one is right for your stage.
Code · January 11, 2026Honest 2026 ranking of SaaS monitoring tools — error tracking, session replay, logs, observability. Real free tier limits and when to upgrade.
Code · January 10, 2026A shared secret in a header proves the sender knows the secret. Signing the request proves the request itself was not altered, which is a considerably stronger claim.
Code · January 10, 2026We compared the seven laptops most worth buying for development work in 2026 — Mac, Windows, Linux — on the specs and tradeoffs that actually matter for a working coder. Honest recommendations, no fake 'tested for 6 months' claims.
Code · January 9, 2026Validation in application code holds until something else writes to the table. A check constraint holds for every writer, including the console session during an incident.
Code · January 9, 2026A status column with five possible values can be a database enum, a lookup table, or a check constraint. The right answer depends almost entirely on who needs to change the list.
Code · January 9, 2026Verified backups prove the data can come back. A drill proves your team can bring it back, under pressure, using a procedure that has been read by someone other than its author.
Code · January 9, 2026Honest 2026 ranking of transactional email APIs by deliverability, DX, and price. The four worth using and the ones to skip.
Code · January 8, 2026We replaced 12 paid developer tools with their best free alternatives — and tracked exactly when each one falls down. Honest verdicts on which switches save real money and which ones cost you in time.
Code · January 8, 2026Honest 2026 ranking of Git GUI clients by speed, feature depth, and price. Plus the case for staying on the CLI.
Code · January 8, 2026Storing rows in index order makes range scans dramatically faster and makes the choice of key a decision you live with, because inserting in the wrong order fragments everything.
Code · January 8, 2026Databases have a dedicated interface for loading data that bypasses statement parsing entirely. It is dramatically faster than inserts and considerably less forgiving.
Code · January 8, 2026Manual time partitioning works and requires you to create next month's partition before next month arrives. Hypertables automate that, and add compression and retention on top.
Code · January 8, 2026Walking an org chart or a category tree in application code means N queries. A recursive common table expression does it in one, and it needs a termination condition you supply.
Code · January 8, 2026A program with no memory leak can still spend a third of its time in garbage collection. Allocation profiling shows what is being created, which is usually more actionable than what is retained.
Code · January 7, 2026Honest 2026 ranking of CI/CD tools by indie-dev value — free tier limits, real cost at scale, and which one to default to.
Code · January 7, 20262026 ranking of headless CMS for developers — by DX, pricing, self-hosting, and which one fits your stack.
Code · January 7, 2026Honest 2026 comparison of databases for AI apps — Postgres + pgvector vs Pinecone vs Qdrant vs Weaviate. When you need a dedicated vector DB and when you don't.
Code · January 7, 2026A table twice the size of its live data reads twice as many pages for every scan. Bloat is invisible in ordinary metrics and degrades performance continuously until someone measures it.
Code · January 7, 2026Message systems advertise exactly-once semantics. What is actually achievable is at-least-once delivery plus idempotent processing, which produces the same outcome by a different route.
Code · January 7, 2026A B-tree indexes a column's value. A GIN index indexes the things inside it — array elements, document keys, words in a text field — which is a different problem.
Code · January 7, 2026The background process reclaiming dead rows is fine until it is not. When it falls behind on a hot table, bloat grows, queries slow, and nothing in your application changed.
Code · January 6, 2026Backup jobs report success by writing a file. Whether that file can be restored into a working database is a different question, and it is the only one that matters.
Code · January 6, 2026Honest 2026 ranking of auth services for developers. Free tiers, real pricing at scale, and which one to pick by stack.
Code · January 6, 2026Ten hand-written rows hide every performance problem and every edge case. A production copy is realistic and a compliance liability. The workable answer is in between.
Code · January 6, 2026A query requesting a list and a nested field per item generates one database query per item. GraphQL makes this trivially easy to trigger from the client side.
Code · January 6, 2026Routing reads to a replica scales your read capacity and introduces a window where the replica does not yet have data the primary already committed.
Code · January 6, 2026Declaring a column as varchar(255) does not make it smaller or faster in most databases. It adds a constraint, and constraints should be chosen deliberately.
Code · January 6, 2026Your tests cover the inputs you imagined. Fuzzing generates the ones you did not, and it reliably finds crashes in code that has been in production for years.
Code · January 5, 2026Ten AI tools, one solopreneur, under $200 a month total. We built the actual stack you can run a one-person SaaS, agency, or content business on in 2026 — and which categories you can skip.
Code · January 5, 2026A flame graph shows which code paths consume your CPU, aggregated across thousands of samples. Reading one correctly takes five minutes to learn and saves hours of guessing.
Code · January 5, 2026Storing a document in a column avoids schema migrations for every new field. It also gives up type checking, constraint enforcement, and straightforward indexing.
Code · January 5, 2026If every column a query needs is in the index, the database can answer without reading the table at all. That is frequently the difference between a slow query and an instant one.
Code · January 4, 2026A migration waiting for a lock does not just wait. Everything arriving behind it queues too, and a brief schema change becomes a full outage.
Code · January 4, 2026Replication copies your mistakes instantly. Point-in-time recovery is the only mechanism that lets you go back to just before someone ran a DELETE without a WHERE clause.
Code · January 4, 2026Your webhook endpoint is a public URL anyone can post to. Without signature verification, anyone can tell your system that a payment succeeded.
Code · January 4, 2026A build system that rebuilds everything on every change wastes most of its time. Incremental builds skip unchanged work, and they only help if the change detection is trustworthy.
Code · January 3, 2026A 32-bit identifier column runs out at around two billion rows. It is entirely predictable, entirely preventable, and still takes systems down every year.
Code · January 3, 2026Three frontier-model APIs. Three very different pricing curves. We benchmarked Claude, OpenAI, and Gemini on real tasks — here's which API to pick for chat, agents, code, and batch.
Code · January 2, 2026Honest 2026 ranking of AI code review tools — by accuracy, false positive rate, integration depth, and price.
Code · January 2, 2026Inserting a million rows one statement at a time takes hours. The same data loaded properly takes minutes, and the difference is almost entirely round trips and index maintenance.
Code · January 2, 2026Swapping two unique values fails because the intermediate state violates the constraint. Deferring the check to commit time lets the transaction pass through invalid states legally.
Code · January 2, 2026Physical replication copies a byte-identical database. Logical replication streams row changes, which makes selective replication and cross-version upgrades possible — with sharper edges.
Code · January 2, 2026An error inside a transaction usually poisons the whole thing. A savepoint lets you undo just the failed part and continue, which is the only way to handle expected failures mid-transaction.
Code · January 2, 2026Both let a program handle many concurrent operations. One uses the operating system scheduler, the other uses a loop and cooperation, and mixing them badly is how systems hang.
Code · January 1, 2026A shared fixture file starts as convenience and becomes a coupling nobody can change, because two hundred tests depend on user number three having exactly the properties it has.
Code · January 1, 2026Random UUIDs fragment your storage. Version 7 puts a timestamp in the high bits, so identifiers sort roughly by creation time and insert cleanly at the end.
Code · January 1, 2026