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

GraphQL

26K
21.5K
+ 1
298
PostGraphile

80
190
+ 1
43
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
  • 73
    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
    Ask for what you need, get exactly that
  • 4
    Query Language
  • 3
    Evolve your API without versions
  • 3
    Fetch different resources in one request
  • 3
    Type system
  • 2
    GraphiQL
  • 2
    Ease of client creation
  • 2
    Easy setup
  • 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
    Database first with no braking changes
  • 5
    Lightning fast
  • 4
    Simple to set up and scale
  • 4
    Bye bye Resolvers
  • 2
    Instant production ready GraphQL
  • 2
    Back to database first
  • 2
    Easy setup of relationships and permissions
  • 2
    9 Automatically generates your GraphQL schema
  • 1
    Works with new and existing databases

Sign up to add or upvote prosMake informed product decisions

Cons of GraphQL
Cons of PostGraphile
  • 3
    Hard to migrate from GraphQL to another technology
  • 3
    More code to type.
  • 1
    All the pros sound like NFT pitches
  • 1
    Works just like any other API at runtime
  • 1
    Takes longer to build compared to schemaless.
    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
    32532
    GitHubPythonNode.js+47
    53
    70415
    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