CRUD in NextJS 13.4 (app router) and Postgresql.

This video is about using postgresql as the database with NextJS 13.4. (app router). We will see how to connect next and postgres by using a package called PG and also build a simple CRUD application.

[@sudo-apt-upgrade-brain]

Pure sql + nextjs. No prisma and other junk. Thanks.

[@dhriti3080]

You are welcome.

[@gilesjustinlabastilla2119]

Is it important to have a table first in the database before connecting from NextJS?

[@dhriti3080]

It is not required at first but if you post or if you try to get a some data that you want to render then it will start throwing errors because there won't be a table.

[@Boss-wl2gr]

I have a question, what is the reason of having DBConnect function? I noticed that queries working good without i call it!

[@dhriti3080]

Yeah you don't need to call the dbConnect function. Actually this application was initially made with mongodb as the data base and then dbconnect was required to be called every time a request was made. I just changed the database to postgres and made required changes to the backend. Sorry for the inconvenience.

[@scotly_emi]

Can you do a MySQL version please without using Prisma, I'm working on a project and am using next auth for signup and login but I want to be able to update my user info and also upload profile picture using multer

[@dhriti3080]

I don't use prisma instead use pg and I don't want to go through the process of installing MySQL in my computer. Postgres is gaining a lot of traction these days. If you are using next auth try to use the credentials provider with bcrypt or jwt. As for uploading the image you can use a package called formidable here is a link to that video kzbin.info/www/bejne/h4Wnan9mn7Fjmrc

[@Boss-wl2gr]

Very nice. Why you don't share the code (on githup for example?)

[@dhriti3080]

I usually do share the code but sometimes I just want to upload the video and get done with it. Anyways here is the link to the repo for this video github.com/dhritich20baruah/Postgresql_Projects/tree/master/nextjs_post/src.

[@Boss-wl2gr]

thank you so much. keep the good work up @@dhriti3080

[@PeeJoyHuaikrai]

Nuxt JS + PostgreSQL for the upcoming video please.

[@shanewa]

have github url?

[@dhriti3080]

Yes I do have it. Look at the previous comment I have shared the link there.