With that, you just created a simple, functioning API using Node.js (Express), Postgres and PRISMA.

This entire model will be treated as a table by the database.Ĭonst 🚀`) To define a model, we use the keyword model then specify the name of the model. TIP: If you are using VSCode for this tutorial, you can install the prisma extention here to help you autocomplete and format the prisma modeling language. Within the schema.prisma file, after the datasource and generator block, we can define our model. Therefore, once we are done with our models, we will run prisma migrate which will create the relevant tables in the db. Prisma is an ORM, so it has to transform the data model into relevant SQL statements and database tables. Prisma comes with it’s own data modeling language that makes it easier to perform data modeling. Modeling is necessary to give a description of the data that the client is providing, and the data the database is expecting. When working with a database, you have to define how the data in the database will look like. Let’s get coding! Step 3: Data modeling using Prisma With that done, we have our project setup. Run npm init -y in the directory to initialize a Node.js project.ĭATABASE_URL = your_user, your_password and db_name with your correct credentials.

A good understanding of the Express framework.Ĭreate your working directory and give it any name you’d like.

To comfortably follow this article along, you will need to have: In this article, we will look at how to setup and create a simple Node.js API, using Express as our framework of choice, Postgresql as our database, and Prisma as our ORM. Working with SQL databases in Node.js often requires ORM (Object Relational Mapping) libraries to abstract the untidy database operations so the developer only has to worry about the logic. Examples of such are Mongodb and Firebase. When using Node.js most developers opt to go for NoSql databases as they are known to be easier to use. In many modern backend architectures, we model everything else around the data and its manipulation.

Most modern day applications make use of databases mainly to store data.

Prisma case contents