PostGraphile vs Preql

Overview

PostGraphile

Stacks85

Followers214

Votes47

Preql

Stacks1

Followers6

Votes0

GitHub Stars625

Forks13

🔥 Trending in Languages on StackShare

JavaScript Languages

Lightweight, interpreted, object-oriented language with first-class functions

Try it View Docs Alternatives

Try

499

284k

Detailed Comparison

PostGraphile	Preql
Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database	It is an interpreted, relational programming language, that specializes in database queries. It is designed for use by data engineers, analysts and data scientists.
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	Modern syntax and semantics; Compiles to SQL; Python and Pandas integration; Interactive shell (REPL) with auto-completion; Runs on Jupyter Notebook
Statistics
GitHub Stars -	GitHub Stars 625
GitHub Forks -	GitHub Forks 13
Stacks 85	Stacks 1
Followers 214	Followers 6
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	Python Google BigQuery PostgreSQL MySQL SQLite Pandas

What are some alternatives to PostGraphile, Preql?

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.