215
322
+ 1
10

What is 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.
Prisma is a tool in the Query Languages category of a tech stack.
Prisma is an open source tool with 4K GitHub stars and 251 GitHub forks. Here鈥檚 a link to Prisma's open source repository on GitHub

Who uses Prisma?

Companies
31 companies reportedly use Prisma in their tech stacks, including Graphy, commercetools, and araclx.

Developers
175 developers on StackShare have stated that they use Prisma.

Prisma Integrations

JavaScript, Node.js, MySQL, PostgreSQL, and TypeScript are some of the popular tools that integrate with Prisma. Here's a list of all 13 tools that integrate with Prisma.
Private Decisions at about Prisma

Here are some stack decisions, common use cases and reviews by members of with Prisma in their tech stack.

Luke Hamilton
Luke Hamilton
Sr. Engineer at StackShare | 6 upvotes 2K views

I used Prisma for creating a ready-to-use GraphQL API in front of my PostgreSQL database. It allowed me to get up and running very quickly because I didn鈥檛 need to worry about writing the logic that interacts with the database. You simply define your data model using the GraphQL schema definition language and then use the Prisma CLI tool to deploy your changes. Based on your data model Prisma will generate a ready-to-use GraphQL API with CRUD functionality. Additionally the API includes filtering, sorting and pagination out of the box. You can then use Prisma Cloud to manage your data.

See more
Collins  Ogbuzuru
Collins Ogbuzuru
Front-end dev at Evolve credit | 9 upvotes 20.1K views
Shared insights
on
GraphQLGraphQLPrismaPrismaAWS LambdaAWS Lambda

We are starting to build one shirt data logic, structure and as an online clothing store we believe good ux and ui is a goal to drive a lot of click through. The problem is, how do we fetch data and how do we abstract the gap between the Front-end devs and backend-devs as we are just two in the technical unit. We decided to go for GraphQL as our application-layer tool and Prisma for our database-layer abstracter.

Reasons :

GraphQL :

  1. GraphQL makes fetching of data less painful and organised.

  2. GraphQL gives you 100% assurance on data you getting back as opposed to the Rest design .

  3. GraphQL comes with a bunch of real-time functionality in form of. subscriptions and finally because we are using React (GraphQL is not React demanding, it's doesn't require a specific framework, language or tool, but it definitely makes react apps fly )

Prisma :

  1. Writing revolvers can be fun, but imagine writing revolvers nested deep down, curry braces flying around. This is sure a welcome note to bugs and as a small team we need to focus more on what that matters more. Prisma generates this necessary CRUD resolves, mutations and subscription out of the box.

  2. We don't really have much budget at the moment so we are going to run our logic in a scalable cheap and cost effective cloud environment. Oh! It's AWS Lambda and deploying our schema to Lambda is our best bet to minimize cost and same time scale.

We are still at development stage and I believe, working on this start up will increase my dev knowledge. Off for Lunch :)

See more
Seun Kola
Seun Kola
CTO at Virtualrobe Limited | 7 upvotes 16.1K views
Shared insights
on
GraphQLGraphQLReactReactPrismaPrismaApolloApollo

Using GraphQL for queries and mutation on React app and Prisma database is so cool, easy and fast to learn. i often use Apollo client to integrate both ends. Most times working has a frontend developer and trying to build a MVP product quickly requires tools that require less setup on both production and development in order to test functionalities, and using GraphQL for queries surpasses Rest queries for me because of the flexibility in requesting the data you actually need and not requesting the whole dataset everytime.

But in all, Rest is still the king since most public api support its CRUD processes more than GraphQL but lot of top companies are using it and am definitely using it for various project including my recent pet project(Delivery buddy - A platform that allows pair-to-pair delivery service).

See more
Divine Bawa
Divine Bawa
at PayHub Ghana Limited | 14 upvotes 233.9K views

I just finished a web app meant for a business that offers training programs for certain professional courses. I chose this stack to test out my skills in graphql and react. I used Node.js , GraphQL , MySQL for the #Backend utilizing Prisma as a database interface for MySQL to provide CRUD APIs and graphql-yoga as a server. For the #frontend I chose React, styled-components for styling, Next.js for routing and SSR and Apollo for data management. I really liked the outcome and I will definitely use this stack in future projects.

See more
Shared insights
on
PrismaPrisma

Prisma will act as the database client, translating the database schema from GraphQL into a typed and consistent database tables in PostGresQL Prisma

See more
Seun Kola
Seun Kola
CTO at Virtualrobe Limited | 2 upvotes 14.6K views

Have been working on a side project that focuses on sharing economy, allowing users to pickup and deliver groceries for others. Have already started working on the frontend for the web dashboard using React and plan to use React Native for the mobile app. But am in a dilemma, whether to build the backend myself for the MVP or use firebase for the backend. I need advise, has anyone use Firebase for such project and what are the pros and cons, what issues will i faced.

Note: My proposed stack for the backend is a Prisma database, GraphQL , Apollo and ExpressJS

Thanks in advance to everyone.

See more
Public Decisions about Prisma

Here are some stack decisions, common use cases and reviews by companies and developers who chose Prisma in their tech stack.

Divine Bawa
Divine Bawa
at PayHub Ghana Limited | 14 upvotes 233.9K views

