Insights &
Thoughts
Exploring the frontiers of software architecture, AI agents, and modern development practices.

Running Two GraphPG APIs on One 3-Dollar UpCloud VPS
How a 1 GB UpCloud server hosts two PostgreSQL 18 demo databases and two GraphPG 1.3.0 instances behind a Cloudflare Tunnel without overflowing RAM.
Innovi Care
Multilingual clinical practice platform and patient portal powered by schema-first PostgreSQL Row-Level Security and GraphPG.

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.
Showing 1 to 9 of 84 items