Code — page 23 of 23

Frameworks, languages, and the dev stack worth using — plus AI agents for software builders.

1105 dispatches — ranked, compared, and verified.

  1. Query Statistics: The First Thing to Enable on a Database

    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, 2026
  2. Best payment gateways for SaaS in 2026

    Honest 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, 2026
  3. Best monitoring tools for SaaS in 2026

    Honest 2026 ranking of SaaS monitoring tools — error tracking, session replay, logs, observability. Real free tier limits and when to upgrade.

    Code · January 10, 2026
  4. HMAC Request Signing: Proving a Request Is Genuine

    A 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, 2026
  5. Best laptops for programmers under $1,500 in 2026

    We 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, 2026
  6. Check Constraints: Rules the Database Enforces for You

    Validation 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, 2026
  7. Enum vs Lookup Table: Where Should Your Fixed Values Live?

    A 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, 2026
  8. Restore Drills: Practising Recovery Before You Need It

    Verified 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, 2026
  9. Best email APIs for developers in 2026

    Honest 2026 ranking of transactional email APIs by deliverability, DX, and price. The four worth using and the ones to skip.

    Code · January 8, 2026
  10. Best free alternatives to paid developer tools in 2026

    We 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, 2026
  11. Best Git GUI clients in 2026

    Honest 2026 ranking of Git GUI clients by speed, feature depth, and price. Plus the case for staying on the CLI.

    Code · January 8, 2026
  12. Clustered Indexes: When Physical Order Matters

    Storing 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, 2026
  13. Bulk Copy Loading: The Fast Path Into a Table

    Databases 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, 2026
  14. Hypertables: Automatic Partitioning for Time-Series Data

    Manual 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, 2026
  15. Recursive CTEs: Querying Hierarchies in One Statement

    Walking 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, 2026
  16. Allocation Profiling: Finding What Your Code Is Creating

    A 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, 2026
  17. Best CI/CD tools for indie developers in 2026

    Honest 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, 2026
  18. Best CMS for developers in 2026: Sanity vs Payload vs Strapi

    2026 ranking of headless CMS for developers — by DX, pricing, self-hosting, and which one fits your stack.

    Code · January 7, 2026
  19. Best databases for AI applications in 2026

    Honest 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, 2026
  20. Bloat Monitoring: Measuring Space You Cannot See

    A 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, 2026
  21. Exactly-Once Delivery: The Guarantee You Cannot Have

    Message 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, 2026
  22. GIN Indexes: Indexing Values Inside a Column

    A 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, 2026
  23. Autovacuum Tuning: Keeping Cleanup Ahead of Churn

    The 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, 2026
  24. Backup Verification: A Backup You Have Not Restored Is a Guess

    Backup 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, 2026
  25. Best authentication services in 2026

    Honest 2026 ranking of auth services for developers. Free tiers, real pricing at scale, and which one to pick by stack.

    Code · January 6, 2026
  26. Database Seeding: Getting Realistic Data Into Development

    Ten 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, 2026
  27. GraphQL N+1: When a Flexible API Melts the Database

    A 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, 2026
  28. Replication Lag: When the Replica Has Not Caught Up

    Routing 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, 2026
  29. Varchar vs Text: A Length Limit Is a Constraint, Not a Speedup

    Declaring 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, 2026
  30. API Fuzzing: Finding Inputs Nobody Thought to Test

    Your 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, 2026
  31. Best AI Tools for Solopreneurs in 2026

    Ten 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, 2026
  32. Flame Graphs: Reading Where the Time Goes

    A 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, 2026
  33. JSON Columns: Flexible Schema With Real Tradeoffs

    Storing 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, 2026
  34. Index-Only Scans: When the Table Is Never Touched

    If 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, 2026
  35. Lock Timeouts: Failing Fast Instead of Queueing Forever

    A 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, 2026
  36. Point-in-Time Recovery: Undoing the DELETE You Regret

    Replication 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, 2026
  37. Webhook Signing: Verifying What Arrived at Your Endpoint

    Your 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, 2026
  38. Incremental Builds: Not Rebuilding What Did Not Change

    A 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, 2026
  39. Sequence Exhaustion: The Outage With a Countdown

    A 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, 2026
  40. Best AI APIs for Developers in 2026: Claude vs OpenAI vs Gemini

    Three 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, 2026
  41. Best AI-powered code review tools in 2026

    Honest 2026 ranking of AI code review tools — by accuracy, false positive rate, integration depth, and price.

    Code · January 2, 2026
  42. Bulk Insert Performance: Loading Millions of Rows

    Inserting 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, 2026
  43. Deferrable Constraints: Checking at Commit Instead of Immediately

    Swapping 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, 2026
  44. Logical Replication: Replicating Changes, Not Blocks

    Physical 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, 2026
  45. Savepoints: Rolling Back Part of a Transaction

    An 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, 2026
  46. Async vs Threads: Two Ways to Wait for Many Things

    Both 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, 2026
  47. Fixture Management: Test Data That Does Not Rot

    A 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, 2026
  48. UUID v7: Opaque Identifiers That Insert Sequentially

    Random 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