pREST

•
4.6k
•

Instantly generates a high-performance RESTful API over new or existing PostgreSQL databases, simplifying and accelerating application development.

pREST (PostgreSQL REST) provides a production-ready, lightweight API that delivers instant, real-time, and high-performance access to your PostgreSQL database. Designed to address the need for fast and efficient API solutions, it streamlines development by offering easy configuration, direct SQL query capabilities with templating, and robust authentication/authorization. Built in Go, pREST integrates seamlessly with existing or new Postgres instances (version 9.5+), offering features like pluggable custom routes, a read-only MCP-style HTTP endpoint for database discovery and operations, and support for multi-database architectures, significantly enhancing developer productivity.

주요 기능

01Pluggable Custom Routes and Middlewares
024,562 GitHub stars
03Direct SQL queries with templating via customizable URLs
04Built-in Authentication and Authorization features
05Multi-database and Multi-cluster Management
06Instant, Realtime, High-Performance API for PostgreSQL

사용 사례

01Rapidly exposing existing PostgreSQL databases as RESTful APIs
02Accelerating development of new applications requiring a PostgreSQL backend
03Consolidating API access and management for multiple PostgreSQL instances