Hacker News Reader

HNHacker News

Top New Best Ask Show Jobs

Comment by ggregoire | Hacker News Reader

Full thread

ggregoire·

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

Previous discussions on HN: https://hn.algolia.com/?q=postgrest

View on HN

Is there anything similar for Sqlite?

Yes. Search the table at https://github.com/dbohdan/automatic-api for "SQLite". Disclosure: this is my repository.

Don't overlook https://datasette.io/ even though it does much more than endpoints.

Exactly that (same api structure) https://docs.subzero.cloud/

Wow; this is extremely nice for quick prototyping!

I use it in production. Handling roles and permissions in the DB is a game changer.

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.

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?

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

Came here to mention Hasura as well (not sure of it's popularity though) https://hasura.io/graphql/database/postgresql

They do use it:

- https://supabase.com/docs/guides/api#rest-api-overview

- https://supabase.com/docs/guides/getting-started/architectur...

I would not recommend Hasura if you're on PostgreSQL.

Reply on news.ycombinator.com