Technical

Every dispatch.

Sorted newest first.

Postgres Dispatch

Postgres SQL/JSON Path Expressions: Querying jsonb with Real Pattern Matching

Postgres has supported jsonb since 9.4, but the SQL standard's jsonpath language added in Postgres 12 changed what you can ask of JSON columns. The operators are unfamiliar and the language is its own small grammar, but the capability is real.

7 min read Read →

Dispatch

engineering Dispatch

Webhook Security: A Field Guide to Not Getting Owned

Webhooks are the duct tape of modern software architecture. They're how Stripe tells you about payments, how GitHub notifies you of pushes, how practically every SaaS product communicates events. They

2 min read Read →