PostgREST logo

PostgREST

Automatic REST API for Any Postgres Database
59
116
+ 1
8

What is PostgREST?

PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch.
PostgREST is a tool in the Database Tools category of a tech stack.
PostgREST is an open source tool with GitHub stars and GitHub forks. Here’s a link to PostgREST's open source repository on GitHub

Who uses PostgREST?

Companies
7 companies reportedly use PostgREST in their tech stacks, including AmperVue, Postila, and Fyle Technologies Private Limited.

Developers
52 developers on StackShare have stated that they use PostgREST.

PostgREST Integrations

Pros of PostgREST
4
Fast, simple, powerful REST APIs from vanilla Postgres
2
JWT authentication
1
Very fast
1
Declarative role based security at the data layer

PostgREST Alternatives & Comparisons

What are some alternatives to PostgREST?
GraphQL
GraphQL is a data query language and runtime designed and used at Facebook to request and deliver data to mobile and web apps since 2012.
Slick
It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
Spring Data
It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
Dataform
Dataform helps you manage all data processes in your cloud data warehouse. Publish tables, write data tests and automate complex SQL workflows in a few minutes, so you can spend more time on analytics and less time managing infrastructure.
DB
With DB you can very easily save, restore, and archive snapshots of your database from the command line. It supports connecting to different database servers (for example a local development server and a staging or production server) and allows you to load a database dump from one environment into another environment.
See all alternatives

PostgREST's Followers
116 developers follow PostgREST to keep up with related blogs and decisions.