Product Information
What is Postgrest?
PostgREST is a standalone web server that turns your PostgreSQL database directly into a RESTful API. The structural constraints and permissions in the database determine the API endpoints and operations.
Using PostgREST is an alternative to manual CRUD programming. Custom API servers come with issues. Writing business logic often leads to repetition, oversight, or interference with the database structure. Object-relational mapping is a leaky abstraction that results in slow, imperative code. The PostgREST philosophy establishes a single declarative source of truth: the data itself.
It's easier to let PostgreSQL handle data joins and allow its query planner to figure out the details than to loop through rows yourself. Assigning permissions to database objects is simpler than adding guards in controllers. (This is especially true for cascading permissions in data dependencies.) Setting constraints is more straightforward than cluttering your code with sanity checks.
How to use Postgrest?
PostgREST is a standalone web server that turns PostgreSQL databases directly into RESTful APIs. It defines API endpoints and operations through database structural constraints and permissions, aiming to use the data itself as the single declarative source of truth, replacing manual CRUD programming.
Core Functions of Postgrest
REST API
Usage Scenarios of Postgrest
- Directly convert PostgreSQL databases into RESTful APIs.
- Database administrators create APIs from scratch without custom programming.
- Assign permissions via database objects instead of adding guards in controllers.
- Set database constraints as alternatives to sanity checks in code.
- Create SOAP endpoints.
- Provide HTML content or images.
Common Questions about Postgrest
What does PostgREST do?
How do I use PostgREST?
What are the core features of PostgREST?
What are the use cases for PostgREST?
