#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.

https://github.com/NpgsqlRest/NpgsqlRest

GitHub - NpgsqlRest/NpgsqlRest: Transform Your PostgreSQL Database into a Production-Ready, Blazing-Fast Standalone REST API Web Server With Static Type Checking and Automatic Code Generation

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

GitHub