#NpgsqlRest turns your #PostgreSQL database into a blazing-fast standalone #REST #API server — automatic #TypeScript code generation, end-to-end type safety & zero middleware 🚀 #dotnet #opensource
🏗️ Auto-generates REST endpoints directly from #PostgreSQL functions, procedures, tables & views — no controller boilerplate, no ORM mapping, no N+1 queries. Schema = your API contract.
🧵👇
⚡ Benchmarks: #NpgsqlRest is 6.1x faster than #PostgREST at 100 concurrent users — AOT-compiled native binaries, zero runtime dependencies & instant startup time
🔧 Install via npm, Docker, direct download or as a #dotnet library — requires #PostgreSQL >= 13 — no runtime dependencies for the native executable builds
📝 Declarative config via SQL comment annotations — define routes, auth rules & caching directly in your DB. One source of truth, zero drift between logic and config.
🔁 RESTful path params like /products/{id}, reverse proxy endpoints (passthrough or transform), HTTP custom types letting #PostgreSQL functions call external APIs directly
🛡️ Enterprise-ready out of the box: authentication, authorization, rate limiting, caching, SSE streaming & full #OpenAPI 3.0 spec generation — no extra layers needed
📐 #PostgreSQL types auto-generate #TypeScript clients — no manual type mappings, no DTO layers, no impedance mismatch. Types flow outward from DB to frontend automatically.
Transform Your PostgreSQL Database into a Production-Ready, Blazing-Fast Standalone REST API Web Server With Static Type Checking and Automatic Code Generation - NpgsqlRest/NpgsqlRest
michabbb