The ORMazing show

JS Party: JavaScript, CSS, Web Development

Nick & KBall sit down with the brilliant Stephen Haberman to discuss all things ORMs! 💻🔍

From the advantages and disadvantages of ORMs in general, to delving into the intricacies of his innovative project Joist, which brings a fresh, idiomatic, ActiveRecord-esque approach to TypeScript. 🚀

So sit back, relax, and let’s dive deep into the world of ORMs with the experts!

Join the discussion

Changelog++ members save 2 minutes on this episode because they made the ads disappear. Join today!

Sponsors:

• Fastly – Our bandwidth partner. Fastly powers fast, secure, and scalable digital experiences. Move beyond your content delivery network to their powerful edge cloud platform. Learn more at fastly.com
• Fly.io – The home of Changelog.com — Deploy your apps and databases close to your users. In minutes you can run your Ruby, Go, Node, Deno, Python, or Elixir app (and databases!) all over the world. No ops required. Learn more at fly.io/changelog and check out the speedrun in their docs.
• KBall Coaching – Free exploratory coaching sessions from JS Party co-host KBall! Click here to get started

Featuring:

• Stephen Haberman – Website, GitHub, LinkedIn, X
• Nick Nisi – Website, GitHub, Mastodon, X
• Kevin Ball – Website, GitHub, LinkedIn, X

Show Notes:

• TypeScript: Documentation - Mapped Types
• Hello from Joist | Joist
• TypeORM - Amazing ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
• Active Record Basics — Ruby on Rails Guides
• graphql/dataloader: DataLoader is a generic utility to be used as part of your application’s data fetching layer to provide a consistent API over various backends and reduce requests to those backends via batching and caching.
• facebook/Haxl: A Haskell library that simplifies access to remote data, such as databases or web-based services.
• Working with Entity Manager | MikroORM
• Object-Relational Mapping is the Vietnam of Computer Science
• kysely-org/kysely: A type-safe typescript SQL query builder
• Validation Rules | Joist
• Derived Fields | Joist
• The Streaming Database | Materialize
• PostgreSQL: The world’s most advanced open source database
• PostgreSQL: Documentation: 15: 41.3. Materialized Views
• Joist Slack

Something missing or broken? PRs welcome!

Chapter

1. It's party time, y'all (00:00:00)

https://changelog.com/news

2. Welcoming Stephen (00:00:56)

3. Did you hear that, Jerod? (00:02:37)

4. Defining "ORM" (00:03:16)

5. Why write a new ORM? (00:05:10)

6. The data loader pattern (00:11:47)

7. Joist vs ActiveRecord (00:17:07)

8. Why Joist uses type hints (00:21:49)

9. When Joist uses promises (00:28:56)

10. Joist's API details (00:32:16)

11. Sponsor: KBall Coaching (00:35:58)

https://www.kball.llc/coaching

12. Where the biz logic goes (00:36:43)

13. Lifecycle hooks (00:40:16)

14. No cycles please (00:44:42)

15. Batching & ergonomics (00:46:03)

16. Arguments against ORMs (00:50:55)

17. Thinking in entities (00:55:09)

18. Reactivity in Joist (01:00:27)

19. KBall is excited (01:06:57)

20. Wrapping up (01:09:51)

21. Next up on the pod (01:11:15)