5 ms·

Turn your Postgres database into a REST API: https://postgrest.org https://postgrest.org Previous discussions on HN: https://hn.algolia.com/?q=postgrest https:

• nunez 3y ago
  Wow; this is extremely nice for quick prototyping!
  • ggregoire 3y ago
    I use it in production. Handling roles and permissions in the DB is a game changer.
    • mickeyp 3y ago
      But beware row-level security. It's great, but the query planning is a huge mess, and you can end up with serious performance issues real fast if you're not careful.
      • dventimi 3y ago
        My understanding, perhaps flawed, is that row security policies add predicates to the SQL, which then encounters the query planner like any other. Is this not the case?
• disqard 3y ago
  Is there anything similar for Sqlite?
  • networked 3y ago
    Yes. Search the table at https://github.com/dbohdan/automatic-api https://github.com/dbohdan/automatic-api for "SQLite". Disclosure: this is my repository.
  • chrsstrm 3y ago
    Don't overlook https://datasette.io/ https://datasette.io/ even though it does much more than endpoints.
  • ruslan_talpa 3y ago
    Exactly that (same api structure) https://docs.subzero.cloud/ https://docs.subzero.cloud/
• foobazzy 3y ago
  At one point, I really thought it was used in Supabase. But I guess they only wrote the js wrapper for it. https://github.com/supabase/postgrest-js https://github.com/supabase/postgrest-js Came here to mention Hasura as well (not sure of it's popularity though) https://hasura.io/graphql/database/postgresql https://hasura.io/graphql/database/postgresql
  • steve-chavez 3y ago
    They do use it: - https://supabase.com/docs/guides/api#rest-api-overview https://supabase.com/docs/guides/api#rest-api-overview - https://supabase.com/docs/guides/getting-started/architecture#architecture https://supabase.com/docs/guides/getting-started/architectur...
  • dventimi 3y ago
    I would not recommend Hasura if you're on PostgreSQL.