What does HackerNews think of postgraphile?

Alternatives are https://github.com/graphile/postgraphile or dgraph as you mentioned. Hasura is working on support for sqlite, so you may have some blockers there, you can also look into the Prisma engine which has GQL as an intermediate (for resolvers, for example)

Did you think about integrating Postgraphile with the Supabase ecosystem or have specific limitations with it?

Thanks!

Here's an active project that does something similar (introspects your postgres schema and runs a graphql API on top): https://github.com/graphile/postgraphile

Prisma is also interesting (but pulls more logic out of the DB).

My question with this type of logic-in-the-DB framework is how people are managing schema migrations and what infra they're running on as it's clearly a little less charted than, for instance, deploying a rails app (what I know). I really like the DRYness of writing the schema in one place and having that flow automatically into strongly typed models, API, etc with correct auth logix. This always seems like too much boilerplate with ActiveRecord and controllers.

It's like Hasura but written in a language you can understand.

Using it with great success on two projects, both > 3 months into development on.

https://github.com/graphile/postgraphile