Charles M Wood

Vzdělání

Byznys

Jak na to

Technika

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

JavaScript Jabber

Stay current on JavaScript, Node, and Front-End development. Learn from experts in programming, careers, and technology every week. Become a supporter of this podcast: <a href="https://www.spreaker.com/podcast/javascript-jabber--6102064/support?utm_source=rss&utm_medium=rss&utm_campaign=rss">https://www.spreaker.com/podcast/javascript-jabber--6102064/support</a>.

 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!SocialsLinkedIn: Stephen HabermanPicks AJ - TypeScript to JSDocAJ - MySQL to TypeScriptAJ - sqlcAJ - Slonik (Node + Postgres)AJ - SwiftUI EssentialsAJ - Introduction to SwiftUI AJ - Trump, but not saying dumb thingsCharles - Biblios | Board GameCharles - FreeStyle Libre 3 System | Continuous Glucose MonitoringStephen - Grafast | GrafastBecome a supporter of this podcast: https://www.spreaker.com/podcast/javascript-jabber--6102064/support.

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 <ul><li><a href="https://www.linkedin.com/in/stephenhaberman/" target="_blank" rel="noreferrer noopener">LinkedIn: Stephen Haberman</a></li></ul> Picks  <ul><li>AJ - <a href="https://www.npmjs.com/package/ts-to-jsdoc" target="_blank" rel="noreferrer noopener">TypeScript to JSDoc</a></li><li>AJ - <a href="https://www.npmjs.com/package/mysql-dump-ts" target="_blank" rel="noreferrer noopener">MySQL to TypeScript</a></li><li>AJ - <a href="https://sqlc.dev/" target="_blank" rel="noreferrer noopener">sqlc</a></li><li>AJ - <a href="https://github.com/gajus/slonik#slonik-usage" target="_blank" rel="noreferrer noopener">Slonik (Node + Postgres)</a></li><li>AJ - <a href="https://developer.apple.com/videos/play/wwdc2024/10150/" target="_blank" rel="noreferrer noopener">SwiftUI Essentials</a></li><li>AJ - <a href="https://developer.apple.com/videos/play/wwdc2020/10119/" target="_blank" rel="noreferrer noopener">Introduction to SwiftUI </a></li><li>AJ - <a href="https://www.youtube.com/watch?v=f92WNzXoabg" target="_blank" rel="noreferrer noopener">Trump, but not saying dumb things</a></li><li>Charles - <a href="https://boardgamegeek.com/boardgame/34219/biblios" target="_blank" rel="noreferrer noopener">Biblios | Board Game</a></li><li>Charles - <a href="https://www.freestyle.abbott/uk-en/products/freestyle-libre-3.html?srsltid=AfmBOoq-dURFOCodG-EoOMTp2woVGfjwn2g6Kn2moOs7oMGCFxyzIEBn" target="_blank" rel="noreferrer noopener">FreeStyle Libre 3 System | Continuous Glucose Monitoring</a></li><li>Stephen - <a href="https://grafast.org/" target="_blank" rel="noreferrer noopener">Grafast | Grafast</a></li></ul> Become a supporter of this podcast: <a href="https://www.spreaker.com/podcast/javascript-jabber--6102064/support?utm_source=rss&utm_medium=rss&utm_campaign=rss">https://www.spreaker.com/podcast/javascript-jabber--6102064/support</a>.

Aplikace Youradio Talk

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

Poslechněte si podcast