React Node.js MySQL Social Media App Tutorial | Full Stack Social Network App

[@vaibhav55592]

Hey Lama if you are reading this , I just want to say thank you , I'm from very poor family trying to learn from your channel,I will definitely pay you when I get the job...Thanks you again

[@tarik9563]

+1

[@eren.sarioglu]

hope you will get the job that you dreamed of and everything will be excellent for you!

[@edutech8909]

keep going, God will do it for you

[@zeusek-2137]

Keep going King, see you soon!

[@Benyx]

@@zeusek-2137 can you get a job if you got this type of knowledge what Lama showed on the video?

[@eren.sarioglu]

I've never seen a youtube channel as helpful as you. You are making excellent tutorials even that cannot be found in paid courses. I'll be following you, keep going on dude!

[@ferdinandeke9590]

This is amazing Lama. You've been my best teacher I've got to be honest. Thank you for all you do and keep doing. On the next project pls, could we build a logistics web app, one where we could ship items across borders and the calculate the distances by zipcodes of the origin and destination of the product being shipped, also taking into account if it's a ground shipping or sea shipping and the parameters that are important for either of such shipping methods when calculating an estimated shipping fee. That's something I haven't seen anywhere on the internet yet. And I would love to see possible ideas that could help me build a start up logistics company. Thanks once more Lama.

[@ferdinandeke9590]

And this could be plugged in to either of our previous ecommerce projects to have trans border shipping.

[@AbhishekPal-ri9gr]

yes bro he is the best

[@salmanpatrick]

A perfect tutorial. Perfect way of teaching and explaining things. I already had SQL knowledge so I didn't get much problems in understanding the logics. Can't to wait to do experiments with it and complete it's features. My main goal to watch this tutorial was to understand the backend logic as UI is not a big deal. And I got it. In addition to that, I learned the advance folder structures and overall project organizing. This tutorial has helped me in many ways. Thank you so much bro. Please keep blessing us with such beautiful contents 💕🔥.

[@selflearning3851]

Just in Time i just finished The full stack blog website and now this. thank you, i can't thank you enough. please provide us with more tutorials like this i really enjoy and learn from them.

[@amaniberrebeh9352]

i have a problem with storing the token in the cookie, i have done all the steps but i didn't get any token did you get such a problem working on the blog project ?

[@dayojaiyed7721]

Can you share how you send the register details to MYSQL in the blog? It's not working at my end though I import mysql2 . Thank you

[@garpalion]

Want to say thank you very much for your projects! Personally, I work with typescript and also can't implement everything in your way , but I still learn a lot from you and regardless, I just enjoy working with you! I would like you to prepare some project with redux toolkit. I personally really need it. Thanks a lot once again! You are great!

[@adebisisheriff159]

I don't only like your videos, I love it. Your video is essential for developers as water is essential for human body. Thank you so much Lamadev. More power to your elbow. Love you!

[@coder5336]

Can't wait to add all the other features to the project and put it to my portfolio. Lama dev is amazing as always.

[@AmanSingh-gg6zc]

Did you add the search user feature...

[@girishtiwale7568]

One issue I came across was using useQuery for the components like Comments & Post that are rendered multiple times in our app and almost spent an entire day banging my head over it. I thought others might as well come across. when we use 'useQuery' in a component that is rendered multiple times, we are passing a queryKey (eg. ['comments']) to the useQuery hook which essentially becomes the same for all the Comments components that are rendered all over the application. It is evident whenever we keep a comment box open for one post and then open second post's comment box, the first post's comments are changed with the second post's. My theory is that queryKey is essentially the same for all the comments components. So it has an effect on all the components. Making the queryKey unique for each component by appending the postId to the key(so that every queryKey will be different for different post's comments) did the trick for me. eg. useQuery(["comments" + postId] , fetchFn ); I don't know if there is any other way to resolve this conflict. All the other suggesstions are welcome as well, I would appreciate the feedback too.

[@yenthanhngo9441]

can you fix that issue ?

[@yosoytrexnor1312]

This is the best thing I've seen in a long time! You are amazing lama dev. Thanks for all

[@Dave-mo2zx]

graphql, testing, CI/CD, typescript, react native. Any one of these technologies will be fun to learn from you master Lama

[@ninjaplavi]

React Native, Node, and MySQL app would be a bomb. Thanks a lot!

