Had a little trouble getting the installation to work because neon.tech roles can’t be created through the postgres connection, but created them by hand.
Hi! Thanks for trying it out. Indeed would be cool to support Postgraphile on top of Neon.
Hm, that query seems to come from graphile itself. Was you able to track down what is the reason for breakage? It could be that we don’t give enough privileges to postgres user. Does the same setup work on a standalone postgres with respective version? We support 14 and 15 for now and I see a lot of version-based conditionals in that query.
It was missing for example the info about function inputs, most of the functions were missing… It was a lot, so I just gave up. maybe it was something that is different with the privileges of the user.
postgraphile works fine on pg14 & pg15, use it in production on pg14. I tested 14 on Neon. I think those conditionals are to support older versions.
Adding another vote of support to get Postgraphile working with Neon. I am also stuck at the introspection query not working. For me it looked like functions were read but all of the tables were missing.
Postgraphile v5 in my experience is the most performant graphql API for postgres, and seems like a natural fit for Neon. I badly want to convert from GCP to Neon but the lack of Postgraphile integration is the last remaining blocker for me.
Hey @anesthetic, @psugihara, @xvaara. We recently shipped better support for roles and permissions. This makes it possible for you to use Postgraphile with Neon
If you run into any issues, feel free to reach out
