<h2>What is Prisma?</h2>
<p>Prisma is an Object-Relational Mapping tool. It allows us to modify a database using object-oriented style scripts rather than SQL, and prevents SQL injection. It also has a GUI where we can view and modify values in the database.</p>
<h2>How does it work?</h2>
<p>See <a href="https://vercel.com/guides/nextjs-prisma-postgres">this tutorial</a> for detailed setup information.<br>
To create the database schema, we use the schema.prisma file. In this file we define the following:</p>
<ul>
<li>datasource: this has provider, which we will set to "posgresql", and url, which will be the url of our database</li>
<li>generator: has provider, set to "prisma-client-js" because we are using next.js</li>
<li>models: these are the tables in the database. Each line within a model has the name of the attribute, the type (with a question mark if it can be null), and other parameters, such as "@relation", which defines a relation to another table.</li>
</ul>
<p>When that is set up, we must set up a prisma client. The client is a query builder that prevents SQL injection and organizes our queries.<br>
<a href="https://www.prisma.io/docs/concepts/components/prisma-client">Here is the prisma API reference</a>. I will use this often when building queries.
As we build the project, I will become more familiar with the structure and syntax of Prisma queries. These Prisma queries are wrapped in javascript functions, which can then be called by the frontend team to get the data they want to display.
<strong>-Walker</strong></p>


Walker & Taichen

Using Prisma

What is Prisma?

How does it work?