json VS postgrest

json

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

postgrest

• Prisma + ZenStack: An Alternative to PostgREST
  2 projects | dev.to | 24 Apr 2023

  Yes, you can! PostgREST is built exactly for that purpose. It turns a PostgreSQL database into a secure RESTful API, offering APIs like:

• Business Logic Inside Database - How Evil Is It?
  3 projects | dev.to | 17 Apr 2023

  But it doesn’t have to work this way. Some modern databases support a feature called "row-level security". It allows you to define access control policies at the row level based on the current user’s attributes (id, role, group membership, etc.). As long as the application can securely pass the current user’s identity to the database, it can leave all authorization checking to the database. And since the rules are defined at the table level instead of the API level, it has a much smaller surface to protect. The "row-level security" feature is the foundation of products like PostgREST, PostGraphile, and Supabase.

• Supabase Edge Runtime: Self-Hosted Deno Functions
  12 projects | news.ycombinator.com | 11 Apr 2023

  > Example: https://github.com/PostgREST/postgrest/issues/915

  12 projects | news.ycombinator.com | 11 Apr 2023

  I think this is great, but a growing question in my mind from these is what is the long tail plan for maintenance of this constellation of stuff? Especially because you guys are building on technologies that you can’t really just casually find developers for eg Elixir and Haskell. I keep seeing missing critical features in Realtime and Postgrest, and I know these are armies of 1-2, but it does kind of worry me when I think about investing time and effort into the Supabase ecosystem as a whole seeing more and more launches while there isn’t much action on existing issues.

  Example: https://github.com/PostgREST/postgrest/issues/915#issue-comm...

• Seeking Architectural Advice for a Report Automation Sytem Upgrade
  3 projects | reddit.com/r/ExperiencedDevs | 9 Apr 2023

  I don't vouch for this product, but it's open source so you can evaluate the implementation and maybe get ideas. it also sounds like it may be exactly what you need and is actively being developed (pushed a release 2 days ago) https://github.com/PostgREST/postgrest

• Three Ways to Secure Database APIs: Which Is Right for You?
  6 projects | dev.to | 3 Apr 2023

  Row-level security is the foundation for products like Supabase, Postgraphile, and PostgREST.

• is it a good idea to develop a database with direct rest API access??
  2 projects | reddit.com/r/rust | 21 Mar 2023
• Is a custom CMS a bad idea?
  2 projects | reddit.com/r/webdev | 20 Mar 2023

  wait till you find out https://github.com/PostgREST/postgrest.

• How to use Supabase RLS with third-party client library?
  2 projects | reddit.com/r/Supabase | 17 Feb 2023

  Yes that's exactly what I'm reading here and there. It seems to be the approach that Supabase is taking itself when receiving queries via their API gateway, powered by PostgREST. I had a look at the source code for the latter and it's basically converting the claims in the received JWT into as many local set_config() calls (basically a wrapper function around SET LOCAL). See this related discussion.

• 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