Blog Posts & Tutorials
PostgreSQL REST API Benchmark, July 2026 — 20 Services, 760 Tests
NpgsqlRest 3.20.0: Dart Clients for Flutter, React Query Hooks, and Tool Schemas for AI AgentsA code-generation release: typed Dart clients for every Flutter target, TanStack Query hooks with exported key factories generated alongside the TypeScript client, the @mcp tool catalog projected into OpenAI/Anthropic tools documents and llms.txt, and the new HTTP QUERY method across the stackTests Are SQL Files TooThe story behind NpgsqlRest 3.19.0 — write endpoint tests as plain .sql files that invoke the real endpoint in-process, inside the test's own transaction; watch mode that turns the live database schema into your type checker; and why database testing was never actually impossible — you were just using the wrong databaseCase Study: 74 Endpoints, Zero Backend Code — A Production App Built Entirely on NpgsqlRestWhat it actually looks like to ship a production application without a controller layer. Real numbers from a finance/visualization app: ~74 HTTP endpoints, 12K LOC of SQL, zero lines of C# or Python, and an estimated 3,500–7,300 LOC of host-language boilerplate eliminatedThe 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 patternsSQL 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 managementNpgsqlRest 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 generationThe 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?