JSONiq vs PostGraphile
Overview
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.
CLI (Node.js)
Manual
Detailed Comparison
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
| No community feedback yet |
Integrations | |
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.
GraphQL Ruby
Get going fast with the graphql gem, battle-tested and trusted by GitHub and Shopify.
