#Failed to seed database in NextJS dashboard app tutorial (chapter 6)

1 messages · Page 1 of 1 (latest)

worn prawn
#

Hello, I would like some help please. I am following Next tutorial for the Dashboard app. I am up to chapter 6 and got stuck with seeding the database. I have followed step by step from the tutorial but I get timeout error when calling the seed API

waxen bloomBOT
#
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)

worn prawn
#

I have tried to used the API from the deployed app, it was able to seed and query the database. But how come from the localhost I can only query but not being able to seed it

#

Thanks in advance if anyone can help me out

worn prawn
#

I have figured it out myself and I would like to share it in here in case someone is facing the same issue.

The sql variable in /seed API needs to use the DATABASE_URL env var as it is a non-pool/direct connection (it will support long transactions like seeding) while the POSTGRES_URL is for the pooling connection (which only supports short-term connection for querying). As a result, if you call from your localhost for seeding, you will need a direct connection. It also explains that if you call with the deployed app from Vercel, the seeding API works as it doesn't require long transaction/connection since you connected the database to them from the tutorial

waxen bloomBOT