Hacker News Reader

Comment by dewey | Hacker News Reader

Similarly for Postgres, but without the spreadsheet part: https://github.com/PostgREST/postgrest

yeah, this is a key component of supabase (which you get out of the box if you host postgres with them).

I doubt I'll ever host postgres anywhere else but supabase at this point. The cost is competive with AWS/GCP but you get a ton of tools (like auth) built in.

And for GraphQL: https://www.graphile.org/postgraphile/

I want this exact thing for SQLite, nothing good exists

https://github.com/mevdschee/php-crud-api does not have the features you need?

Postgrest has excellent security setup, which is tightly integrated into postgres, I mean there are, by obvious design, no real paradigms for SQLite

https://github.com/jeffknupp/sandman2 works with many different backends including sqlite, but postgrest definitely have the auth flow and security model right for these things.

Anything compiled and not Python like Go, Rust etc.?

Founder of noco here.

We do support SQLite as well and it comes with litestream baked in within our docker.

https://pocketbase.io/

Seems very promising!

Seems most promising but the reply was to postgrest, because I really don't need a UI

Nocodb seems to create REST API endpoints for SQLite. Might be worth checking this project out.

Here it is =) https://github.com/wundergraph/wunderbase

No, still not there, but perhaps running in conjunction with that wundergraph API gateway will get me most of the way

But I also like the simplicity of just REST and feel like the postgrest people have figured that out

Reply on news.ycombinator.com