[@mohammadforutan341]

Calmness in teaching gives the audience a sense of ease. Your work, your teaching method is very first class. I thank you for your useful and smooth training . (Translated by Google Translate)

[@zainwasem]

This is by far the best KZbin channel if you wanna learn anything related to web. ThankYou Professor Lama. Will Buy you a coffee ☕

[@tayyabsami258]

Chat app video watched , Watched this video part 1 and now started part 2 , will combine them all to make a great project Inshallah , great channel , Permanent Subscriber 😍

[@mahtab7667]

Can you please provide me your source code of this and chat application combined Project??

[@victoriyanu3390]

Anytime I remember Lama, I just smile. You're a blessing man 😘

[@rchbiy]

Thanks for the tutorial Lama! Really love it!

[@codewithgeeks366]

Hey sir .. really thanks for the video and for the opportunity you keep giving to your community through the knowledge you keep sharing. Please teach us how to safely deploy all this projects . The aime for us should not be only to create but also to share links and have good portfolio's

[@felixmarvelian6118]

hey bro, did you find how to deploy it on the internet?

[@green__apple]

I hope there will be a full-stack lecture using the redux toolkit next time. Thank you always. I'm getting a lot of help.

[@Abhisumant03]

Your react series on hooks was literally awesome and as u said I saved in my important video playlist the usereducer hook video Thanks 🙏

[@beenbadamasyytv437]

We thank you for your efforts to bring us useful projects with simple explanation absolutely for free. It will be awesome if you can create a project with referral system functionality. Because I have never seen it on KZbin. Thank you God bless you

[@ucthainguyen8722]

at 0:50-51 mins are precious treasure! Thank you master LAMA !!!!

[@abhaythakur8572]

I wish i could find a channel like yours for Angular tutorials. Your channel has great content for Learning MERN Stack

[@narenk8077]

If you find angular let me know

[@penniel.software]

I did the introduction video where we create a book store and I just finished doing this one and I'm learning a lot about this stack. Please make more videos on Nodejs + Mysql

[@lexreal9131]

Woow this is really awesome.. Weldone LAMA Will be great to see you develop a POINT OF SALE (POS) with MERN

[@mootezsighari8885]

Awesome Thanks a lot lama , don't forget git tutorial I'm waiting😊

[@ahmedtlaidjia6908]

BEST FULL STACK PROJECT !! your work is very clean that will help me a lot thank you very much !

[@clownop2201]

Yes sir we definitely want git & GitHub video

[@SonnyBamra_0]

Hey Lama - Thanks for the video. I really want to see the Git tutorial please.

[@techhouse182]

Finest seen Projects learned alot....need more projects on react, node js and MySQl stack projects. Waiting for that 👍👌👌

[@nantuadhikari1280]

Please bring the next part of this video... that's the complete social media application with all functionalities enabled. It was really a nice tutorial.

[@worldbest3097]

lama! always awsome. thx for your effort and endeavor!!

[@megatronskneecap]

You're amazing, LAMA! I NEEDED this to finish off a blogging platform website I'm working on! Perfect!

[@AIMEDIAinc-et9kd]

Hello, I'm following your tutorial and I don't know why I'm not having the cookie after login. I tried with 3 browsers. I have a cookie only with insomnia.

[@nosense1272]

You're amazing Lama!

[@deepon4128]

login page onclick button after navigate home it's fixed 1-) Login.jsx add; const {currentUser} = useContext(AuthContext); 2-)After handleLogin func open if statement; if(currentUser){ navigate("/") }

[@memduhcevik]

incredibly awesome, bro

[@zobeirrigi8497]

Lama, I just want to say that I love you and your content😍. You explain everything very easily and understandably. If I get the job, I will let you know (comment on it) in one of your videos.

[@wendybaque9356]

Best tutorial ever ! I learn React Query and I am interested in a specific video on this technology. Thanks !

[@abyssfelo3147]

Hey lamadev, I would like to make a request. Would you please make a short video about nodejs on how we can store images to aws S3 bucket and the image url to MySQL database. Thankyou

[@donmenya2761]

Excellent tutorial! Many thanks!

[@innazozulia]

Very cool project, thanks! You explain very well 🔥 Looking forward to new videos 😄

[@dr.margulis7773]

I always click "Like" first when watching your video, sir! Many-many-many THANKS to you! 👍👍👍👍👍👏👏👏🙏

