Blog Posts & Tutorials
The Backend That Writes Itself — NpgsqlRest in 19 SlidesAn interactive slide deck with page controls, keyboard navigation, and speaker notes. The whole NpgsqlRest pitch — PostgreSQL in, REST API + typed TypeScript client + AI-agent tools out — with real, reproducible numbers from a product in productionTurn PostgreSQL into MCP Tools an AI Agent Can CallNpgsqlRest 3.17.0 adds Model Context Protocol support. Annotate a function or .sql file with @mcp and it becomes a tool an AI agent can discover and call — one source, two interfaces (REST + MCP), with structured output, MCP-only tools, and per-tool authorizationFrom SQL to Type-Safe TypeScript: A Walkthrough of NpgsqlRest's Code GeneratorGenerate typed fetch modules and TypeScript interfaces directly from PostgreSQL functions and SQL files. End-to-end type safety, per-endpoint control with @tsclient annotations, and real-world dev/prod workflowNpgsqlRest 3.13.0: Cache Profiles, Auth Schemes, Per-User Rate Limits, and pgBouncer CompatibilityConditional caching with When rules, short-lived sensitive sessions, per-user rate limiting, and multi-tenant search_path with pgBouncer — all real-world production patterns
SQL REST APIThe story behind NpgsqlRest 3.12.0 — SQL file endpoints, the philosophy of database-first development, AI tools, and why I think Clean Architecture got it wrongREST APIs from Plain SQL Files: The Complete Guide to SQL File SourceBuild REST APIs directly from .sql files - no functions, no procedures, no boilerplate. Multi-command endpoints, automatic parameter inference, and TypeScript generationExcel Exports Done Right: Zero-Allocation Streaming from PostgreSQLStream .xlsx exports directly from PostgreSQL with constant memory - zero allocations, native types, one SQL annotationImplementing WebAuthn Passkeys with Pure SQLPasswordless authentication using device biometrics - complete SQL-based passkey registration, login, and credential management
PostgreSQL REST API Benchmark 2026Performance comparison of NpgsqlRest vs PostgREST, Django, FastAPI, Spring Boot, and moreNpgsqlRest vs PostgREST vs Supabase: Complete Feature ComparisonSide-by-side comparison with performance benchmarks, features, authentication, file handling, and deployment optionsPerformance, Scalability, and High AvailabilityCaching strategies, retry logic, rate limiting, and multi-host PostgreSQL connections for production APIsCustom Types and Multiset for Nested JSON in PostgreSQL REST APIsUse PostgreSQL custom types and table types to build hierarchical REST API responses with automatic TypeScript generationPostgreSQL Optimization Labels 101VOLATILE, STABLE, IMMUTABLE, PARALLEL options, COST, ROWS, and STRICT - a quick reference for function optimizationThe Power of SimplicityHow collapsing the standard data access pattern down to UI → RDBMS could save enough energy to power a small countryEnd-to-End Static Type Checking: PostgreSQL to TypeScriptHow to achieve compile-time type safety from database to frontend with NpgsqlRestDatabase-Level Security: PostgreSQL AuthenticationImplementing the Principle of Least Privilege with secure cookie-based authenticationMultiple Auth Schemes, RBAC & External ProvidersBuilt-in password verification, cookies/JWT/Bearer tokens, role-based access, and Google OAuthTurn PostgreSQL into a BI Server: CSV Exports, Basic Auth & ExcelServe CSV reports directly to Excel with Basic Auth, SSL, and type composition - a complete BI system for freeSecure Image Uploads with PostgreSQL: File System, Large Objects & TypeScriptBuild a complete upload system with progress callbacks, image validation, and type-safe generated clientsCSV and Excel Ingestion Made Easy: PostgreSQL Row ProcessingTransform file imports into declarative row-by-row processing with automatic TypeScript clients and progress trackingBuild a Real-Time Chat App with PostgreSQL and Server-Sent EventsSecure real-time messaging with 25 lines of SQL - no WebSockets, no message brokers, no LISTEN/NOTIFY scaling issuesCall External APIs from PostgreSQL: HTTP Types in NpgsqlRestDefine external API calls using .http file syntax in type comments - no HTTP extensions, no middleware, just SQLWeb Scraping with PostgreSQL: HTTP Types + XML FunctionsFetch a page with an HTTP Custom Type, parse the HTML with PostgreSQL's built-in XPath functions, and serve JSON - a web scraper with no application codeReverse Proxy & AI Service: PostgreSQL Caching with Transform ModeProxy external services through PostgreSQL functions - cache AI responses, enrich data, and avoid connection pool exhaustionWhat Have PostgreSQL Functions Ever Done for Us?Apart from security, performance, maintainability, testability, and zero boilerplate code, what have they really done for us?