This is a great tutorial! What I find confusing is that you're declaring the schema with Prisma but then you are running a migration with Knex, which seems rather a manual process. A small bit of feedback for future videos. The editor font size looks very small on YT, bigger would be easier to read.
@@kevinwwwade windows gets the 'TS_NODE_COMPILER_OPTIONS' not recognized as an internal or external command. but as someone stated in the above comment you can change the package.json to "db:migrate:make": "set TS_NODE_COMPILER_OPTIONS={ \"module\": \"commonjs\" } && knex migrate:make" and it works :)
Very concise tutorial! Thanks for that. I did have an issue where we started up the nextjs app with database collection. Something about `public.posts` is undefined in the postgres console. Solution for me was to run `pnpx prisma generate`.
11:44 When I try to run this command, i get 'TS_NODE_COMPILER_OPTIONS' not recognized as an internal or external command, operable program or batch file
Hmmm... sounds like you are on Windows. `TS_NODE_COMPILER_OPTIONS=...` prefixed to a command is a way to quickly set that environment variable for the life of a command on Mac/linux. Not sure off the top of my head how to do that on Windows, but maybe that gives you something to search for.
Literally answered my exact question. I.e. how to deploy Vercel Postgres DB to production in a Next.js app. Ty ty ty!
This is a great tutorial! What I find confusing is that you're declaring the schema with Prisma but then you are running a migration with Knex, which seems rather a manual process.
A small bit of feedback for future videos. The editor font size looks very small on YT, bigger would be easier to read.
Another great tutorial. Keep these coming 🙂
Glad I came across your channel, thank you!
that's amazing, great explanation. Keep up the good workm Kevin!!!!
Great clear and practical teaching style.
Thank you! ❤️
I find Drizzle ORM much better than Prisma
thank you man !
every thing was going good, but buddy you should write a disclaimer for window's user :( .
I haven’t used windows in forever, so I don’t know what the issues would be. What did you experience? That would be helpful. Thanks!
@@kevinwwwade windows gets the 'TS_NODE_COMPILER_OPTIONS' not recognized as an internal or external command. but as someone stated in the above comment you can change the package.json to "db:migrate:make": "set TS_NODE_COMPILER_OPTIONS={ \"module\": \"commonjs\" } && knex migrate:make" and it works :)
Very concise tutorial! Thanks for that. I did have an issue where we started up the nextjs app with database collection. Something about `public.posts` is undefined in the postgres console. Solution for me was to run `pnpx prisma generate`.
hi what theme you use?
11:44 When I try to run this command, i get
'TS_NODE_COMPILER_OPTIONS' not recognized as an internal or external command, operable program or batch file
Hmmm... sounds like you are on Windows. `TS_NODE_COMPILER_OPTIONS=...` prefixed to a command is a way to quickly set that environment variable for the life of a command on Mac/linux. Not sure off the top of my head how to do that on Windows, but maybe that gives you something to search for.
"db:migrate:make": "set TS_NODE_COMPILER_OPTIONS={ \"module\": \"commonjs\" } && knex migrate:make"
excellent tutorial
Thank you! ☺️