Updated integration for Vercel and Neon? (`@vercel/postgres` phase out)

[woeful viper]

Are we still supposed to use the db-vercel-postgres adapter for new Vercel + Neon projects, or is there an updated integration? It's using @vercel/postgres and not @neondatabase/serverless which supersedes it.

https://vercel.com/docs/postgres
https://github.com/vercel/storage/tree/main/packages/postgres

https://neon.com/docs/guides/vercel-postgres-transition-guide#compatibility-notes
https://orm.drizzle.team/docs/connect-neon
https://github.com/neondatabase/serverless

[slim grove]

New Community-Help Thread Created!

Help is on the way! To mark it as solved, use the /solve command. In the meantime, here are some existing threads that may help you:

Documentation:

• Postgres - Usage
• Vercel Content Link
• Transactions
• Storage Adapters - Vercel Blob Storage
• What is Payload? - Open source - deploy anywhere, including Vercel

[plush coral]

Hey @woeful viper did you know we have one click templates for Vercel + Postgres?

https://github.com/payloadcms/payload/tree/main/templates/with-vercel-postgres

https://github.com/payloadcms/payload/tree/main/templates/with-vercel-website

[woeful viper]

Yes, that's exactly why I'm asking. The template and db-vercel-postgres package are still using the unmaintained @vercel/postgres library

https://github.com/payloadcms/payload/blob/ac40185158c1923d983bffc96c08c13ebd57a829/packages/db-vercel-postgres/package.json#L79

Vercel use to have a Vercel Postgres which was a sorta whitelabel Neon, but since then they have migrated everyone to a Neon marketplace integration and Vercel is not maintaining the serverless postgres driver anymore.

Have a look specifically here: https://neon.com/docs/guides/vercel-postgres-transition-guide#compatibility-notes

as far as I know it's been 6-ish months that this transition has happened

[rustic smelt]

This will require either the creation of a new db-adapter package for neon-serverless, or updating the existing adapter to use neon/serverless instead (depending on what breaks). Probably some nuance to both. I'm not sure of any progress here, so my recommendation would be to create a GH Discussion clearly listing this so it can be tracked as a feature request/improvement.

[woeful viper]

Thanks, that's what I figured. I'll start a GitHub discussion when I have a minute. I think there's @neondatabase/vercel-postgres-compat that maybe the current db adapter could be using without breaking changes, and potentially a new adapter. I would also keep in mind that Planetscale has a Postgres product in preview that would also need to be eventually adressed I assume. Maybe a new adapter that lets users pass-in their own drizzle instance would be more future-proof?

[woeful viper]

I created a discussion as suggested @rustic smelt https://github.com/payloadcms/payload/discussions/13404

(CC @mild crow since you replied in the core-dev channel a few days ago)

[mild crow]

Thanks @woeful viper ! And I remember this discussion today since I saw a video shared by the Payload youtube channel showing that Vercel + Postgres that @plush coral mentioned above.

Oh, are you the one in the video @plush coral ? https://www.youtube.com/watch?v=7jAYKaRaI30

[rustic smelt]

That is indeed daddy Sean

My god everything is so bright lol, might need some sunscreen

This guy light modes

[plush coral]

I LIKE COLORS

you've reminded me I need to download my go-to light theme

[plush coral]

my goal now will be to make my wallpaper brighter for every video

buckle up

[mild crow]

Even you seemed to be a different person lol

Everything was so bright that you seemed to be another person 😂

[plush coral]

video Sean is my alter ego

video Sean loves life

video Sean is talking about cool Payload features

[rustic smelt]

Everyone should be like video Sean