How vb-consulting/npgsqlrest works
Main Components
a) Core Components:
• NpgsqlRest Middleware (Central Component)
• PostgreSQL Database
• REST API Layer
• Client Applications
b) Plugin System:
• CRUD Source Plugin
• HTTP Files Plugin
• TypeScript Client Generator Plugin
[Client Layer]
• ↑↓
[REST API Layer]
• ↑↓
[NpgsqlRest Middleware]
• ↑↓
[PostgreSQL Database]
Component Details
• Auth Handler (from Auth/ directory)
• Parameter Parser
• Routine Source Manager
• Type Converters
• Middleware Extensions
Plugin System (Right side):
• CRUD Operations
• HTTP File Generation
• TypeScript Client Generation
Database Integration (Bottom):
• PostgreSQL connection with:
• Function/Procedure Discovery
• Comment Parser
• Type Mapping
Client Integration (Top):
• Supported client interfaces:
• REST API Endpoints
• Generated TypeScript Clients
• HTTP File Definitions
Flow Indicators
• Request flow from clients through the middleware to database
• Response flow back to clients
• Plugin integration points
• Code generation paths
Technical Details
Technical aspects:
• .NET 8/9 compatibility
• Npgsql integration
• PostgreSQL version requirements (≥13)
• Native AOT compilation support