⚡
NpgsqlRestAutomatic PostgreSQL Web Server
SQL is declarative — your API should be too. Write SQL, annotate it with comments to declare caching, auth, retries, rate limiting, and everything in between. PostgreSQL is the architecture.
Skip to content
REST 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 managementPostgreSQL 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 APIs
Custom 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 generation
_ __ __ ____ __
/ | / /___ ____ ________/ / / __ \___ _____/ /_
/ |/ / __ \/ __ `/ ___/ __ \/ /_/ / _ \/ ___/ __/
/ /| / /_/ / /_/ (__ ) /_/ / _, _/ __(__ ) /_
/_/ |_/ .___/\__, /____/\__, /_/ |_|\___/____/\__/
/_/ /____/ /_/
PostgreSQL is the architecture — not a detail to abstract away
- ✓ Declare, don't code — Caching, auth, retries, rate limiting — all declared as SQL annotations
- ✓ PostgreSQL at the center — The opposite of Clean Architecture: the database drives everything
- ✓ Types flow outward — PostgreSQL types generate TypeScript clients automatically
- ✓ No middle tier — No controllers, no models, no mapping layers, no boilerplate
Declarative Annotations
Declare what you want from your endpoint — caching, authorization, timeouts, retries, rate limiting — right where the SQL lives.
SQL File
sql
/*
HTTP GET /users/
@authorize admin, user
@cached
@cache_expires_in 30sec
@timeout 5min
@table_format = excel
@excel_file_name = users.xlsx
*/
select id, name, email, role
from users
where $1 is null or department_id = $1;PostgreSQL Function
sql
create or replace function api.get_users(
_department_id int
)
returns table (id int, name text, email text, role text)
language sql
begin atomic;
select id, name, email, role
from users
where
_department_id is null
or department_id = _department_id;
end;
comment on function api.get_users(int) is '
HTTP GET /users/
@authorize admin, user
@cached
@cache_expires_in 30sec
@timeout 10sec
@retry_strategy aggressive
@rate_limiter_policy authenticated_limit
@tsclient_module = users
';Blog
REST 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 managementPostgreSQL 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 generation
❤️ Support this project: Patreon · Buy Me a Coffee
Released under the MIT License.
Copyright © 2024-2026 VB Consulting