Building REST APIs quickly using PostgREST

Welcome. We’re going to implement a sample REST API quickly using PostgREST.

If you are not a Medium member, then click here to read for free.

· Prerequisites
· Overview
∘ What is PostgREST?
∘ Why Use PostgREST?
∘ Set up PostgREST with Docker
· JSON Web Token (JWT) Authentication
· Conclusion
· References

Prerequisites

This is the list of all the prerequisites:

• Docker / Docker-compose installed (optional if you’ve already downloaded and installed PostgreSQL)
• PostgREST installed (available for Linux, macOS, and Windows via binaries or Docker).
• Basic knowledge of SQL and REST APIs.
• Postman / insomnia or any other API testing tool.

Overview

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. CRUD endpoints (create, read, update and delete) no…