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.
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.
@@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 :)
Glad I came across your channel, thank you!
Another great tutorial. Keep these coming 🙂
Great clear and practical teaching style.
Thank you! ❤️
Literally answered my exact question. I.e. how to deploy Vercel Postgres DB to production in a Next.js app. Ty ty ty!
that's amazing, great explanation. Keep up the good workm Kevin!!!!
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.
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?
excellent tutorial
Thank you! ☺️
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"
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 :)
I find Drizzle ORM much better than Prisma