Next.js Discord

Discord Forum

is prisma needed for databases?

Answered
Pacific saury posted this in #help-forum
Open in Discord
Pacific sauryOP
if i want to add to and return data from a vercel postgres database do i need prisma?
Answered by nahuelluca
no, you can use SQL queries o another ORM or query bulder
View full answer

10 Replies

no, you can use SQL queries o another ORM or query bulder
Answer
@Pacific saury if i want to add to and return data from a vercel postgres database do i need prisma?
that what nahuelluca said: basic SQL are possible ORM and query builder are also possible.

For that I like to use [drizzle](https://orm.drizzle.team/). It's nearly the same as prisma and its free. It's very easy to query data and manage your database and it's fast as well. And you are using vercel postgres, so you can even use it on edge (so you can query data in middleware for example)
@Pacific saury https://orm.drizzle.team/learn/tutorials/drizzle-with-vercel so if i just do this then it should work?
yes and after that you can directly get your data:
const result = await db.select().from(users); // your data
wait so im trying to display the databse in like text boxes on the page thats possible with this right
@Pacific saury wait so im trying to display the databse in like text boxes on the page thats possible with this right
when you using the chrome extension (or start it via the command) you get a web presentation of your database, yes
Here if you want to test it: https://demo.drizzle.studio/
@Pacific saury solved?