GraphQL vs PostGraphile

Need advice about which tool to choose?Ask the StackShare community!

GraphQL

29.5K
24.9K
+ 1
300
PostGraphile

84
208
+ 1
47
Add tool

GraphQL vs PostGraphile: What are the differences?

GraphQL: A data query language and runtime. GraphQL is a data query language and runtime designed and used at Facebook to request and deliver data to mobile and web apps since 2012; PostGraphile: Instant GraphQL API for your PostgreSQL database; use standalone or as a Node.js middleware; MIT-licensed OSS. Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database.

GraphQL and PostGraphile belong to "Query Languages" category of the tech stack.

Some of the features offered by GraphQL are:

  • Hierarchical
  • Product-centric
  • Client-specified queries

On the other hand, PostGraphile provides the following key features:

  • instant GraphQL schema via reflection over PostgreSQL database API
  • compiles complex GraphQL queries into very few SQL statements resulting in high performance
  • built entirely from plugins - heavily customisable

GraphQL and PostGraphile are both open source tools. GraphQL with 11.7K GitHub stars and 753 forks on GitHub appears to be more popular than PostGraphile with 7.49K GitHub stars and 364 GitHub forks.

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of GraphQL
Pros of PostGraphile
  • 74
    Schemas defined by the requests made by the user
  • 62
    Will replace RESTful interfaces
  • 60
    The future of API's
  • 48
    The future of databases
  • 12
    Self-documenting
  • 11
    Get many resources in a single request
  • 5
    Query Language
  • 5
    Ask for what you need, get exactly that
  • 3
    Fetch different resources in one request
  • 3
    Evolve your API without versions
  • 3
    Type system
  • 2
    Easy setup
  • 2
    GraphiQL
  • 2
    Ease of client creation
  • 1
    Good for apps that query at build time. (SSR/Gatsby)
  • 1
    Backed by Facebook
  • 1
    Easy to learn
  • 1
    "Open" document
  • 1
    Better versioning
  • 1
    Standard
  • 1
    1. Describe your data
  • 1
    Fast prototyping
  • 10
    Postgres based authentication
  • 6
    Great developer support
  • 5
    Lightning fast
  • 5
    Database first with no braking changes
  • 4
    Simple to set up and scale
  • 4
    Bye bye Resolvers
  • 3
    Back to database first
  • 3
    9 Automatically generates your GraphQL schema
  • 3
    Easy setup of relationships and permissions
  • 3
    Instant production ready GraphQL
  • 1
    Works with new and existing databases

Sign up to add or upvote prosMake informed product decisions

Cons of GraphQL
Cons of PostGraphile
  • 4
    Hard to migrate from GraphQL to another technology
  • 4
    More code to type.
  • 2
    Takes longer to build compared to schemaless.
  • 1
    All the pros sound like NFT pitches
  • 1
    Works just like any other API at runtime
    Be the first to leave a con

    Sign up to add or upvote consMake informed product decisions

    - No public GitHub repository available -

    What is GraphQL?

    GraphQL is a data query language and runtime designed and used at Facebook to request and deliver data to mobile and web apps since 2012.

    What is PostGraphile?

    Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database

    Need advice about which tool to choose?Ask the StackShare community!

    What companies use GraphQL?
    What companies use PostGraphile?
    See which teams inside your own company are using GraphQL or PostGraphile.
    Sign up for StackShare EnterpriseLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with GraphQL?
    What tools integrate with PostGraphile?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    Blog Posts

    GitHubDockerReact+17
    35
    34340
    GitHubPythonNode.js+47
    53
    71238
    What are some alternatives to GraphQL and PostGraphile?
    gRPC
    gRPC is a modern open source high performance RPC framework that can run in any environment. It can efficiently connect services in and across data centers with pluggable support for load balancing, tracing, health checking...
    Falcor
    Falcor lets you represent all your remote data sources as a single domain model via a virtual JSON graph. You code the same way no matter where the data is, whether in memory on the client or over the network on the server.
    React
    Lots of people use React as the V in MVC. Since React makes no assumptions about the rest of your technology stack, it's easy to try it out on a small feature in an existing project.
    graphql.js
    Lightest GraphQL client with intelligent features. You can download graphql.js directly, or you can use Bower or NPM.
    MongoDB
    MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
    See all alternatives