High-throughput systems architecture rules for Go (Golang), pgxpool connection management, sqlc type-safe query generation, and React web dashboards.
Production conventions for high-throughput, low-latency concurrent systems with Go (Golang), pgxpool, sqlc, and React.
This exact architecture powers massive monitoring and messaging systems including Grafana, Mattermost, Lago, and PocketBase.
sqlc validates SQL queries against actual PostgreSQL schema at build time.Yes — AGENTS.md is the open, cross-tool standard read by Cursor, Claude Code, Windsurf, and 30+ other agents. A dedicated .mdc file is also included for Cursor's native .cursor/rules format.
sqlc compiles hand-written SQL into type-safe Go structs and functions at build time, so a broken query fails the build instead of failing at runtime in production. ORMs like GORM generate SQL dynamically at runtime, which trades compile-time safety for convenience — sqlc keeps the performance and predictability of raw SQL with full type safety.
If an HTTP client disconnects mid-request, Go's context carries that cancellation signal down into pgx, which immediately aborts the in-flight query instead of letting it run to completion on an abandoned connection. Skipping this wastes database connections and CPU on work nobody is waiting for anymore.
Architecture rules for Astro server-side rendering, React client islands, Tailwind CSS, and Cloudflare Pages/Workers edge deployment.
Ultra-fast edge API architecture using Bun.serve(), Hono v4, Drizzle ORM with embedded SQLite / Turso libSQL, and Zod OpenAPI validation.
Production guidelines for Django 5 enterprise applications, PostgreSQL connection pooling, Redis caching, and Celery async workers.
Production guidelines for FastAPI, Pydantic v2 validation, Async SQLAlchemy 2.0 (asyncpg), Alembic migrations, and PostgreSQL/Redis.