[@goyappi7447]

Much appreciation. So incredible!

[@rizwanjamadar7722]

Hello Lama, You are providing such a beautiful and understandable content for free but I have one doubt can you tell me how you decide combination of color palettes and font ? Lots of love Lama ❤️❤️

[@salmanpatrick]

So I have added the following features to this app : Users can now post videos as well cuz I'm checking whether the file contains picture extension or video so I'm rendering the file on the basis of that!!! I have added the real friends list on the right bar. I mean your real friends who you follow will be appeared on the right bar just like facebook! User profile is more advanced! user can write his custom bio, there are some stats like followers and following. Just like Instagram. I have add relationship status, work and hobby sections etc in profile page. And the biggest feature I have added is that user can now save the posts. There's a separate save posts section were user can see his saved posts. I need more suggestions and currently I'm thinking about stories section!

[@alexanderpayes2781]

Did you add more features? can you share your code please

[@prathamesh_dalvi9421]

give ur github link pls

[@coralioballester]

Thanks a lot for this. For some reason, on my Mac, invalidateQueries is working ok in Chrome but not in Safari. It only updates when you change to another tab/window and come back. In Chrome everything runs ok with zero errors in client and server's consoles

[@businessuser5146]

Thanks for the 2 awesome videos on mern app with sql

[@ahmedabdelmeguid1131]

Thanks a lot for this video🤗 ,in next videos ,we need use cloud technologies and headless cms

[@musamuhammed3653]

this is really amazing cant wait for ruby on rail

[@oli-9609]

Hi Lama ! First of all thanks for the great content ! It's a great to have such good content for free !🎉 I have followed your previous video about the UI part and I was wondering : can i follow this video to do the server / api / db part with sql and express while using next page for the routing and pre rendering ? Thanks in advance ! Cheers :)

[@gaius5]

I am grateful for all your work. Can you make a tutorial on searching a large amount of data(say like 1 million) in mysql db in an efficient way without waiting too much (say getting the result in milli seconds)?

[@LaingRaven]

Hello sir. I have follow your tutorial but I got problem at 52:09 When I click login button it not navigate to home page but when I check local storage and cookies it's have key user and accessToken. So when I click button login again it navigate to home page. So totally the problem is I need to click login button two time to login. I has spend to match time to solve this but no solution. I hope you can help me with this. Thank you.

[@deepon4128]

same problem i have. If you solve it say to me bro

[@LaingRaven]

@@deepon4128 I use setTimeout(() => { navigate("/"); }, 1); I have no choice but it work

[@deepon4128]

@@LaingRaven settimeout not working my project. How you can do it can you explain?

[@deepon4128]

i fixed brooo its amazing... 1-) Login.jsx add const {currentUser} = useContext(AuthContext); 2-)After handleLogin func open if statement; if(currentUser){ navigate("/") }

[@shmueltufahi5714]

@@deepon4128 thanks man!

[@kaltsdaniil8378]

Thanks a million, Lama Dev! Hope I will be able to follow your tutorials soon (actually I am studying ReactJs).

[@flavio5693]

very good course thank you I learnt a lot with it, please do you have one similar video where you make frontend and backend with Nodejs with jsonwebtoken but with mongoDB?

[@genildomirandapraca1926]

This is amazing! Thank you

[@juneldelacuadra5973]

Thank you sir. Let me ask, is this the process you use to build application using MySQL database?

[@aror9574]

I have a question when do you decide which DB do you use NoSql or Sql?

[@StarsOfMinecrafttr]

For a big data project like this, you should prefered postgre for db. Way more faster and efficient.

[@вдохновись-ч5э]

Thank you bro, I knew, that PostgreSQL existing, but did not know, that it is faster.

[@StarsOfMinecrafttr]

@@вдохновись-ч5э it is like 50x faster

[@StarsOfMinecrafttr]

@@вдохновись-ч5э but generaly projects like facebook or Instagram, they use big data database. Which requires at least 1 tb of ram, they store data to ram just incase if data reused again.

[@вдохновись-ч5э]

@@StarsOfMinecrafttr But why many people using MySQL instead of that?

[@StarsOfMinecrafttr]

@@вдохновись-ч5э bc it is more easy, and has more flexibility, it is hard to make it crash, but in postgre it is more likely to crash if you do not use redis to handle stack queries. So simply, it is easy to use. But slower.

