is prisma needed for databases?
Answered
Pacific saury posted this in #help-forum
Pacific sauryOP
if i want to add to and return data from a vercel postgres database do i need prisma?
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)
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)
@B33fb0n3 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 sauryOP
https://orm.drizzle.team/learn/tutorials/drizzle-with-vercel so if i just do this then it should work?
@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 dataAlso if you need an admin panel: https://chromewebstore.google.com/detail/drizzle-studio/mjkojjodijpaneehkgmeckeljgkimnmd
@B33fb0n3 Also if you need an admin panel: https://chromewebstore.google.com/detail/drizzle-studio/mjkojjodijpaneehkgmeckeljgkimnmd
Pacific sauryOP
oh this actually helps
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?