In today's episode, Charles, Steve, and AJ, are joined by back-end engineer and team lead at Homebound, Stephen Haberman. We delve into the fascinating world of SQL c and its revolutionary approach to managing SQL queries with dedicated SQL files, delivering benefits such as reduced typing errors and pre-deployment checks. Stephen also walks us through the advantages and limitations of ORMs versus query builders like Prisma and Drizzle, sharing insights into Joyce ORM's unique philosophy and simplified CRUD operations.
They explore the intricacies of Domain Driven Design (DDD), its emphasis on ubiquitous language, and how it shapes business logic and storage management. AJ contributes by discussing the potential of SQL c and Slonik for dynamic query building. Additionally, they discuss Steven's innovative work with GraphFileWorker and GrafAST, highlighting the performance improvements in GraphQL backends. Whether you're intrigued by the technicalities of ORMs, the evolution of database tools, or just love a good anecdote, this episode packed with technical insights and lively discussions is one you won't want to miss. Join them on this journey into the world of database management and development!

Socials

LinkedIn: Stephen Haberman

Picks

AJ - TypeScript to JSDoc
AJ - MySQL to TypeScript
AJ - sqlc
AJ - Slonik (Node + Postgres)
AJ - SwiftUI Essentials
AJ - Introduction to SwiftUI
AJ - Trump, but not saying dumb things
Charles - Biblios | Board Game
Charles - FreeStyle Libre 3 System | Continuous Glucose Monitoring
Stephen - Grafast | Grafast

Become a supporter of this podcast: https://www.spreaker.com/podcast/javascript-jabber--6102064/support.

Optimizing SQL and ORM Practices for High-Performance Applications - JSJ 650

JavaScript Jabber