PostgREST
Standalone web server that turns any PostgreSQL database directly into a RESTful API.
Overview
PostgREST is a standalone web server that turns an existing PostgreSQL database's schema directly into a RESTful API, without you writing a separate application layer to expose each table or view. It's written in Haskell on the Warp HTTP server and is designed to push as much work as possible down into the database itself - including serializing JSON responses and running data validation in SQL - rather than doing that work in the API server.
It's typically installed as a standalone binary or run via Docker in front of a Postgres database, and the project reports subsecond response times at a few thousand requests per second even on modest hosting.
PostgREST fits teams that want to expose a Postgres database as a REST API quickly, with the database schema (tables, views, permissions) itself as the source of truth for what the API looks like, instead of hand-writing and maintaining CRUD endpoints.
- Keywords
- rest-apipostgresqlapibackend
- Languages
- Haskell
- License
- MIT
Related Projects
Hasura
Apache-2.0Instant GraphQL and REST APIs on top of PostgreSQL and other databases, via Data Connectors.
- Backend
- API
- Database
Directus
BUSL-1.1Open source data platform that wraps any SQL database with a dynamic API and an intuitive admin app.
- CMS
- Backend
- API
Supabase
Apache-2.0Open source Firebase alternative providing a Postgres database, authentication, instant APIs, edge functions, realtime subscriptions and storage.
- Backend
- Database
- Authentication & Security
Apache APISIX
Apache-2.0Dynamic, high-performance API gateway built on NGINX and etcd, adding hot-reloaded plugins, canary releases, and AI-traffic routing on top of traditional gateway features.
- API
Spotted an error? Suggest an edit on GitHub.