nice video! is there a way to insert massive data from sql export to the vercel's db? i've been working with my local database, and i would like to replicate my data to the remote one. Thanks a lot guy!
Thanks! Not sure if there is super good way to insert massive amounts of data. Depending on how massive your data export is, you could just copy paste your export to the query window inside vercel postgres db and that way insert the data, this of course won't be efficient if you actually have massive amounts of data.
I dont want to deploy my project to vercel or create a db there. i created my pg db locally and i need a way that will allow me to connect to it then use the api to run queries against it
Is it possible to hosting postgres in Vercel despite not using Next JS as a framework(ex: Vue JS), and is there any different step if I want to link verrcel postgres db to ORM (ex: Sequelize) ?
You can use it with other ways too, if you check your postgres db in vercel there is different options you can use to connect it to eg using drizzle-orm
Have you tried this via Prisma, Vercel Postgres? I keep getting an error code P1001 saying it can’t connect to the database. Even Vercels example repository errors out 😂
@@TuomoKankaanpaa I found a fix. I was trying to use yarn prisma migrate dev. The fix was to use yarn prisma migrate dev --name -enter name-. For some reason giving it a name with the name flag worked for me.
Thank you! Answers all my questions so far.
Great to hear!
Straightforward and simple. Thanks!
Cheers!
Oh I am surprised today one more video 😅 love from India 🇮🇳
Yeah wanted to get the Vercel KV and Vercel Postgres tutorials out asap! Cheers!
@@TuomoKankaanpaa where ?
@@wassu8499 Here is the Vercel KV video ua-cam.com/video/nV3IN4Bkl9s/v-deo.html
No bullshit straight to the point. Awesome!
great video, very helpful
was stuck from a long time.
Cheers!
thanks 🙏, concise and very helpful!
Thanks! Great to hear!
thanks for the guide
nice video! is there a way to insert massive data from sql export to the vercel's db? i've been working with my local database, and i would like to replicate my data to the remote one. Thanks a lot guy!
Thanks! Not sure if there is super good way to insert massive amounts of data. Depending on how massive your data export is, you could just copy paste your export to the query window inside vercel postgres db and that way insert the data, this of course won't be efficient if you actually have massive amounts of data.
Brilliant, thank you.
Cheers!
I dont want to deploy my project to vercel or create a db there. i created my pg db locally and i need a way that will allow me to connect to it then use the api to run queries against it
Did you manage to figure it out? Also having the same problem as yours.
@@jeremyAr no. i ended up deploying my site to vercel
I like it when you say "shwitz" :)
Haha that’s great! :D
Great job, where do I leave a tip?
You can leave a tip here if you wish: bit.ly/3XTXNZu Thanks!
Is it possible to hosting postgres in Vercel despite not using Next JS as a framework(ex: Vue JS), and is there any different step if I want to link verrcel postgres db to ORM (ex: Sequelize) ?
I have the same question ☝
You can use it with other ways too, if you check your postgres db in vercel there is different options you can use to connect it to eg using drizzle-orm
How would this be done using app router? right now when I open /api/pets it shows page error 404
You can use route handlers to replace api routes, I have a video about route handlers you should check out ua-cam.com/video/rG2exRlD2FQ/v-deo.html
Have you tried this via Prisma, Vercel Postgres? I keep getting an error code P1001 saying it can’t connect to the database. Even Vercels example repository errors out 😂
I havent tried it, sounds like a nasty bug if vercel examples also error out
@@TuomoKankaanpaa I found a fix. I was trying to use yarn prisma migrate dev. The fix was to use yarn prisma migrate dev --name -enter name-. For some reason giving it a name with the name flag worked for me.
can i use this same example for app roter?
Yes sir!
Can i deploy my next13 app + Prisma + postgres into vercel postgres?
That should be possible!
Would anyone know why my api/pets would 404? I'm using the app folder, rather than pages.
Make sure your route handlers are setup correctly if using app folder, here is a video about route handlers ua-cam.com/video/rG2exRlD2FQ/v-deo.html
Can you do video about Server Actions of nextjs 13.4
Thanks for the feedback, let's see! :)
Thank you
Cheers!
soo good, thankss
Great to hear!
Thanks for the quick intro
Cheers!
hi Thomas, you have a little error with the video title, I believe you meant next.js not next.ja
That’s true, thanks! 😊
kiitos
Ole hyvä!