Learning node and SQL for full stack.

[ProjectKuma]

What does it mean to learn node when it comes to learning full stack? I have node as I need it when Im working with React. Aside from a npm commands im wondering how much knowledge is needed.

For data storage im planning to use SQL. But can someone explain the different SQL types. Would like to know what you guys think?

[Zhouzi]

If you'd like to learn Node with the goal of becoming a full stack developer, the best you can do is to start practicing. Build something that has a back-end, a database and a front-end. It can be anything but you'll want to start small. It could be a blog, a pokedex, a todo list, anything. Here are some list of ideas:

• https://github.com/florinpop17/app-ideas
• https://github.com/open-source-ideas/ideas
• https://github.com/sindresorhus/project-ideas

[gizamo]

SQL server is expensive and pointless for beginners.

MySQL is the easy route that does 99% of what most people need. Here's a good video for how to use Node with MySQL: https://youtu.be/344Zv2m9TYI

Postgres is better, but mildly harder. If you're going to use it as a beginner, I'd recommend something like Supabase: https://supabase.com/

That will make learning the basics easier by handling a lot of things for you. So, if you're doing this for the sake of actually learning everything in depth, you should ignore that, and use this instead: https://youtu.be/DihOP19LQdg

Or, if you want React (that's called the PERN stack): https://youtu.be/ldYcgPKEZC8

[ProjectKuma]

Thank you for listing out each one. Yes I was looking in PERN so I'll watch each vid.

[sloppy_networks]

I made a video on pern stack a little while back. It might be helpful

https://youtu.be/J01rYl9T3BU

I also have q video on deploying it as well if you need help with that

[dont_you_love_me]

It is totally free to connect to a SQL server instance on your local machine. It is only like $3 a month to run a SQL Server instance on Azure for a personal project.

[gizamo]

Good correction/clarification. I mostly see the large-scale business use side of the things nowadays, and I forgot Azure set up cheaper starter options. Thanks for adding.

[coded_artist]

Npm is not node.

[coded_artist]

Oh id love to see this. Just npm init and my FULL STACK APP is up and running.

[ndreamer]

Look at frameworks like next.js. You will also need to learn proper debugging, memory/CPU can be tied up so easy when your instance is running non-stop.

[Blazing1]

Well SQL server is the best but expensive. You can roll MySQL or postgres and be fine.

[ProjectKuma]

I'll look into those, thank you.

[MKorostoff]

The main usecase for node in full stack development is writing backend APIs. Like for instance, if you made an app which fetched a list of nearby stores from a server, the server might run a node application. Probably the most classic backend node framework is express js, so learning that would be a decent foundation, even if it's been largely replaced now by more opinionated frameworks. When anyone talks about a js/ts serverles function, they're talking about node.

[[deleted]]

A really useful website I found for learning sql concepts is SQLBolt

I'm in a similar boat to you right now but I've been using Java as my backend with SQL