Insights &
Thoughts
Exploring the frontiers of software architecture, AI agents, and modern development practices.
End-to-End Type Safety for Claude Code: PostgreSQL Schema to GraphQL SDL with GraphPG
Why manual Zod tool contracts drift from your database, and how GraphPG compiles PostgreSQL schemas into GraphQL SDL to generate end-to-end TypeScript types that stop AI tool hallucinations at compile time.
Why I Built pytest-async-benchmark: Real Async Benchmarking for Python
Why pytest-benchmark fails on async coroutines, how pytest-async-benchmark measures execution inside the running event loop without overhead, and how pedantic mode isolates setup and teardown.
Multi-Tenant AI Agents: Enforcing PostgreSQL Row-Level Security in LangGraph
How to prevent cross-tenant data leaks in autonomous LangGraph workflows by binding session-scoped tenant claims to PostgreSQL Row-Level Security policies.
RetroAgile
Continuous Retrospectives, Agent Churn Auditing, and Spec-Readiness Scoring for autonomous human + AI coding agent teams.
Instant GraphQL and REST from Any Postgres Database: Introducing graphpg
If you avoided GraphQL because of resolver boilerplate, or found tools like Hasura too heavy, here is what a database-first Rust engine looks like.
Why Row-Level Security Is the Safest Place for Authorization in AI-Built Apps
Why AI coding agents leave tenant filters out of queries, and how PostgreSQL Row-Level Security (RLS) moves authorization into the database, where one short policy covers every query and is easy to review.
Why GraphQL and REST Should Share One Engine: What I Learned Building graphpg
What PostGraphile, Hasura and PostgREST got right, what I did differently in graphpg (one Rust engine for GraphQL and REST, one SQL statement per request, no plugins), and why the two APIs should come from one plan instead of competing.
How End-to-End Type Safety Turns 'Change It Everywhere' Into a List Your AI Agent Can Finish
Why AI coding agents miss places when you ask them to change something everywhere, and how types generated from the database (SQL, GraphQL SDL, OpenAPI 3.1, TypeScript) turn every miss into a compiler error. Measured on a 177-table schema.
graphpg
In-house built high-performance Rust engine that derives unified GraphQL and REST APIs (OpenAPI 3.1) directly from PostgreSQL catalogs with single-statement execution and end-to-end type safety.
Showing 1 to 9 of 82 items