Prisma vs graphql-yoga

Overview

Prisma

Stacks1.3K

Followers974

Votes55

GitHub Stars44.2K

Forks1.9K

graphql-yoga

Stacks99

Followers144

Votes3

Prisma vs graphql-yoga: What are the differences?

ORM vs. Server Library: Prisma is primarily an ORM (Object-Relational Mapping) tool that provides a query builder and database client, enabling developers to interact with databases easily. On the other hand, graphql-yoga is a server library that helps in creating a GraphQL server with various features like schema generation, resolvers, and Middleware.
Database Integration: Prisma integrates with databases directly by generating a client that communicates with the database. It abstracts away the database layer and provides a type-safe API for database operations. In contrast, graphql-yoga allows developers to integrate any database of their choice by writing custom resolvers to handle data fetching and manipulation.
Development Focus: Prisma focuses on simplifying database access and management, providing tools for data modeling, migrations, and advanced queries. It is more suitable for projects that heavily rely on database operations. On the other hand, graphql-yoga is focused on building GraphQL APIs and managing server-side logic with features like subscriptions, data loaders, and error handling.
Server Environment: Prisma requires a separate server environment to run queries and interact with databases, making it suitable for backend applications. In contrast, graphql-yoga can be used for both frontend and backend development as it is responsible for handling GraphQL requests and responses on the server-side.
Community Support: Prisma has a growing community of developers that contribute to its development and provide support through forums, documentation, and tutorials. graphql-yoga, being built on top of popular libraries like Express and Apollo Server, benefits from the vast community of these tools, providing extensive resources for troubleshooting and development.
Ease of Use: Prisma simplifies database operations with its type-safe API, query builder, and schema migrations, making it easier for developers to work with databases. graphql-yoga, with its declarative approach to defining schemas and resolvers, simplifies the process of creating a GraphQL server with minimal boilerplate code, enhancing developer productivity.

In Summary, Prisma is primarily focused on database access and management through an ORM approach, while graphql-yoga specializes in building GraphQL servers with features like schema generation and resolvers, catering to different aspects of GraphQL development.

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)

Manual

Advice on Prisma, graphql-yoga

Taylor

May 5, 2020

Review

Hey guys,

My backend set up is Prisma / GraphQL-Yoga at the moment, and I love it. It's so intuitive to learn and is really neat on the frontend too, however, there were a few gotchas when I was learning! Especially around understanding how it all pieces together (the stack). There isn't a great deal of information out there on exactly how to put into production my set up, which is a backend set up on a Digital Ocean droplet with Prisma/GraphQL Yoga in a Docker Container using Next & Apollo Client on the frontend somewhere else. It's such a niche subject, so I bet only a few hundred people have got a website with this stack in production. Anyway, I wrote a blog post to help those who might need help understanding it. Here it is, hope it helps!

758k views758k

Comments

Detailed Comparison

Prisma	graphql-yoga
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.	Easiest way to run a GraphQL server: Sensible defaults & includes everything you need with minimal setup.;Includes Subscriptions: Built-in support for GraphQL subscriptions using WebSockets.;Compatible: Works with all GraphQL clients (Apollo, Relay...) and fits seamless in your GraphQL workflow.
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;	GraphQL spec-compliant;File upload;GraphQL Subscriptions;TypeScript typings;GraphQL Playground;Extensible via Express middlewares;Schema directives;Apollo Tracing;Accepts both application/json and application/graphql content-types;Runs everywhere: Can be deployed via now, up, AWS Lambda, Heroku etc.;Supports middleware out of the box.
Statistics
GitHub Stars 44.2K	GitHub Stars -
GitHub Forks 1.9K	GitHub Forks -
Stacks 1.3K	Stacks 99
Followers 974	Followers 144
Votes 55	Votes 3
Pros & Cons
Pros 12 Type-safe database access 10 Open Source 8 Auto-generated query builder 6 Increases confidence during development 6 Supports multible database systems Cons 2 Doesn't support downward/back migrations 1 Mutation of JSON is really confusing 1 Do not support JSONB 1 Doesn't support JSONB 1 Do not support JSONB	Pros 3 Easy to setup. No boilerplate code
Integrations
TypeScript Node.js Microsoft SQL Server PostgreSQL Serverless Apollo SQLite MongoDB GraphQL MariaDB	GraphQL Relay Framework Apollo Prisma Cloud

What are some alternatives to Prisma, graphql-yoga?

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.

PostGraphile

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

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.

Firecamp

Firecamp is a centralized platform to test/manage/collaborate on HTTP, GraphQL, WS and other forms of APIs in a Team.

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.

Related Comparisons

Prisma vs graphql-yoga: What are the differences?

ORM vs. Server Library: Prisma is primarily an ORM (Object-Relational Mapping) tool that provides a query builder and database client, enabling developers to interact with databases easily. On the other hand, graphql-yoga is a server library that helps in creating a GraphQL server with various features like schema generation, resolvers, and Middleware.
Database Integration: Prisma integrates with databases directly by generating a client that communicates with the database. It abstracts away the database layer and provides a type-safe API for database operations. In contrast, graphql-yoga allows developers to integrate any database of their choice by writing custom resolvers to handle data fetching and manipulation.
Development Focus: Prisma focuses on simplifying database access and management, providing tools for data modeling, migrations, and advanced queries. It is more suitable for projects that heavily rely on database operations. On the other hand, graphql-yoga is focused on building GraphQL APIs and managing server-side logic with features like subscriptions, data loaders, and error handling.
Server Environment: Prisma requires a separate server environment to run queries and interact with databases, making it suitable for backend applications. In contrast, graphql-yoga can be used for both frontend and backend development as it is responsible for handling GraphQL requests and responses on the server-side.
Community Support: Prisma has a growing community of developers that contribute to its development and provide support through forums, documentation, and tutorials. graphql-yoga, being built on top of popular libraries like Express and Apollo Server, benefits from the vast community of these tools, providing extensive resources for troubleshooting and development.
Ease of Use: Prisma simplifies database operations with its type-safe API, query builder, and schema migrations, making it easier for developers to work with databases. graphql-yoga, with its declarative approach to defining schemas and resolvers, simplifies the process of creating a GraphQL server with minimal boilerplate code, enhancing developer productivity.

Prisma vs graphql-yoga

Overview