|
|
|
|
|
|
by alexkreidler
1550 days ago
|
|
|
Hi all, this sounds very cool. How does pg_graphql compare to Postgraphile? https://github.com/graphile/postgraphile (besides I guess running in the DB with PLpgSQL instead of as a NodeJS server) Did you think about integrating Postgraphile with the Supabase ecosystem or have specific limitations with it? Thanks! |
|
|
PostGraphile is very close to pg_graphql in goals. It was a big help during development to be able to reference their implementation.
> Did you think about integrating Postgraphile with the Supabase ecosystem..?
For sure! We wrote a blog post about why we chose to implement the reflection engine as a Postgres extension here https://supabase.com/blog/2021/12/03/pg-graphql w/ a direct comparison against Postgraphile and Hasura.
The summary is that we tried out Graphile and Hasura and found that they were both very workable options. We had a few other requirements that led us to the extension instead:
- An extremely minimal memory footprint
- Performance scales with the DB
- 100% security and visibility interop with PostgREST (powers Supabase REST API)
The blog post's "motivation" has some more specifics if you're interested!