Prisma
one minute of reading
Prisma is a tool for quick application development. It is a framework that allows you to automatize application development processes such as database support, authorization and data validation.
When we want to create a system based on a database approach with relational nature then we will use ORM (Object-Relational Mapping). In this article, I will introduce you to a library that helps you build an ORM.
What is Prisma?
Prisma is an open source ORM that helps you build apps faster and make fewer mistakes. Prisma takes a different approach to ORM compared to traditional ORMs. It uses a standard schema definition language (SDL) that automatically writes migrations and generates type-safe code. Prisma consists of the following parts:
- Prisma Client - It is an auto-generated and type-safe query builder for Node.js and TypeScript.
- Prisma Migrate - A migration system.
- Prisma Studio - GUI for viewing and editing data in the database.
Prisma Client - can be used in any Node.js or TypeScript app. It can be a REST API, GraphQL API, gRPC API or anything else that requires a database.
How does Prisma work?
Every project using Prisma starts with a Prisma schema file. A Prisma schema allows developers to define application models in an intuitive data modeling language. In such a schema, we usually configure three things:
- Data Source - Specifies the connection to the database (via an environment variable).
- Generator - Indicates what you want to generate.
- Data model - defines the application models.
A data model is a collection of models. A model has two main functions: It represents a table in relational databases or a collection in MongoDB and provides the basis for queries in the Prisma Client API.
Prisma installation
To install Prisme, download the @prisma/client package:
npm install @prisma/client
Related articles
The Pros and Cons of Using PhpMyAdmin in Your PHP Development
6 Jun 2023
In PHP development, using PhpMyAdmin can be a convenient way of managing databases. However, it also has its drawbacks. In this article, we will explore the pros and cons of using PhpMyAdmin, to help you decide if it's the right tool for your project.

The Ethics of Grey Hat SEO
6 Jun 2023
Grey Hat SEO practices lie in a murky ethical territory between White Hat (ethical) and Black Hat (unethical) SEO. The line between ethical and unethical SEO can sometimes be blurred and can raise important ethical questions about what tactics are acceptable to use in the pursuit of higher search engine rankings.
The Traits of a Successful Tech Leader
6 Jun 2023
A successful tech leader possesses a unique combination of technical expertise, leadership skills, and the ability to inspire and motivate their teams. They must also possess excellent communication and problem-solving skills while staying up-to-date with the latest industry trends and technologies.
Common Types of red brick walland Their Functions
5 Jun 2023
Firewalls are essential for network security. In this article, we will discuss the most common types of firewalls, including packet-filtering, circuit-level, application-level, and next-generation. We will also explore their unique functions and how they protect networks from various cyber threats.
How to Secure Your Server with Fail2ban
5 Jun 2023
In today's interconnected world, server security is of paramount importance. As businesses and individuals increasingly rely on servers to store and process sensitive data, it becomes crucial to implement robust security measures to protect against potential threats. One such powerful tool that aids in fortifying server security is Fail2ban.
Common Mistakes to Avoid in QAQC Testing
5 Jun 2023
Improving software quality involves efficient testing. However, QAQC testing can be challenging, and certain mistakes can compromise the effectiveness of the process. In this article, we'll explore common mistakes to avoid in QAQC testing that can help improve the overall quality of software development.
Why Justified Text Might Not Always Be the Best Choice
5 Jun 2023
In typography, justified text has long been considered the 'holy grail' of formatting. However, it may not always be the best choice. While it can create an elegant and organized appearance, it can also lead to awkward spaces and make reading more difficult. In this article, we'll explore the pros and cons of justified text and when it's appropriate to use it.
Show all articles