PostgREST – Serve a RESTful API from Any Postgres Database

1. django-rest-framework

   1 209 29,222 8.3 Python

   Web APIs for Django. 🎸

   

2. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

3. postgrest

   2 112 25,417 9.6 Haskell

   REST API for any Postgres database

   

   For how often Nix is mentioned here on HackerNews, has anybody looked at the Nix config files for this repo to build it locally?

   https://github.com/PostgREST/postgrest/blob/main/cabal.proje...

4. pocketbase

   3 217 47,868 9.7 Go

   Open Source realtime backend in 1 file

   

   Absolutely love pocketbase.

   And, interesting to note that using stored procedures within pocketbase isn't well supported because they do a dry run insert to check against constraints and then delete it if the constant fails.

   https://github.com/pocketbase/pocketbase/discussions/650#dis...

   I mention this because the OP inquired about stored procedures.

   Still, pocketbase is so amazing.

5. react-admin

   4 71 25,939 10.0 TypeScript

   A frontend Framework for single-page applications on top of REST/GraphQL APIs, using TypeScript, React and Material Design

   

   1 year ago: https://news.ycombinator.com/item?id=29389576

   It's an insanely cool project, but I've yet to find a truly fitting use case for it. In theory, PostgREST combined with something like https://marmelab.com/react-admin/ should give you a free back-end and admin panel for most projects, but in practice, I've always found that all kinds of 'small details' won't be quite right out of the box, and that customization is really hard...

6. graphile-engine

   5 7 762 5.6 JavaScript

   Monorepo home of graphile-build, graphile-build-pg, graphile-utils, postgraphile-core and graphql-parse-resolve-info. Build a high-performance easily-extensible GraphQL schema by combining plugins!

   

7. crystal

   6 28 12,745 10.0 TypeScript

   🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more! (by graphile)

   

   I was about to say “but this one is!” and realized I had confused PostgREST with PostGraphile. If you’re interested in GraphQL, you can check out PostGraphile here: https://github.com/graphile/postgraphile

8. Directus

   7 227 30,963 9.9 TypeScript

   The flexible backend for all your projects 🐰 Turn your DB into a headless CMS, admin panels, or apps with a custom UI, instant APIs, auth & more.

   

   Directus is actually one. You get the front end which is basically an admin UI, but you also get a full blown fully featured REST API

   https://directus.io/

9. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

10. auth

    8 46 1,959 9.3 Go

    A JWT based API for managing users and issuing JWT tokens (by supabase)

    

    we integrated Gotrue with PostgREST at Supabase and it works beautifully together https://github.com/supabase/gotrue (forked from Netlify)

11. postgresql-replicant

    9 5 39 3.2 Haskell

    A streaming PostgreSQL logical replication client library for Haskell

    

    You can use a library like https://github.com/agentultra/postgresql-replicant or similar to hook in a data plane and use PostgREST as a data plane.

    Your business logic works on the event stream that comes from the WAL.

12. postgrest-starter-kit

    10 3 710 0.0 PLpgSQL

    Discontinued Starter Kit and tooling for authoring REST API backends with PostgREST

    

    I think the recommended way to use Postgrest is to put a layer of views and optionally stored functions on top of your schema to decouple it from your API. Take a look at this Postgrest starter kit[1] which uses a separate API schema for this purpose.

    [1] https://github.com/subzerocloud/postgrest-starter-kit

13. postgres-websockets

    11 1 382 6.4 Haskell

    PostgreSQL + Websockets

    

14. roapi

    12 27 3,313 7.9 Rust

    Create full-fledged APIs for slowly moving datasets without writing a single line of code.

    

    > why not just accept SQL and cut out all the unnecessary mapping?

    You might be interested in what we're building: Seafowl, a database designed for running analytical SQL queries straight from the user's browser, with HTTP CDN-friendly caching [0]. It's a second iteration of the Splitgraph DDN [1] which we built on top of PostgreSQL (Seafowl is much faster for this use case, since it's based on Apache DataFusion + Parquet).

    The tradeoff for allowing the client to run any SQL vs a limited API is that PostgREST-style queries have a fairly predictable and low overhead, but aren't as powerful as fully-fledged SQL with aggregations, joins, window functions and CTEs, which have their uses in interactive dashboards to reduce the amount of data that has to be processed on the client.

    There's also ROAPI [2] which is a read-only SQL API that you can deploy in front of a database / other data source (though in case of using databases as a data source, it's only for tables that fit in memory).

    [0] https://seafowl.io/

    [1] https://www.splitgraph.com/connect

    [2] https://github.com/roapi/roapi

15. seafowl

    13 11 484 9.5 Rust

    Analytical database for data-driven Web applications 🪶

    

    > why not just accept SQL and cut out all the unnecessary mapping?

    You might be interested in what we're building: Seafowl, a database designed for running analytical SQL queries straight from the user's browser, with HTTP CDN-friendly caching [0]. It's a second iteration of the Splitgraph DDN [1] which we built on top of PostgreSQL (Seafowl is much faster for this use case, since it's based on Apache DataFusion + Parquet).

    The tradeoff for allowing the client to run any SQL vs a limited API is that PostgREST-style queries have a fairly predictable and low overhead, but aren't as powerful as fully-fledged SQL with aggregations, joins, window functions and CTEs, which have their uses in interactive dashboards to reduce the amount of data that has to be processed on the client.

    There's also ROAPI [2] which is a read-only SQL API that you can deploy in front of a database / other data source (though in case of using databases as a data source, it's only for tables that fit in memory).

    [0] https://seafowl.io/

    [1] https://www.splitgraph.com/connect

    [2] https://github.com/roapi/roapi

16. nix

    14 412 14,515 10.0 C++

    Nix, the purely functional package manager

    

    https://github.com/PostgREST/postgrest/tree/main/nix

    I couldn't for the life of me figure out how to play with this. I kind of don't believe "docker build ." is worse but I might be missing something.

    After I ejected out of playing with it on Mac OS, I found: https://github.com/NixOS/nix/issues/458#issuecomment-1019743...

    Over 13 parts to remove NixOS from Mac OS, involving reboots, /etc/fstab, OS level users, daemons, etc.

17. annuaire-entreprises-sirene-api

    15 1 18 10.0 Shell

    

    One of the project which list all the data for entreprise addresses uses Postgrest (open data SIRENE de l'INSEE).

    Full fledge project implemented, interesting use of PostgREST

    https://github.com/etalab/annuaire-entreprises-sirene-api

18. datasette

    16 198 10,132 8.2 Python

    An open source multi-tool for exploring and publishing data

    

19. pREST

    17 15 4,360 6.3 Go

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

    

    Pretty sure I started with this: https://github.com/prest/prest/blob/main/cmd/root.go

    And from there you can execute your own command and add handlers or other things as you wish.

20. SQLAlchemy

    18 138 10,568 9.7 Python

    The Database Toolkit for Python

    

21. showcase

    19 13 162 4.1 TypeScript

    Discontinued REST api for your database (PostgreSQL/Sqlite/ClickHouse/MySQL). [GET https://api.github.com/repos/subzerocloud/showcase: 404 - Not Found // See: https://docs.github.com/rest]

    

    Soon (in the works now, it will be particularly interesting in the context of cloudflare workers talking to planetscale)

    https://github.com/subzerocloud/showcase

22. SaaSHub

    www.saashub.com featured

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    

Suggest a related project