PostGraphile vs JSONiq

Overview

PostGraphile

Stacks85

Followers214

Votes47

JSONiq

Stacks14

Followers4

Votes0

PostGraphile vs JSONiq: What are the differences?

What is 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.

What is JSONiq? A query and processing language specifically designed for the popular JSON data model. It is a query and processing language specifically designed for the popular JSON data model. It is an expressive and highly optimizable language to query and update NoSQL stores. It enables developers to leverage the same productive high-level language across a variety of NoSQL products.

PostGraphile and JSONiq can be primarily classified as "Query Languages" tools.

Some of the features offered by PostGraphile are:

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

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

Complex Processing
Decades of Lessons Learnt
Expressive and highly optimizable language to query and update NoSQL stores

PostGraphile is an open source tool with 8.06K GitHub stars and 397 GitHub forks. Here's a link to PostGraphile's open source repository on GitHub.

Share your Stack

Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.

View Docs

CLI (Node.js)

or

Manual

Detailed Comparison

PostGraphile	JSONiq
Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database	It is a query and processing language specifically designed for the popular JSON data model. It is an expressive and highly optimizable language to query and update NoSQL stores. It enables developers to leverage the same productive high-level language across a variety of NoSQL products.
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; support for PostgreSQL RBAC and RLS; watch mode (monitors for database schema changes) for great DX; standalone server, express middleware, or GraphQL schema; integration with Express auth via pgSettings (e.g. Passport.js, optional); JWT auth (optional); very strong support for PostgreSQL functions; simple to set up and scale	Complex Processing; Decades of Lessons Learnt; Expressive and highly optimizable language to query and update NoSQL stores; Stable and maintained
Statistics
Stacks 85	Stacks 14
Followers 214	Followers 4
Votes 47	Votes 0
Pros & Cons
Pros 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	No community feedback yet
Integrations
Apollo ExpressJS Node.js PostgreSQL Koa GraphQL Fastify Relay Framework graphql.js	JSON

What are some alternatives to PostGraphile, JSONiq?

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.

Prisma

Prisma is an open-source database toolkit. It replaces traditional ORMs and makes database access easy with an auto-generated query builder for TypeScript & Node.js.

OData

It is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. It helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request and response headers, status codes, HTTP methods, URL conventions, media types, payload formats, query options, etc.

Oracle PL/SQL

It is a powerful, yet straightforward database programming language. It is easy to both write and read, and comes packed with lots of out-of-the-box optimizations and security features.

SQL

SQL is designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

Graphene

Graphene is a Python library for building GraphQL schemas/types fast and easily.

JSON API

It is most widely used data format for data interchange on the web. This data interchange can happen between two computers applications at different geographical locations or running within same hardware machine.

graphql.js

Lightest GraphQL client with intelligent features. You can download graphql.js directly, or you can use Bower or NPM.

JsonAPI

t is a format that works with HTTP. A main goal of the specification is to optimize HTTP requests both in terms of the number of requests and the size of data packages exchanged between clients and servers.