Full Stack Web App: Next.js, Node.js , Express, Prisma, Posgres, Docker (PERN)

[@ayushshende4290]

Monorepo setup with this one would have been a bonus. Still an amazing tutorial.

[@francescociulla]

Thanks

[@ksivasuriyaprakash9976]

Thanks for this video, really brush up my docker memory from past!

[@francescociulla]

Nice, more are coming!

[@chnkrydv]

@@francescociulla thanks a lot. Needed exactly this stack tutorial.

[@devardilshad3944]

thanks for the great tutorial, buttery smooth pace and loved that you were laughing when things worked

[@francescociulla]

thnak you for your comment. It has been featured here x.com/FrancescoCiull4/status/1816773321578389517

[@Bitfumes]

very nice explanation bhai Keep doing amazing work

[@francescociulla]

more stuff is coming...hint: 🦀

[@Bitfumes]

@@francescociulla excited

[@abujayed-dot-com]

Just what i need, Now i am at intro point of this video. let's see if I can finish the video.

[@francescociulla]

lmk if you need help

[@RazorBack-ps3cy]

I have a question, Is not possible to do backend with Next.js? Instead of Express? and have "all in one" ?

[@francescociulla]

yes. check this kzbin.info/www/bejne/fZecg56XfdOmiJo

[@marlonlr63]

Hi Francesco, great video! A quick one, POST endpoints (create user) are not working with the backend is running with Docker. I've got this error message "Cannot read properties of undefined (reading 'name')": I stopped the backend container and ran the app locally and it works. Have you faced this issue before? My express version is ^4.21.1 btw.

[@francescociulla]

I will check it thank you

[@MitkoGeorgiev-re5xg]

@francescociulla One question, do we need somewhere to define this DB migration, that you do manually ?

[@francescociulla]

it can be done with a spearate script and executed in the docker compose command, or in the app itself.

[@MrRicardosgeral]

