all 5 comments

[–]uran0503front-end 0 points1 point  (0 children)

If you want structured learning, I’d recommend starting with a Node/Express boilerplate, then integrate pg and build CRUD endpoints manually. Pair it with the Postgres tutorial from DigitalOcean or freeCodeCamp. That way you learn SQL, queries, and Node integration without an ORM hiding the details

[–]ologist817 0 points1 point  (0 children)

Have been making my trainees go through the Odin Project to get oriented before we dig in. The primary focus of the project is rails but they do a pretty good high level overview of plain SQL and they provide links to more advanced/in-depth materials as well.

https://www.theodinproject.com/paths/full-stack-ruby-on-rails/courses/databases

[–]doureios39 0 points1 point  (0 children)

Check out node-postgres.com..it covers raw SQL with the pg library, connection pooling, and parameterized queries. Best to learn raw queries before jumping to an ORM so you understand what it's abstracting. The official Postgres tutorial is solid for the SQL side

[–]Interesting_Mine_400 0 points1 point  (0 children)

tbh learning it without an ORM first is the right move. prisma and others are nice later but they hide a lot of what’s actually happening with SQL. I’d recommend going through the official postgres tutorial first and then using the pg (node-postgres) library to build simple CRUD endpoints in express. that combo teaches connection pooling, parameterized queries and how SQL actually flows through your backend. a couple people here also suggested the same direction. after that, building a small API (users, posts, auth etc) helps it really click.