[@annabrooks5175]

thank you for doing more than 4 years of college ever did

Mükemmel olmuş hocam eline sağlık.

[@вдохновись-ч5э]

I do not know, if you saw my comment on previous video. But can you add additional feature to social app with users tiers and subscriptions. Like onlyfans or Patreon do?

[@Razes9ooo474lO4]

I am big fan of u from India... ThankQ for sharing

[@businessuser5146]

Can you implement more features into this app, whatever is mentioned on the left menu bar... groups, marketplace, memories, events, gaming, videos, etc

[@frontend1576]

Lama thank you so much....Really You are amazing.....Thank you So much.....Please make a video on advanced git.

[@ankitshah1655]

Love all your videos

[@RacyJose27]

What pattern are you exactly using? It can't be MVC as React is not object oriented. Thank you so much for the helpful tutorial btw!!

[@vishwjeetthakur4648]

bro have u completed the whole project I got some issue can u help?

[@cephaz6]

You make learning interesting Thank you so much 🙏

[@oscargm1979]

Ouyeah I am learning so much... I really appreciate you chose SQL as Database.Thank you again for an amazing project

[@nickleydeonyango1704]

What are some of the vs shortcuts that you are using in this video. Like the ability to select a couple of texts all at once

[@melihgunasti]

çok güzel öğretici bir video olmuş teşekkürler şafak hocam

[@linodref]

Hi Lama! Excellent content! I'm leaning React and I have a question about this tutorial. When I open a first Comments section all the comments related to the post show successfully. But, if that first Comments section remains open and then I open another Comments section from a different post, the comments inside both posts duplicates, and at the end both posts display the same comments, that is, the comments of the last Comments section opened. What could it be? Would you please check out what's going on?

[@TofuShifu]

