Postgrest Alternatives

Reviews and mentions

• Realtime Postgres RLS Now Available on Supabase (YC S20)
  4 projects | news.ycombinator.com | 1 Dec 2021

  Of course this is PostgREST-specific, only when going through it you'd enforce this condition.

  [1]: https://github.com/PostgREST/postgrest/issues/2028

• Lightweight Dev Solutions
  1 project | reddit.com/r/softwaredevelopment | 30 Nov 2021

  Postgrest (a front-end to postgresql) can automatically turn your database into an api you can call. So you will need to write sql, and a front-end but hopefully nothing else.

• User Authentication in Next.js with Supabase
  7 projects | dev.to | 23 Nov 2021

  @supabase/postgrest-js for PostgREST (REST API for PostgreSQL)

• Please I need ASAP help on connecting a flutter web app to a python-run PostgreSQL database
  2 projects | reddit.com/r/PostgreSQL | 29 Oct 2021

  I've been able to use postgrest to provide an API for a flutter app. I used Keycloak for logging in and providing the json web token to the flutter app that postgrest then accepts. I think (but can't remember for sure) that it was this auth0 with flutter article I used, with small modifications to connect to Keycloak. I recall discovering a few design flaws with the approach, but I don't remember what they were. I was able to modify it to my satisfaction.

• What libraries/frameworks are you using with SvelteKit to connect to the database and other stuff?
  2 projects | reddit.com/r/sveltejs | 27 Oct 2021

  I was gravitating towards PostgREST, which is also open source.

• What backend to use for Vue?
  2 projects | reddit.com/r/vuejs | 26 Oct 2021
• Can we trust Microsoft with Open Source?
  11 projects | news.ycombinator.com | 23 Oct 2021

  That's not true, for example in PostgREST we setup a nix-shell[1] that allows us to run tests in different PostgreSQL versions(from 9.6 to 14).

  [1]: https://github.com/PostgREST/postgrest/tree/main/nix#working...

• Timescale Announces New Database Cloud
  5 projects | news.ycombinator.com | 5 Oct 2021
• PostgreSQL 14 Released
  14 projects | news.ycombinator.com | 30 Sep 2021

  [supabase cofounder] While we position ourselves as a Firebase alternative, it might be simpler for experienced techies to think of us as an easy way to use Postgres.

  We give you a full PG database for every project, and auto-generated APIs using PostgREST [0]. We configure everything in your project so that it's easy to use Postgres Row Level Security.

  As OP mentions, we also provide a few additional services that you typically need when building a product - connection pooling (pgbouncer) object storage, authentication + user management, dashboards, reports, etc. You don't need to use all of these - you can just use us as a "DBaaS" too.

  [0] https://postgrest.org/

• An Ideal Data-Model-First Development Approach for the real-world apps
  3 projects | reddit.com/r/haskell | 11 Sep 2021

  For prior art in the 'make a quick CRUD app' space, I'd check out https://postgrest.org/ and https://ihp.digitallyinduced.com/, not that I've gotten around to trying either of them.

• Can't decide on a backend
  4 projects | reddit.com/r/reactnative | 10 Sep 2021

  Anyways, I'm not sure about services you could use that "just work". There are things like https://postgrest.org/ that take an existing db and just generate a rest API for it, but it still requires some learning and documentation digging to make sure it's secure. I also like the "postgraphile" project which does the same thing but with a graphql api instead of a rest one.

• Thick Databases
  6 projects | dev.to | 2 Sep 2021

  If my objections were on point, then automatic API solutions should be unusable or burdensome nightmares for any serious project. Clearly, however, people do use them, and such popularity is evidence that my objections must not be so serious as I suppose. Having spent some time now looking into them, that has turned out right -- in which circumstances a thick database is the best option I'm still undecided, but I'm certainly more open to leaning more heavily on the database. The catalyst for my change in attitude towards the maxim "no business logic in the database" came from looking at PostgREST and asking myself, "if it's such a bad idea to do things this way, what do people find appealing about solutions like PostgREST?" As I often do, I like to read hackernews posts on technology to see what people with (often deep) experience have to say. On there, I saw many of the same concerns I held myself repeated by others, as well as responses I hadn't previously considered.

• Auto generating API schema code?
  5 projects | reddit.com/r/PostgreSQL | 29 Aug 2021
• Ask HN: Good Postgres Book(s)?
  3 projects | news.ycombinator.com | 11 Aug 2021

  — Brian

  1. https://postgrest.org/

• What’s the best technology to learn along with Flutter?
  4 projects | reddit.com/r/FlutterDev | 4 Aug 2021

  You should check https://postgrest.org . It exposes a postgres database as a REST webservice.