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

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.