Thanks for this project tutorials,I really appreciate it!!! And also,I've had some error while coding and these are how I solved them. Hope this help guys XD ***Error: { "code": "PROTOCOL_ENQUEUE_AFTER_FATAL_ERROR", "fatal": false } ->Fix: run again index.js (api> node index.js) and then try again ***Error: ER_NOT_SUPPORTED_AUTH_MODE in MyQSL -> Fix: in query,insert this code: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; (change ur 'password' now to another,Ex:123 to 456) And then fix this new password in connect.js ***Error: - Blank page when try to login fail( json undentified) ->Fix: try replace this code const [currentUser, setCurrentUser] = useState(() => { const storedUser = localStorage.getItem("user"); if (storedUser) { try { return JSON.parse(storedUser); } catch (error) { console.error("Error:", error); } } return null; }); ***Error: - Timeout reached in Insomnia -> Fix: check the correct link post,typo columns in MySQL,link in those event const handleRegister,... This error happens when something is wrong,so u have to check all ***Error: - Already accepted access for cors but still didn't work ->Fix: run again index.js (api> node index.js) and then try again ***Error: - localhost:8000/api/posts/ 500 (Internal Server Error) ->Fix: Change the code in post.js into export const getPosts=(req,res)=>{ const q= `SELECT p.*, u.id AS userID, u.name, u.profilePic FROM posts AS p JOIN users AS u ON u.id = p.userID` db.query(q,(err,data)=>{ if(err)return res.status(500).json(err); return res.status(200).json(data); }) } *This error happened when u had something in code got wrong,check around the place u last did *Remember to change the correct column of ur db *After changed it,run again api (api> node index.js) ***My Stupid Error (XD) : - return ( {error ? "Error!" : isPending ? "Loading..." : data.map((post) => )} ); when realse this code,some of the object doesn't appear on the main website -> Fix: Go to post.js in client change name of those objects equal to columns in MySQL EX: {post.postDesc} means there's a column name "postDesc" in ur posts db ***Error: - This.client.defaultMutationOptions is not a function react-query, pocketbase, nextjs -> Fix: Change Mutation code (lastest v5 for this time ) const mutation = useMutation({ mutationFn: (newPost) => { return makeRequest.post("/posts", newPost); }, onSuccess: () => { // Invalidate and refetch queryClient.invalidateQueries({ queryKey: ['[posts]'] }); }, }); ***Error: - Still error "Can't read properties of underfined(reading'map") after solved like in the video -> Fix: run again api ***Error: -Cannot read properties of undefined (reading 'includes' or 'length') at Post (localhost:3000/static/js/bundle.js:1294:27) -> Fix: Change code to this {isLoading ? ( "loading" ) : data?.includes(currentUser.id) ? ( ) : ( )} {data?.length} Likes ***Error: - 404 Not found -> Fix: check again those func such as Mutation,handle,upload,... Some place will be wrong when typing. Ex: makeRequest.post instead of put

[@musasherif304]

Thanks for sharing your knowledge with us

[@rizwanjamadar7722]

Hey Lama if you are reading this, I just want to thank you. I have one request can you create one video on complete guide of react-query.

[@letsOpenOurEyes3]

Is socket io is implemented in this project to connect different browsers as different users and chat . I want to build the same app with chat functionality.

[@yuliiashmidt6332]

Yes please, create redux tool kit query video 🙏 You are amazing teacher

[@iorolunemmanuel4579]

Thank you for the kind gesture. Iama please I would like see you implement forgot password in user authentication

[@andriyabu]

Awesome. Thank you sir.

[@albertgeorge1619]

Best of the best of the best!!!!

[@cevdet-gt3uu]

I can wait to watch the tutorial

[@danieljohnsz]

at 47:20 he says that the previous video is so important, which video is he referring to?

[@betterbehappythannot3605]

Amazing video, but is only my screen flashing weirdly in the beginning?

[@AmanSingh-gg6zc]

After updating the pictures are not visible in profile page... Neither profile and cover pic nor the posts picture although the description of posts are showing

[@alpeshpatel9029]

Thank you sir. Your tutorial is helpful. Can you please create tutorial on angular.

[@jamjam3337]

Thanks for the video👍👏

[@mandyuniverse5090]

after updating the photo the stories and the profiles photos in the home app is not changing

[@mksoftware91]

Great Project as allways!

[@nabinsaud4688]

Please use typescript for the next project

[@tha_real_misfit]

hi all, looking for some help with this. i have been following along and have a lot of issues when it comes to using insomnia. i first had issues when connecting to MySQL and had to change the index.js file to import the db. i have moved on from that and now having issues when trying to do the login part (39 mins) with insomnia. within my ide, i have npm running with the msgs, Api work and connected to database in the terminal, the problem is when i click send in insomnia i get the error, "Error: Failure when receiving data from the peer" I've tried looking online but couldn't find a solid solution. Any help is greatly appreciated.

[@prathamesh_dalvi9421]

copy the source code from the description github link and change the password of the db to urs

[@AmanSingh-gg6zc]

how did you solve the issue of insomnia.. i am getting error couldn't connect to the server

[@htr7254]

Hey Lama . I am facing a weird error , As I click on the login button screen get completely white blank and i cannot access screen again. Can you please help

[@roydondecastro]

If you are continuing it from part1, and you did a logout, delete the user in the localStorage.

[@kevinmitnick2634]

​@@roydondecastro how please help me 😢 im stuck in this from past 2 days 😢😢

[@kevinmitnick2634]

​@@roydondecastro At 51:38 in my application an in user there is no data in user but undefined is written and idk why my react app go blank after 50:55 please please please anyone can help me ?? I need solution please 😢

[@kjeanineatl]

I’m new to this and trying to follow along…when I try to add the libraries I get an error msg? When I type in YARN it says it’s not recognized. What does that mean and how do I fix it?

[@ashrafshehata6566]

thank you very much you teaching me a lot

[@poloiaish6281]

Can you do react, node, and mongodb? Good content as always. Keep it up.

[@nabinsaud4688]

Will you use prisma in the next project as ORM ?

[@OmarFaruk-bz4gw]

Oh nice Sir

[@Harlanb2002]

I get to the yarn command and I get this error: $ yarn 00h00m00s 0/0: : ERROR: There are no scenarios; must have at least one. What am I missing? I did the git clone command have the same files/directories as the video shows. Thanks...

[@donawisidagama9892]

@LamaDev Hi ! Thank you for this video. I want to develop a project like this using Spring Boot for Backend REST API. So how can I do that using this same project. Is it possible. Can you please guide me how to do that ? It would be a great help. Thanks. ❤

[@rahul-in8vb]

Thanks @lama dev.(Great work💯)❤ Can you upload sequelize+postgressSQL

[@jaymango805]

where did you post video about mysql installation?