All Projects → prest → Prest

prest / Prest

Licence: mit
PostgreSQL ➕ REST, low-code, simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new

Programming Languages

31211 projects - #10 most used programming language

Projects that are alternatives of or similar to Prest

Spring Boot Postgresql Jpa Hibernate Rest Api Demo
Building RESTful APIs with Spring Boot, PostgreSQL, JPA and Hibernate
Stars: ✭ 209 (-93.09%)
Mutual labels:  rest-api, rest, postgresql, postgres
Php Crud Api
Single file PHP script that adds a REST API to a SQL database
Stars: ✭ 2,904 (-3.94%)
Mutual labels:  rest-api, automatic-api, database, postgresql
Evolutility Server Node
Model-driven REST or GraphQL backend for CRUD and more, written in Javascript, using Node.js, Express, and PostgreSQL.
Stars: ✭ 84 (-97.22%)
Mutual labels:  rest-api, rest, database, postgres
REST API for any Postgres database
Stars: ✭ 18,166 (+500.93%)
Mutual labels:  rest, automatic-api, database, postgresql
Database migrations. CLI and Golang library.
Stars: ✭ 7,712 (+155.11%)
Mutual labels:  hacktoberfest, database, postgres, databases
Converts a database into gorm structs and RESTful api
Stars: ✭ 825 (-72.71%)
Mutual labels:  rest-api, rest, database, databases
Automatically generate a RESTful API service for your legacy database. No code required!
Stars: ✭ 1,765 (-41.61%)
Mutual labels:  rest-api, rest, automatic-api, database
Create a full-featured REST/GraphQL API from a configuration file
Stars: ✭ 188 (-93.78%)
Mutual labels:  rest-api, database, framework
Condenser is a database subsetting tool
Stars: ✭ 189 (-93.75%)
Mutual labels:  database, postgresql, postgres
Swagger Js
Javascript library to connect to swagger-enabled APIs via browser or nodejs
Stars: ✭ 2,319 (-23.29%)
Mutual labels:  rest-api, rest, hacktoberfest
Massive Js
A data mapper for Node.js and PostgreSQL.
Stars: ✭ 2,521 (-16.61%)
Mutual labels:  database, postgresql, postgres
⚡️ Express inspired web framework written in Go
Stars: ✭ 17,334 (+473.4%)
Mutual labels:  rest-api, hacktoberfest, framework
Postgres.js - The Fastest full featured PostgreSQL client for Node.js
Stars: ✭ 2,193 (-27.46%)
Mutual labels:  database, postgresql, postgres
Low code web framework for real world applications, in Python and Javascript
Stars: ✭ 3,349 (+10.78%)
Mutual labels:  rest-api, postgres, low-code
Pg hashids
Short unique id generator for PostgreSQL, using hashids
Stars: ✭ 164 (-94.57%)
Mutual labels:  database, postgresql, postgres
🦕 Deno REST framework/eco-system
Stars: ✭ 205 (-93.22%)
Mutual labels:  rest-api, rest, framework
Postgres Migrations
🐦 A Stack Overflow-inspired PostgreSQL migration library with strict ordering and immutable migrations
Stars: ✭ 161 (-94.67%)
Mutual labels:  database, postgresql, postgres
Npgsql is the .NET data provider for PostgreSQL.
Stars: ✭ 2,415 (-20.11%)
Mutual labels:  database, postgresql, postgres
Tds fdw
A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Stars: ✭ 238 (-92.13%)
Mutual labels:  hacktoberfest, postgresql, databases
🐘 Run PostgreSQL in Kubernetes
Stars: ✭ 205 (-93.22%)
Mutual labels:  database, postgresql, postgres


Build Status GoDoc Go Report Card codecov SourceLevel Homebrew Slack

pREST (PostgreSQL REST), simplify and accelerate development, instant, realtime, high-performance on any Postgres application, existing or new

PostgreSQL version 9.4 or higher

CLA assistant

pREST - instant, realtime, high-performance on PostgreSQL | Product Hunt


There is PostgREST written in Haskell, but keeping Haskell software in production is not an easy job. With this need pREST was born. Read more.

Test using Docker

To simplify the process of bringing up the test environment we will use docker-compose

# Download docker compose file
wget -O docker-compose.yml

# Up (run) PostgreSQL and prestd
docker-compose up
# Run data migration to create user structure for access (JWT)
docker-compose exec prest prestd migrate up auth

# Create user and password for API access (via JWT)
## user: prest
## pass: prest
docker-compose exec postgres psql -d prest -U prest -c "INSERT INTO prest_users (name, username, password) VALUES ('pREST Full Name', 'prest', MD5('prest'))"
# Check if the user was created successfully (by doing a select on the table)
docker-compose exec postgres psql -d prest -U prest -c "select * from prest_users"

# Generate JWT Token with user and password created
curl -i -X POST -H "Content-Type: application/json" -d '{"username": "prest", "password": "prest"}'
# Access endpoint using JWT Token
curl -i -X GET -H "Accept: application/json" -H "Authorization: Bearer {TOKEN}"

Want to contribute to the project and don't know where to start? See our contribution guide here.

1-Click Deploy


Deploy to Heroku and instantly get a realtime RESTFul API backed by Heroku Postgres:

Deploy to Heroku

Documentation (content source and template source)

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].