PostGraphile vs Prisma vs graphql.js
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 | 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. | Lightest GraphQL client with intelligent features. You can download graphql.js directly, or you can use Bower or NPM. |
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 | Auto-generated and type-safe query builder for Node.js & TypeScript;
Declarative data modeling & migration system;
GUI to view and edit data in your database;
Single source of truth for database and application models;
Auto-completion in code editors instead of needing to look up documentation;
Less boilerplate so developers can focus on the important parts of their app;
Queries not classes to avoid complex model objects; | No dependencies, plain vanilla JavaScript.;Plug & Play.;Isomorphic.;Runs on most browsers.;You don't need to install Node.js ecosystem on your computer. |
Statistics | ||
GitHub Stars - | GitHub Stars 44.2K | GitHub Stars 2.3K |
GitHub Forks - | GitHub Forks 1.9K | GitHub Forks 88 |
Stacks 85 | Stacks 1.3K | Stacks 93 |
Followers 214 | Followers 974 | Followers 85 |
Votes 47 | Votes 55 | Votes 0 |
Pros & Cons | ||
Pros
| Pros
Cons
| No community feedback yet |
Integrations | ||
What are some alternatives to PostGraphile, Prisma, graphql.js?
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.
Sequelize
Sequelize is a promise-based ORM for Node.js and io.js. It supports the dialects PostgreSQL, MySQL, MariaDB, SQLite and MSSQL and features solid transaction support, relations, read replication and more.
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.
Hibernate
Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper.
Doctrine 2
Doctrine 2 sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL.
MikroORM
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.
Entity Framework
It is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write.
peewee
A small, expressive orm, written in python (2.6+, 3.2+), with built-in support for sqlite, mysql and postgresql and special extensions like hstore.
MyBatis
It is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings. It eliminates almost all of the JDBC code and manual setting of parameters and retrieval of results. It can use simple XML or Annotations for configuration and map primitives, Map interfaces and Java POJOs (Plain Old Java Objects) to database records.
Entity Framework Core
It is a lightweight, extensible, open source and cross-platform version of the popular Entity Framework data access technology. It can serve as an object-relational mapper (O/RM), enabling .NET developers to work with a database using .NET objects, and eliminating the need for most of the data-access code they usually need to write.
