Software Alternatives, Accelerators & Startups

PostGraphQL VS JsonAPI

Compare PostGraphQL VS JsonAPI and see what are their differences

Note: These products don't have any matching categories. If you think this is a mistake, please edit the details of one of the products and suggest appropriate categories.

PostGraphQL logo PostGraphQL

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

JsonAPI logo JsonAPI

Application and Data, Languages & Frameworks, and Query Languages
  • PostGraphQL Landing page
    Landing page //
    2023-08-04
  • JsonAPI Landing page
    Landing page //
    2022-11-21

PostGraphQL features and specs

No features have been listed yet.

JsonAPI features and specs

  • Standardization
    JSON:API provides a standardized format for building APIs, which promotes consistency and interoperability between different APIs.
  • Efficiency
    It supports features like sparse fieldsets, compound documents, and included relationships which help in reducing the amount of data transferred and improving response times.
  • Decoupling
    JSON:API encourages a clear separation between client and server, allowing them to evolve independently as long as they adhere to the specification.
  • Error Handling
    It has a well-defined error format that makes it easier for clients to understand what went wrong and how to fix it.
  • Community and Tooling
    A growing community and increasing tooling support make it easier to implement JSON:API in various server-side and client-side technologies.

Possible disadvantages of JsonAPI

  • Complexity
    The specification can be complex and may introduce a learning curve for developers who are new to it or used to simpler REST approaches.
  • Overhead
    Strict adherence to the JSON:API specification can sometimes introduce additional overhead in terms of implementation effort, especially for small projects.
  • Flexibility
    While the standardization is beneficial, it can reduce flexibility in scenarios where a more customized or optimized solution is needed.
  • Adoption
    Although growing, JSON:API is not as widely adopted as other conventions like simple REST, and thus some developers and projects might resist switching to it.
  • Resource Intensive
    Some features of JSON:API, like relationship links and included resources, can become resource-intensive for the server if not implemented carefully.

Category Popularity

0-100% (relative to PostGraphQL and JsonAPI)
Javascript UI Libraries
100 100%
0% 0
Development
0 0%
100% 100
Developer Tools
27 27%
73% 73
API Tools
0 0%
100% 100

User comments

Share your experience with using PostGraphQL and JsonAPI. For example, how are they different and which one is better?
Log in or Post with

Social recommendations and mentions

Based on our record, JsonAPI should be more popular than PostGraphQL. It has been mentiond 49 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.

PostGraphQL mentions (10)

  • Best Orm that uses Graphql and Postgres
    If you point is to abstract all the CRUD/GraphQL application, Go isn’t needed. You can go with PostgREST or Postgraphile. Source: over 2 years ago
  • Ask HN: Locally generate GraphQL schema and resolvers from DB
    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 / over 2 years ago
  • Supabase (YC S20) raises $80M Series B
    I've personally found Postgraphile to be fantastic. Nicer to use than Hasura and fully OSS: https://github.com/graphile/postgraphile/. - Source: Hacker News / almost 3 years ago
  • GraphQL is now available on Supabase
    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 / about 3 years ago
  • Are there actually better alternatives than Apollo server?
    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
View more

JsonAPI mentions (49)

  • OSF API: The Complete Guide
    Built on JSON API standards, the OSF API is intuitive for anyone familiar with REST conventions. Once you learn its core patterns, you can quickly expand into project creation, user collaboration, and more—without constantly referencing documentation. The official OSF API docs provide everything needed to get started. - Source: dev.to / 9 days ago
  • Common Mistakes in RESTful API Design
    Following established patterns reduces the learning curve for your API. Adopt conventions from JSON:API or Microsoft API Guidelines to provide consistent experiences. - Source: dev.to / about 1 month ago
  • Starting the Console front-end for Rainbow Platform
    I’ve used both GraphQL and REST in the past. From json:api to Relay, each approach for building APIs has its pros and cons. However, a constant challenge is choosing between code-first and schema-first approaches. - Source: dev.to / 6 months ago
  • REST API: Best practices and design
    There is a group of people who set out to standardize JSON responses into a single response style, either for returning single or multiple resources. You can take their style as a reference when designing their API to ensure uniformity of responses. - Source: dev.to / 12 months ago
  • Path To A Clean(er) React Architecture - Domain Entities & DTOs
    The server seems to be using the popular JSON:API standard which is a great way to build APIs. But should we really use these data structures in the frontend? - Source: dev.to / 11 months ago
View more

What are some alternatives?

When comparing PostGraphQL and JsonAPI, you can also consider the following products

React.run - Quick in-browser prototyping for React Components!

ReqRes - A hosted REST-API ready to respond to your AJAX requests.

graphql-yoga - 🧘 Fully-featured GraphQL Server with focus on easy setup, performance & great developer experience - prisma-labs/graphql-yoga

JSON Placeholder - JSON Placeholder is a modern platform that provides you online REST API, which you can instantly use whenever you need any fake data.

Observable - Interactive code examples/posts

OData - OData, short for Open Data Protocol, is an open protocol to allow the creation and consumption of queryable and interoperable RESTful APIs in a simple and standard way.