I tried 8 different Postgres ORMs

#sql #javascript #webdevelopment

[cjgj]

The real ORM is the friends we made along the way -- Our Real Mates

[hanifali]

0:20 (S-Q-L), 0:31 (Squeal), 0:52 (Sequel) He pronounced SQL all three different ways so everyone is happy 😂

[dbreen]

The timing of this video is impeccable. Been spending the last few days looking into these ORMs

[tyu]

MikroORM should be on this list. Has all the benefits of an ORM, but lets you easily fall back to a Knex-like query builder when needed. And crucially, it's much better maintained than Sequelize or TypeORM

[elitalpa]

I watched this video again to remember the differences between certain libraries and ORMs so I made a list:

1. 1:30 pg
2. 3:24 postgres.js
3. 4:11 knex
4. 5:20 kysely
5. 6:13 sequelize
6. 7:11 typeorm
7. 7:55 prisma
8. 8:51 drizzle-orm


May this be helpful to someone else as well.

[MateHomolya]

This video is so well timed, I was literally transitioning from Firestore to Postgres database with a project just now.

[petrsehnal]

Breaking world record for most useful information per second of video each time you post someting. Respect, Sir!

[clingyking]

This guy has the most useful content, without wasting any time.

[TechDiffuse]

Awesome job Jeff. Thanks for creating such a concise and entertaining video.

[angmathew]

I was less inclined to watch this earlier but, hey man, you rocks. Lots of clear and concise stuff in the video.

[agammore]

Awesome video! And amazing that you're giving a free consultation, people should flock for that!

[ileies]

Hours of research without real outcome and then one video and I know what to choose.
You're my favorite YouTuber for a reason. 😋

[ruaidhrilumsden]

I can understand the Web dev community generally straying away from writing raw SQL, but as an analyst moving to Javascript from having written primarily SQL for the past 6yrs it can be a bit frustrating that the whole ecosystem is based on trying not to do what I'm most comfortable doing - it feels like my mad SQL skills are being somewhat nullified!

Great vid Jeff, I haven't seen postgres js before - I will defo be using it.

[tenthlegionstudios]

Snuck in a video in response to the codedam issues with Prisma. Like your approach here - mentioning all pros and cons, going over each option. Great work!

[bugs]

Great video. I'd enjoy an overview of ORMs in other languages too, such as SqlAlchemy, Entity Framework, etc.

[Mixesha]

MikroORM is awesome and deserve more love. It does what all these ORM do and is battle tested, fast, and well maintained.

[kai]

Thank you. Perfect timing, that exactly what i'm looking for.

[letstalkdev]

First 20 seconds of this video, the story of my life! :D
Great job making these videos fun, so we can all have a bit of a laugh and not take ourselves too seriously, especially when it comes to the technology stack used.
I've also made a video on this topic on my channel recently.

[chrisalexthomas]

lol, the ending was perfect :D well done Mr Fireship

I'm currently using pg + postrgrator for migrations + sql-ts to generate types from DB. Works like charm. Type checking of sql is done by my IDE (intellij) anyway.