vercel postgresql without @vercel/postgres?

[indigo violet]

Hi everyone! can we use Vercel PostgreSQL with some ORMs like Prisma, drizzle, etc. without @vercel/postgres??

[rich topaz]

Post created!

🔎 This post has been indexed in our web forum and will be seen by search engines so other users can find it outside Discord

🕵️ Your user profile is private by default and won't be visible to users outside Discord, if you want to be visible in the web forum you can add the "Public Profile" role in id:customize

✅ You can mark a message as the answer for your post with Right click -> Apps -> Mark Solution
(if you don't see the option, try refreshing Discord with Ctrl + R)

[crystal heath]

I'm not sure about vercel postgress, but with their provider (https://neon.tech) you can do that... (There is like no benifits of bercels offering because it is just marked up neon db) aside from that, I think you would get env vars for the db connection in you project?

[indigo violet]

Yes I got env vars, why tho?

[crystal heath]

because you can then use any postgres library with those env vars

[indigo violet]

And yeah I just checked neon, Iet me try implementing it with some ORM

[indigo violet]

yep I understand but vercel's pgsql starter guide suggests to use @vercel/postgres

[crystal heath]

it is a suggestion, but it doesn't mean that you have to... and if you want an orm, then you can use that...

[indigo violet]

Ohh it working with prisma

vercel postgres

now could you please tell me which one is better??

neon or vercel, as of till now I was using railway as db provider

[crystal heath]

its up to you... there are many people online divided up with the benefits and negatives (some say query builder is all you need, others say ORM, and some others say raw SQL)

[indigo violet]

I'm interested in db service providers for now

[crystal heath]

personaly I would do neon if you would use vercel only because https://service-markup.vercel.app/

[indigo violet]

I tried almost all of these methods and found raw SQL to be faster in perf. but the benchmark is nearly equal with ORMs specially drizzle and sequelizer

[crystal heath]

perf over dev experience is something that is quoted...

[indigo violet]

Ohhhhhhh this much of diff.....🥲

anyone would like to go with neon after seeing this

[crystal heath]

yeah, it is kinda funny to look at

[crystal heath]

there are benifits of using vercel like everything is in one place to manage (so better dev exp), but i don't think it is worth that loss...

anyway, @indigo violet is your original question answered?

[indigo violet]

Yes yes, My bad I forgot to mark it...