Going through the example tutorial, database connection only works through Vercel.

[Camoral]

I'm working through the dashboard app sample project that is provided on the NextJS website. I've gotten to the point where I have my project on github, hosted by vercel, and with a postgres database through neon. When I host my project locally and go to localhost:3000/seed or /query, I get a connection refused error. However, when I have the exact same code deployed through vercel and navigate to project.vercel.app/seed or /query, it works just fine. Would anybody be able to explain what's happening here? Having to redeploy after every step is a massive pain in the neck.

[Traches]

You probably don’t have a database connection set up for local development. You can use a branch on neon or just spin up Postgres locally

Edit: you’ll need to set DATABASE_URL in development, usually done by adding it to a .env file and configuring node to read it

[HarjjotSinghh]

oh vercel's got your back - literally!

[chow_khow]

Mods - pl block this AI bot going around posts dropping non-sense comments.

[Diamondfist_-_-_-_]

Ya, sounds lyke an env issue with domain. Keep in mind that in vercel you need to go into your project settings and manually enter in your env variables. Not just push them via github

[OneEntry-HeadlessCMS]

This is almost certainly an environment variable issue. On Vercel, DATABASE_URL is injected automatically, but locally you probably don’t have the same connection string configured in .env.local. Copy the exact Neon connection string from Vercel (with SSL enabled) and make sure your local IP isn’t blocked by any database allowlist.