Unable to read/write to Postgres Database

[mzavattaro]

Great boilerplate. We're currently looking at using it internally for a grass roots project and I'm testing it out to understand how it works.

The issue I'm having is that I can't get it to read/write to our Neon Postgres database. I can successfully get it to npx drizzle-kit generate new tables into Neon, but I can't seem to get it to write guestbook entries into the database or read entries from the database guestbook table. It doesn't throw any exceptions.

I've got the connection string DATABASE_URL=postgresql:// in the .env file (.env.local and .env.production.local doesn't locate the database url). Network requests are showing status 200 for all the POST requests from the guestbook form.

You can check out my fork here: https://github.com/mzavattaro/Next-js-Boilerplate

I'm sure I'm missing something simple, any help would be great.

[ixartz]

By default, on local/dev environment, the project uses the local and in-memory PostgreSQL database. This should explain why the Neon database don't contain any data.

The best way is to deploy the project and use Neon database, you should able to see the data.

[mzavattaro]

Ah okay gotcha, so once it's deployed then I'll be able to see the data from Neon locally?

[ixartz]

Once it's deployed, you can see the Neon data on the deployed/production version