begriffs/postgrest
Postgrest
PostgREST is a standalone web server that automatically transforms a PostgreSQL database into a RESTful API. It serves as an API gateway that translates HTTP requests into SQL queries, mapping the database schema directly to endpoints without the need for manual route definitions.
The system utilizes a JWT authentication layer to validate user identities and map incoming web requests to specific database roles. This allows the server to delegate authorization and permission enforcement to the internal PostgreSQL role system.
It includes a generator for OpenAPI specifications to provide standardized documentation for exploring and testing endpoints. The project also supports database schema versioning to allow the data interface to evolve without breaking existing client integrations.
Features
- Database-to-REST Interfaces - Provides an automated system that transforms PostgreSQL database schemas directly into a RESTful API.
- Database REST APIs - Automatically transforms a PostgreSQL database schema into a set of RESTful endpoints for programmatic data access.
- HTTP Data Interfaces - Provides a direct way for frontend applications to query and modify Postgres data via HTTP requests.
- Database Query Translators - Translates HTTP request parameters and filters into valid PostgreSQL SQL statements for data operations.
- Database Schema Introspection Tools - Analyzes database system catalogs at runtime to automatically derive the API structure and available endpoints.
- Database - Acts as a gateway that translates HTTP requests into SQL queries while enforcing database-level permissions.
- Database Access Controls - Enforces granular access control by delegating permissions to the underlying database role system.
- Identity-Based Authentication - Verifies incoming requests using signed JWTs to assign the appropriate database identity.
- JWT Authentication - Uses a JWT authentication layer to validate identities and map them to database roles.
- Role-Based Access Control - Delegates authorization to the PostgreSQL role system by executing queries under restricted database user roles.
- Identity Mapping - Maps validated JWT claims to specific database roles to enforce request-level security policies.
- Schema Versioning - Handles schema versioning to allow the data interface to evolve without impacting existing clients.
- Automatic Specification Generators - Automatically derives OpenAPI specifications from the database schema to enable interactive testing.
- API Documentation Generators - Produces standardized OpenAPI specifications to provide interactive documentation and testing guides for endpoints.
- API Versioning Strategies - Supports API versioning by exposing different database schema versions to prevent breaking client integrations.
- Stateless Architectures - Implements a stateless architecture that relies on the database for session and state management.
- API Frameworks - Serves RESTful APIs directly from PostgreSQL databases.
- Server Frameworks - Serve RESTful APIs directly from existing PostgreSQL databases.
Star history
How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.