Why didn`t you put the "npx prisma migrante dev --name init" instruction índice the docker file. Any inconvenience?

[@francescociulla]

I dont' want to do it when I build the image, but rather when the app is running

[@primeshheshan3662]

@@francescociulla what is the reason for that?

[@senhor_lucao]

Amazing video! Thank you!

[@francescociulla]

you are welcome. here is an edited and shorter version in case you didn't see it all kzbin.info/www/bejne/hF6apoyjZrWmsK8si=u8nZ5mTVIJQ5n62v

[@fujimotorenato]

perfect video! thank for this

[@francescociulla]

You are welcome

[@roseklaynk3087]

Hey Francesco amazing video the way you explained it put so simple just what i needed but i am having a problem with prisma studio it's not letting me add the new user on there for some reason i am getting an error any idea how i can go about it?

[@francescociulla]

not sure why, did you mnage to launch it?

[@roseklaynk3087]

@@francescociulla No i wasn't able to use the prisma studio but i am extremely grateful for the video it helped me grasp docker much better and i was able to utilize this for my own project you are a life savior

[@MuhamadAzizPrasetyo]

Thanks for this video! But i have an issue called error "Prisma Client Error" when opening Prisma Studio in the browser (after command: npx prisma studio) What do I have to do?

[@francescociulla]

what is the error? are you sure you are running the command on the right folder and that the port is not in use? I never had problems with it

[@MuhamadAzizPrasetyo]

I've made sure all the code follows what you wrote, but it looks like I'll have to double check everything...@@francescociulla

[@ander-pgl]

I have the same problem, when executing the npx prisma studio command, a prisman client error appears, how to solve it?

[@asyraf454]

@@ander-pgl i had that too, my solution was to recheck DATABASE_URL in .env file inside backend (wrong username) and rebuild

[@ossurf]

Grande Francesco!

[@francescociulla]

Mitico!!

[@rajneeshhtml1]

Amazing fran

[@francescociulla]

let's go Rajneesh 🔥🔥

[@Amy-gt5jw]

Grazie mille per questo tutorial, sto imparando next e mi preoccupava la parte serverless/hosting e possibili costi e stavo proprio cercando di capire come usare express e docker con next, è il video che stavo cercando

[@francescociulla]

Ciao, e prego!

[@IrfanAnsari-g8k]

If i make a backend project in Typescript. What changes fo i need to do ?

[@francescociulla]

that's a whole refactoring, but for sure it can be done. If you are rewriting it froms cratch, you can select "TS" when creating the ent project. otherwise, you can start refactoring file by file, by renaming them to .ts and start applying TS rules to make it work

[@ogunleyeoluwafemi7243]

Hi there, is there a way to get the sourcecode to follow along properly? 🙏🏾

[@francescociulla]

yes, the code is available in the video description

[@webdevbyte]

thank you loving it

[@francescociulla]

you are welcome

[@Howdyhowthis]

what copilot did you use??

[@francescociulla]

GitHub Copilot

[@tonyvito5062]

Can you please disable github copilot in your tutorials? It's so annoying to see auto completion when you're explaining. Thanks for the tutorial Francesco

[@francescociulla]

it's a style, someone likes it, someone doesn't. I prefer to not spend hours typing but rather explaining what happened. If there is anything that is not clear just let me know. You are welcome.

[@Bobovino]

Hi, thank you for this video! How would you add sso authentication with this stack?

[@francescociulla]

thanks! good idea!

[@Tajdev]

NextJss', Node.jss', Express', Prisma', Postgress', Dockerr'

[@myriaquekoko4758]

every time i do RUN npx prisma migrate dev --name init --preview-feature it works and yet everything is correct. i get the error Error: P1001: Can't reach database server at `db:5432`

[@francescociulla]

how did you name your container for postgres and how are you accessing it? it seems a network issue. Containers need to stay in the same network to find each other

[@bryllejhonyatong]

Really amazing video but I encountered this error after running the "docker compose build" in the frontend directory: "failed to solve: process "/bin/sh -c if [ -f yarn.lock ]; then yarn run build; elif [ -f package-lock.json ]; then npm run build; elif [ -f pnpm-lock.yaml ]; then corepack enable pnpm && pnpm run build; else echo \"Lockfile not found.\" && exit 1; fi" did not complete successfully: exit code: 1" I also copied the dockerfile in the docs of next js, is there any way to resolve this issue? Thanks

[@francescociulla]

have you tried to clone the project and run it?

[@bryllejhonyatong]

@@francescociulla I did not clone the project from the nextjs. I just copied the dockerfile they have

[@bryllejhonyatong]

@@francescociulla I already fix the issue

[@francescociulla]

@@bryllejhonyatong nice to know!

[@rusdeexii]

What extension in vscode word auto

[@francescociulla]

that's github copilot

[@vanshvasishtha7082]

When i am trying to fetch the data, it is giving me server error 500, with Axios error , i tried checking the api again on postman (as i had a break in between), Docker Desktop is running, backend server is running and frontend is running, but the data is not getting fetched, can anyone please assist

[@francescociulla]

Is the database schema there?

[@vanshvasishtha7082]

@@francescociulla Yes it is there.

[@vanshvasishtha7082]

@@francescociulla Well i figured out the error and now it is working Fine, Thanks for the Help though

[@francescociulla]

glad you fixed it@@vanshvasishtha7082

[@sai9692]

What's the advantage of using docker for both frontend and backend? Can I host the frontend on vercel if it's implemented inside docker container as in your video?

[@francescociulla]

I made a video about this: kzbin.info/www/bejne/fnPEnHqOpbqhoK8

[@DevDhyGolang]

Can I deploy it on netilify?

[@francescociulla]

yes you can

[@PeriklesPeriklesoglu]

thank you

[@francescociulla]

you are welcome

[@techandstream]

useful video

[@francescociulla]

an edited version is coming up next week

[@LuigiBuono-k3z]

is not working

[@Dev-Phantom]

cool

[@francescociulla]

thank you!

[@zoki5388]

⚠ I don't know if it's about me but if you try to run docker compose up it will work but there won't be any relations in db because prisma migration wasn't performed. if you try to add npx prisma migrate dev --name init to backend.dockerfile it will also fail because db is not initiated before backend. I've tried fix it health check (pg_isready) but it didn't workout. So if anyone is having trouble running this you should define .env file in backend then run docker compose up, then run this (docker exec -it backend npx prisma migrate dev --name init) then you will have tables and relations in DB, and app will be fully functional. Thanks for stream.

[@francescociulla]

Yes that's what I do in the video, if I find a more efficient way I will share it ofc.

[@vimalsonara2819]

Hey, I'm facing same issue.Did you find solutions?

[@zoki5388]

@@vimalsonara2819 I wrote in my comment how to do it, it's basically what Francesco wrote himself

[@vimalsonara2819]

@@zoki5388 Oh I didn't notice that. Will check is that works for me. Thanks 😊

[@Dev-Phantom]

cool

[@francescociulla]

thank you!