The Daily
A note a day on APIs and the realities of shipping web applications. Stuff I've actually learned across 25 years of doing the work.
Streaming Claude Responses in PHP: What Actually Works
Streaming from the Claude API in PHP is doable, but the path there has some real gotchas. Here's what I learned shipping it in production.
Streaming LLM responses is one of those features that looks trivial in Python demos and turns into a two-day detour in PHP. I integrated Claude's streaming API into a Laravel app for a document-review tool last year and came out the other side with a working pattern — and a list of things that will quietly destroy you…
Read the daily →Why Your DBA Hates Your PostGraphile-Generated Queries
PostGraphile is genuinely impressive until you look at what it's actually sending to Postgres. Here's what surprised me.
PostGraphile is one of those tools that feels like a cheat code the first time you point it at a Postgres schema and get a fully typed GraphQL API in under a minute. Then you go to production and your DBA — or in my case, me wearing the DBA hat — starts looking at and has a very bad afternoon. I want to be clear: I…
Read the daily →GraphQL Introspection in Production Is a Gift to Attackers
Leaving GraphQL introspection enabled in production hands your entire API schema to anyone with curl. I've seen this in the wild and it's worse than you think.
Introspection is one of GraphQL's best developer experience features and one of the most consistently mishandled security decisions I see in production APIs. Leaving it on is the equivalent of publishing your entire database schema on your homepage — every type, every field, every relationship, every mutation, fully…
Read the daily →Postgres Replication Lag Burned Me: Read-After-Write Is Harder Than It Looks
I shipped a feature that worked perfectly in dev and fell apart in production. The culprit was replication lag I didn't account for.
I deployed a feature for a healthcare client that let patients update their contact information and immediately see a confirmation screen reflecting those changes. It worked flawlessly in every environment I tested. It broke in production within the first hour. The bug took me an embarrassing amount of time to track…
Read the daily →PostGraphile: When the Magic Stops Being Magic
PostGraphile auto-generates a GraphQL API from your Postgres schema in minutes. Then you need a plugin, and the clock stops.
PostGraphile's zero-config GraphQL generation is genuinely impressive. Point it at a Postgres schema and you get queries, mutations, subscriptions, and pagination — all wired up and typed correctly. I've demoed it to clients and watched their eyes light up. Then I needed to customize something real, reached for the…
Read the daily →