I just finished a web app meant for a business that offers training programs for certain professional courses. I chose this stack to test out my skills in graphql and react. I used Node.js , GraphQL , MySQL for the #Backend utilizing Prisma as a database interface for MySQL to provide CRUD APIs and graphql-yoga as a server. For the #frontend I chose React, styled-components for styling, Next.js for routing and SSR and Apollo for data management. I really liked the outcome and I will definitely use this stack in future projects.

See more
Munkhtegsh Munkhbat
Munkhtegsh Munkhbat
Software Engineer Consultant at LoanSnap | 9 upvotes 70.5K views

In my last side project, I built a web posting application that has similar features as Facebook and hosted on Heroku. The user can register an account, create posts, upload images and share with others. I took an advantage of graphql-subscriptions to handle realtime notifications in the comments section. Currently, I'm at the last stage of styling and building layouts.

For the #Backend I used graphql-yoga, Prisma, GraphQL with PostgreSQL database. For the #FrontEnd: React, styled-components with Apollo. The app is hosted on Heroku.

See more
Collins  Ogbuzuru
Collins Ogbuzuru
Front-end dev at Evolve credit | 9 upvotes 20.1K views
Shared insights
on
GraphQLGraphQLPrismaPrismaAWS LambdaAWS Lambda

We are starting to build one shirt data logic, structure and as an online clothing store we believe good ux and ui is a goal to drive a lot of click through. The problem is, how do we fetch data and how do we abstract the gap between the Front-end devs and backend-devs as we are just two in the technical unit. We decided to go for GraphQL as our application-layer tool and Prisma for our database-layer abstracter.

Reasons :

GraphQL :

  1. GraphQL makes fetching of data less painful and organised.

  2. GraphQL gives you 100% assurance on data you getting back as opposed to the Rest design .

  3. GraphQL comes with a bunch of real-time functionality in form of. subscriptions and finally because we are using React (GraphQL is not React demanding, it's doesn't require a specific framework, language or tool, but it definitely makes react apps fly )

Prisma :

  1. Writing revolvers can be fun, but imagine writing revolvers nested deep down, curry braces flying around. This is sure a welcome note to bugs and as a small team we need to focus more on what that matters more. Prisma generates this necessary CRUD resolves, mutations and subscription out of the box.

  2. We don't really have much budget at the moment so we are going to run our logic in a scalable cheap and cost effective cloud environment. Oh! It's AWS Lambda and deploying our schema to Lambda is our best bet to minimize cost and same time scale.

We are still at development stage and I believe, working on this start up will increase my dev knowledge. Off for Lunch :)

See more
Seun Kola
Seun Kola
CTO at Virtualrobe Limited | 7 upvotes 16.1K views
Shared insights
on
GraphQLGraphQLReactReactPrismaPrismaApolloApollo

Using GraphQL for queries and mutation on React app and Prisma database is so cool, easy and fast to learn. i often use Apollo client to integrate both ends. Most times working has a frontend developer and trying to build a MVP product quickly requires tools that require less setup on both production and development in order to test functionalities, and using GraphQL for queries surpasses Rest queries for me because of the flexibility in requesting the data you actually need and not requesting the whole dataset everytime.

But in all, Rest is still the king since most public api support its CRUD processes more than GraphQL but lot of top companies are using it and am definitely using it for various project including my recent pet project(Delivery buddy - A platform that allows pair-to-pair delivery service).

See more
Seun Kola
Seun Kola
CTO at Virtualrobe Limited | 2 upvotes 14.6K views

Have been working on a side project that focuses on sharing economy, allowing users to pickup and deliver groceries for others. Have already started working on the frontend for the web dashboard using React and plan to use React Native for the mobile app. But am in a dilemma, whether to build the backend myself for the MVP or use firebase for the backend. I need advise, has anyone use Firebase for such project and what are the pros and cons, what issues will i faced.

Note: My proposed stack for the backend is a Prisma database, GraphQL , Apollo and ExpressJS

Thanks in advance to everyone.

See more
Shared insights
on
PrismaPrisma

Prisma will act as the database client, translating the database schema from GraphQL into a typed and consistent database tables in PostGresQL Prisma

See more

Prisma's Features

  • 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

Prisma Alternatives & Comparisons

What are some alternatives to Prisma?
AWS AppSync
AWS AppSync automatically updates the data in web and mobile applications in real time, and updates data for offline users as soon as they reconnect. AppSync makes it easy to build collaborative mobile and web applications that deliver responsive, collaborative user experiences.
Apollo
Build a universal GraphQL API on top of your existing REST APIs, so you can ship new application features fast without waiting on backend changes.
Hasura
An open source GraphQL engine that deploys instant, realtime GraphQL APIs on any Postgres database.
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.
TypeORM
It supports both Active Record and Data Mapper patterns, unlike all other JavaScript ORMs currently in existence, which means you can write high quality, loosely coupled, scalable, maintainable applications the most productive way.
See all alternatives

Prisma's Followers
322 developers follow Prisma to keep up with related blogs and decisions.
Mark Lalich
Daniel Dilly
Radhwane Fellahi
Serhii Prykhodko
Liam Converse
Grant G
Yai Son
Benjamin Davidson
Matevz Golob
Ivan Davis