webapp VS postgrest

webapp

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

postgrest

• Ask HN: What are some unpopular technologies you wish people knew more about?
  56 projects | news.ycombinator.com | 2 Dec 2023

  Turn your Postgres database into a REST API: https://postgrest.org

• Production REST API Infrastructure
  2 projects | /r/webdev | 18 Jun 2023
• Sketch of a Post-ORM
  14 projects | news.ycombinator.com | 2 Jun 2023

  The OP didn't write about a UI and we don't know what their needs are, so for all we know they're writing a Python-based back-end API in REST or GraphQL which is being consumed by a mobile UI or a SPA UI in Reactor or Vue.js or whatever, such that that back-end API doesn't have to provide a UI. If the existing Python back-end doesn't provide a UI then any proposed substitute--including one in SQL--shouldn't have to provide a UI either, just an API. In that case, there are some ready-made solutions already available:

  - PostgREST (https://postgrest.org/): REST API for PostgreSQL

• 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 | /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 | /r/rust | 21 Mar 2023