postgrest VS json

Compare postgrest vs json and see what are their differences.

json

Haskell JSON library (by GaloisInc)
Our great sponsors
  • SonarLint - Clean code begins in your IDE with SonarLint
  • InfluxDB - Build time-series-based applications quickly and at scale.
  • SaaSHub - Software Alternatives and Reviews
postgrest json
72 0
19,992 26
1.7% -
8.9 0.0
5 days ago over 1 year ago
Haskell Haskell
MIT License BSD 3-clause "New" or "Revised" License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

postgrest

Posts with mentions or reviews of postgrest. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-01-29.
  • Can't link fresh project - problem with underlying postgrest version not supporting 15.
    2 projects | reddit.com/r/Supabase | 29 Jan 2023
    I suspect this is the culprit (might be wrong): https://github.com/PostgREST/postgrest/blob/main/src/PostgREST/Config/PgVersion.hs
  • Show HN: Rest – Instant RESTful API on Any SQL Database
    2 projects | news.ycombinator.com | 26 Jan 2023
    Pretty cool - wonder how it compares to Postgrest (https://postgrest.org/).

    Generally been a fan of these sorts of models - SQL data is very malleable - and treating the tables as movable from the start really helps move faster as a developer - database migrations become easier as you don't need to do a lot of work with API.

    I can see how this would cause problems if you always used this in production after finding a fit for the data model - but for rapid prototyping and development - big fan.

  • Architecture Pitfalls: Don’t use your ORM entities for everything β€” embrace the SQL!
    5 projects | reddit.com/r/programming | 12 Jan 2023
    Just as an addendum, the supabase.com team are bullish on the power and value of leaning heavily into the database. iirc, they're also the team behind postgREST which makes it easy to spin up a full REST API on the back of a PostgREST database. I used to think this kind of approach was a disaster, but I've changed my mind significantly. When being willing to use stored procedures, you can spin up this REST API, AND use the same stored procedures for your application as well, to ensure consistency of business logic, all without needing a separate business logic API middleware service between DB and the rest of the world. It's not all roses, but it is pretty amazing.
  • PostgREST – Serve a RESTful API from Any Postgres Database
    22 projects | news.ycombinator.com | 29 Dec 2022
    At work, we've finally replaced a large part of a custom (mostly-)web backend with PostgREST recently, and that's quite a relief: considerably less code to maintain in that project now, and that was a rather awkward code. Something akin to PostgREST's "Embedding with Top-level Filtering" [1] had to be provided for all the tables, with OpenAPI schema and a typed API (Haskell + Servant); I avoided manually writing it all down, but at the cost of poking framework internals, and maintainability suffered. It was particularly annoying that the code doesn't really do anything useful, except for standing between a database and an HTTP client, and simply mimics the database anyway. Whenever a change had to be introduced, it was introduced into the database, the backend, and the frontend simultaneously, so it wasn't even useful for some kind of compatibility.

    Now PostgREST handles all that, and only a few less trivial endpoints are handled by a custom backend (including streaming, which I'm considering replacing with postgrest-websocket [2] at some point).

    During the switch to PostgREST, the encountered minor issues were those with inherited tables (had to set a bunch of computed/virtual columns [3] in order to "embed" those), and with a bug on filtering using such relations (turned out it was an already-fixed regression [4], so an update helped). Also a couple of helper stored procedures (to use via /rpc/) for updates in multiple tables at once (many-to-many relationships, to edit entities along with their relationships, using fewer requests) were added (though the old custom backend didn't have that), the security policies were set from the beginning, the frontend was rewritten (which allowed to finally switch without adding more work), so it was only left to cleanup the backend.

    Not using views, since as mentioned above, database changes usually correspond to frontend changes, and the API doesn't have to be that stable yet.

    Happy with it so far.

    [1] https://postgrest.org/en/stable/api.html#embedding-with-top-...

    [2] https://github.com/diogob/postgres-websockets

    [3] https://postgrest.org/en/stable/api.html#computed-virtual-co...

    [4] https://github.com/PostgREST/postgrest/issues/2530

    22 projects | news.ycombinator.com | 29 Dec 2022
    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...

  • Looking for a boilerplate
    3 projects | reddit.com/r/SaaS | 25 Dec 2022
    I don't know for the stack you're looking for but is this close enough ? https://github.com/PostgREST/postgrest
  • Should I replace all db select query REST APIs with a single generic router ?
    3 projects | reddit.com/r/golang | 19 Dec 2022
    It's neither MySQL nor Go, but https://github.com/PostgREST/postgrest has figured out most of the patterns and API designs you could follow.
  • Just Use Postgres for Everything
    7 projects | news.ycombinator.com | 10 Dec 2022
    I love postgres for most things but these days (Especially while my product is in development, embedded, or just not internet-facing) sqlite is amazingly workable.

    Killer postgres features however: Row-level security (Amazing when you're using something like postgrest for rapid application development [1]), and its built in fulltext search engine is 'good enough' for use cases like when you have an enormous users table and need to index something simple enough, like email addresses for quick login.

    [1] https://postgrest.org/

  • A Poor Man's API
    7 projects | news.ycombinator.com | 28 Nov 2022
    To be fair, begriffs never shut down any discussion of HATEOAS, previous contributors did - because at the time users were asking for more JSON capabilities from PostgREST and we needed to focus on those.

    We're still open on adding HATEOAS, I've just opened an issue for it: https://github.com/PostgREST/postgrest/issues/2579

  • SQLGateway - Access SQL databases over HTTP - Written in Go πŸ’™
    3 projects | reddit.com/r/golang | 28 Nov 2022
    Interesting, I've only used PostgREST before, are you familiar with how they compare?

json

Posts with mentions or reviews of json. We have used some of these posts to build our list of alternatives and similar projects.

We haven't tracked posts mentioning json yet.
Tracking mentions began in Dec 2020.

What are some alternatives?

When comparing postgrest and json you can also consider the following projects:

Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.

supabase - The open source Firebase alternative. Follow to stay updated about our public Beta.

postgres-websockets - PostgreSQL + Websockets

Appwrite - Secure Backend Server for Web, Mobile & Flutter Developers πŸš€ AKA the 100% open-source Firebase alternative.

TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.

supabase-graphql-example - A HackerNews-like clone built with Supabase and pg_graphql

simpleconfig

gotrue - An SWT based API for managing users and issuing SWT tokens

swagger2 - Swagger 2.0 data model.

pg-transact - Another postgresql-simple transaction monad

markdown - Convert Markdown to HTML, with XSS protection

appsmith - Low code project to build admin panels, internal tools, and dashboards. Integrates with 15+ databases and any API.