vercel postgresql without @vercel/postgres?
Answered
Naeemgg posted this in #help-forum
NaeemggOP
Hi everyone! can we use Vercel PostgreSQL with some ORMs like Prisma, drizzle, etc. without @vercel/postgres??
Answered by riský
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?
21 Replies
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?
Answer
@riský 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?
NaeemggOP
Yes I got env vars, why tho?
because you can then use any postgres library with those env vars
NaeemggOP
And yeah I just checked neon, Iet me try implementing it with some ORM
@riský because you can then use any postgres library with those env vars
NaeemggOP
yep I understand but vercel's pgsql starter guide suggests to use @vercel/postgres
it is a suggestion, but it doesn't mean that you have to... and if you want an orm, then you can use that...
NaeemggOP
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
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)
NaeemggOP
I'm interested in db service providers for now
@Naeemgg neon or vercel, as of till now I was using railway as db provider
personaly I would do neon if you would use vercel only because https://service-markup.vercel.app/
@riský 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)
NaeemggOP
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
perf over dev experience is something that is quoted...
@riský personaly I would do neon if you would use vercel only because <https://service-markup.vercel.app/>
NaeemggOP
Ohhhhhhh this much of diff.....🥲
anyone would like to go with neon after seeing this
yeah, it is kinda funny to look at
@riský personaly I would do neon if you would use vercel only because <https://service-markup.vercel.app/>
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, @Naeemgg is your original question answered?
NaeemggOP
Yes yes, My bad I forgot to mark it...