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

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

Picks


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

Episoder(736)

High-Performance Networking: Key Resources and Tools for Web Developers - JSJ 637

High-Performance Networking: Key Resources and Tools for Web Developers - JSJ 637

Robin Marx is a Web Protocol and Performance Expert at Akamai. They dive deep into the fascinating world of networking performance, where experts share invaluable resources and insights to optimize yo...

25 Jun 20241h 22min

Transforming React Development: The Experimental Compiler’s Approach to Memoization and Performance - JSJ 636

Transforming React Development: The Experimental Compiler’s Approach to Memoization and Performance - JSJ 636

In this episode, they dive deep into the latest advancements in React with a special focus on the experimental React Compiler. Our guest speakers, Sathya Gunasekaran and Joe Savona, share their insigh...

18 Jun 20241h 29min

Practical Strategies for Web Optimization: Using Chrome DevTools - JSJ 635

Practical Strategies for Web Optimization: Using Chrome DevTools - JSJ 635

Jack Franklin is a Senior Software Engineer at Google. They dive deep into the world of performance optimization. They explore the sophisticated capabilities of Chrome DevTools, focusing on the perfor...

11 Jun 20241h 24min

New Frontiers in Web Platform Development with Bruce Lawson - JSJ

New Frontiers in Web Platform Development with Bruce Lawson - JSJ

In this episode, they dive into the world of web development, featuring insightful discussions on the differences and costs associated with hiring React Native developers, the importance of understand...

4 Jun 20241h 19min

Building a Custom Front-end Framework - JSJ 633

Building a Custom Front-end Framework - JSJ 633

Zach Lankton is the Product Engineer at Signature Payments. They dive deep into the world of software development and tech innovations. In this episode, they explore a wide range of topics, the main f...

28 Mai 20241h 21min

Sentry's Impact on Web Vitals Understanding - JSJ 632

Sentry's Impact on Web Vitals Understanding - JSJ 632

Lazar Nikolov is a Full-stack engineer. They engage in a deep exploration of diverse subjects, from historical veracity and book recommendations to crucial insights on web performance monitoring tools...

21 Mai 20241h 25min

Embracing Angular's Evolution with Santosh Yadav - JSJ 631

Embracing Angular's Evolution with Santosh Yadav - JSJ 631

Santosh Yadav is a Google Developer Expert for Angular. They dive into the world of JavaScript and development. The discussion centers around the topic of why Angular is considered the best framework,...

7 Mai 20241h

Web3 with Nik Kalyani - JSJ 630

Web3 with Nik Kalyani - JSJ 630

Feel like you don’t know enough about Web3? Don’t worry, neither do we. That’s where these podcasts come in! In this new episode, the Jabberers sit down with Nik Kalyani, the founder of Decentology an...

30 Apr 20241h 24min

Populært innen Business og økonomi

stopp-verden
dine-penger-pengeradet
e24-podden
rss-penger-polser-og-politikk
rss-borsmorgen-okonominyhetene
finansredaksjonen
utbytte
pengesnakk
pengepodden-2
livet-pa-veien-med-jan-erik-larssen
morgenkaffen-med-finansavisen
lydartikler-fra-aftenposten
tid-er-penger-en-podcast-med-peter-warren
okonomiamatorene
lederpodden
rss-markedspuls-2
rss-investering-gjort-enkelt
flypodden
shifter
rss-fa-makro