Automatic Schema Generation
PostGraphQL automatically generates a GraphQL schema based on the structure and relationships within your PostgreSQL database, reducing the need for manual schema definition and maintenance.
Efficiency
By leveraging PostgreSQL functions, PostGraphQL can efficiently execute complex queries directly within the database, leading to potentially faster query performance.
Consistent API
The tool ensures a consistent and predictable API is generated from the database schema, which can simplify client-side development and integration.
Support for PostgreSQL Features
PostGraphQL takes advantage of PostgreSQL's advanced features such as triggers, views, and stored procedures, allowing for rich and powerful API capabilities.
We have collected here some useful links to help you find out if PostGraphQL is good.
Check the traffic stats of PostGraphQL on SimilarWeb. The key metrics to look for are: monthly visits, average visit duration, pages per visit, and traffic by country. Moreoever, check the traffic sources. For example "Direct" traffic is a good sign.
Check the "Domain Rating" of PostGraphQL on Ahrefs. The domain rating is a measure of the strength of a website's backlink profile on a scale from 0 to 100. It shows the strength of PostGraphQL's backlink profile compared to the other websites. In most cases a domain rating of 60+ is considered good and 70+ is considered very good.
Check the "Domain Authority" of PostGraphQL on MOZ. A website's domain authority (DA) is a search engine ranking score that predicts how well a website will rank on search engine result pages (SERPs). It is based on a 100-point logarithmic scale, with higher scores corresponding to a greater likelihood of ranking. This is another useful metric to check if a website is good.
The latest comments about PostGraphQL on Reddit. This can help you find out how popualr the product is and what people think about it.
If you point is to abstract all the CRUD/GraphQL application, Go isn’t needed. You can go with PostgREST or Postgraphile. Source: almost 3 years ago
What do you mean locally? Hasura is OSS, and you can run it locally (you have autogenerated SQL statements) Here you can just use Nhost and its CLI; 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). - Source: Hacker News / almost 3 years ago
I've personally found Postgraphile to be fantastic. Nicer to use than Hasura and fully OSS: https://github.com/graphile/postgraphile/. - Source: Hacker News / over 3 years 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! - Source: Hacker News / over 3 years ago
If you’re open to learning Postgres, I’d recommend postgraphile (https://github.com/graphile/postgraphile). Been using it for the past 2.5 years and only have good things to say. Source: over 3 years ago
Both Postgraphile and Hasura generate SQL queries according to GraphQL. Anyone tried to implement a such GQL engine using Rust? What libs could come in handly when implementing a such thing? Source: over 3 years ago
I do not think graphql is a over engineered either, things like Postgraphile, Hasura will save lot of time when it comes to back-ends, even speed up the front-end since not having to wait for back-end devs to setup new API endpoints. Source: almost 4 years ago
Give that this project looks dead, you should look into Hasura, or postgraphile. Source: almost 4 years ago
This is cool but sadly looks abandoned. 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... - Source: Hacker News / almost 4 years ago
Also, if you mention Node and graphql, I feel like I need to tell you about https://github.com/graphile/postgraphile Great project, great vision, awesome maintainer. Source: about 4 years ago
Do you know an article comparing PostGraphQL to other products?
Suggest a link to a post with product alternatives.
Is PostGraphQL good? This is an informative page that will help you find out. Moreover, you can review and discuss PostGraphQL here. The primary details have not been verified within the last quarter, and they might be outdated. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.
