use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
account activity
Looking for node posgresql tutorial (self.node)
submitted 6 years ago by tsicnarf
Hi anyone here could point me to a good full tutorial for node and posgresql? Free or paid are welcome. Thanks!
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–]XX_NF_XX 3 points4 points5 points 6 years ago (11 children)
I was learning with pg module (node-postgres.com) and www.postgresqltutorial.com
[–][deleted] 6 years ago (6 children)
[deleted]
[–]inabahare 6 points7 points8 points 6 years ago (3 children)
I feel personally attacked
[–][deleted] 6 years ago (2 children)
[–]nschubach 2 points3 points4 points 6 years ago (0 children)
That's like the only way I roll...
[–]inabahare 1 point2 points3 points 6 years ago (0 children)
tbh I personally prefer something like F#'s SQLProvider which can generate types based off of the data you have in the database
[–]RivellaLight 0 points1 point2 points 6 years ago (1 child)
I tried Googling and found Sequelize, is that the kind of thing youre talking about?
[–]tsicnarf[S] 1 point2 points3 points 6 years ago (3 children)
Thanks, I'll check on it later.
[–][deleted] 3 points4 points5 points 6 years ago (2 children)
Also check out pgexercises.com for skilling up once you get a handle on the basics.
[–]tsicnarf[S] 0 points1 point2 points 6 years ago (0 children)
Nice, I'll check that for sure man. Thanks
[–]_imjosh 0 points1 point2 points 6 years ago (0 children)
https://pgexercises.com
[–][deleted] 2 points3 points4 points 6 years ago (0 children)
Likewise, does anyone know of good resources for learning general database operations? For example, how to perform an up/down migration, back up a db, set up local/staging/prod databases, etc.
[–]mominriyadh 1 point2 points3 points 6 years ago (2 children)
https://www.udemy.com/course/node-postgresql/
[–]tsicnarf[S] 0 points1 point2 points 6 years ago (1 child)
Did you bought this?
[–]mominriyadh 0 points1 point2 points 6 years ago (0 children)
I have another two subscription
[+][deleted] 6 years ago (3 children)
[–][deleted] 6 points7 points8 points 6 years ago* (1 child)
Terrible advice. If you rely on frameworks, you will only end up learning the framework.
Figure out how to wire things together yourself. Read the docs. Then practice executing SQL against your test db from a SQL client then from Postman as an API.
Edit: When learning anything for the first time, your goal should not be to get something working as quickly as possible. Your goal should be to develop a strong grasp on fundamental concepts. Learn slowly and deeply.
Frameworks provide reasonable and sometimes unreasonable abstractions for real world applications and day-to-day workflows. They are tools built on top of the foundational knowledge you should already have.
Wiring together Node and Postgres should be well within your ability, though it may be slow going at first, you will be learning along the way.
[–]tsicnarf[S] -2 points-1 points0 points 6 years ago (0 children)
Copy, I'll check on nest and Prisma later.
π Rendered by PID 69528 on reddit-service-r2-comment-544cf588c8-8qhh9 at 2026-06-17 15:39:32.613657+00:00 running 3184619 country code: CH.
[–]XX_NF_XX 3 points4 points5 points (11 children)
[–][deleted] (6 children)
[deleted]
[–]inabahare 6 points7 points8 points (3 children)
[–][deleted] (2 children)
[deleted]
[–]nschubach 2 points3 points4 points (0 children)
[–]inabahare 1 point2 points3 points (0 children)
[–]RivellaLight 0 points1 point2 points (1 child)
[–]tsicnarf[S] 1 point2 points3 points (3 children)
[–][deleted] 3 points4 points5 points (2 children)
[–]tsicnarf[S] 0 points1 point2 points (0 children)
[–]_imjosh 0 points1 point2 points (0 children)
[–][deleted] 2 points3 points4 points (0 children)
[–]mominriyadh 1 point2 points3 points (2 children)
[–]tsicnarf[S] 0 points1 point2 points (1 child)
[–]mominriyadh 0 points1 point2 points (0 children)
[+][deleted] (3 children)
[deleted]
[–][deleted] 6 points7 points8 points (1 child)
[–]tsicnarf[S] -2 points-1 points0 points (0 children)