tw-rl

Syntax - Tasty Web Development Treats - Hasty Treat - What is the n+1 problem?In this Hasty Treat, Scott and Wes talk about a common problem youâll encounter in your development career âÂ the n+1 problem. Hasura - Sponsor With Hasura, you can get a fully managed, production-ready GraphQL API as a service to help you build modern apps faster. You can get started for free in 30 seconds, or if you want to try out the Standard tier for zero cost, use the code âTryHasuraâ at this link:Â hasura.info. Weâve also got an amazing selection of GraphQL tutorials atÂ hasura.io/learn. Sentry - Sponsor If you want to know whatâs happening with your errors, track them withÂ Sentry. Sentry is open-source error tracking that helps developers monitor and fix crashes in real time. Cut your time on error resolution from five hours to five minutes. It works with any language and integrates with dozens of other services. Syntax listeners can get two months for free by visitingÂ Sentry.ioÂ and using the coupon code âtastytreatâ. Show Notes 05:00 - What is the n+1 problem? * The N+1 problem can happen in any language but is especially prevalent inÂ GraphQLÂ because itâs so easy to query relationships. 09:33 - The solution * The solution to the n+1 problem is to batch the queries. As you loop over each podcast, keep an array of host IDs to lookup. Once you have looped over the podcasts, make a single query to the database with your large array of podcast host Ids. 11:11 - Should you care? * Sometimes no: its often fine to do multiple DB Calls * Facebook DataLoader * Mercurious * Many ORMs take care of this for you * These then break it down into my appropriate SQL * MongoDBÂ Ruby: eager loading * Laravel ORMÂ does it * Aggregation pipelines * Prisma N+1:Â https://www.youtube.com/watch?v=7oMfBGEdwsc&vl=en * Mongoose Populate * Apollo Studio Tweet us your tasty treats! * Scottâs Instagram * LevelUpTutorials Instagram * Wesâ Instagram * Wesâ Twitter * Wesâ Facebook * Scottâs Twitter * Make sure to includeÂ @SyntaxFMÂ in your tweets

In this Hasty Treat, Scott and Wes talk about a common problem youâll encounter in your development career âÂ the n+1 problem. Hasura – Sponsor

With Hasura, you can get a fully managed, production-ready GraphQL API as a service to help you build modern apps faster. You can get started for free in 30 seconds, or if you want to try out the Standard tier for zero cost, use the code âTryHasuraâ at this link:Â hasura.info. Weâve also got an amazing selection of GraphQL tutorials atÂ hasura.io/learn. Sentry – Sponsor

If you want to know whatâs happening with your errors, track them withÂ Sentry. Sentry is open-source error tracking that helps developers monitor and fix crashes in real time. Cut your time on error resolution from five hours to five minutes. It works with any language and integrates with dozens of other services. Syntax listeners can get two months for free by visitingÂ Sentry.ioÂ and using the coupon code âtastytreatâ. Show Notes

05:00 – What is the n+1 problem?

* The N+1 problem can happen in any language but is especially prevalent inÂ GraphQLÂ because itâs so easy to query relationships.

09:33 – The solution

* The solution to the n+1 problem is to batch the queries. As you loop over each podcast, keep an array of host IDs to lookup. Once you have looped over the podcasts, make a single query to the database with your large array of podcast host Ids.

11:11 – Should you care?

* Sometimes no: its often fine to do multiple DB Calls
* Facebook DataLoader
* Mercurious
* Many ORMs take care of this for you

* These then break it down into my appropriate SQL
* MongoDBÂ Ruby: eager loading
* Laravel ORMÂ does it
* Aggregation pipelines
* Prisma N+1:Â https://www.youtube.com/watch?v=7oMfBGEdwsc&vl=en
* Mongoose Populate
* Apollo Studio Tweet us your tasty treats!

* Scottâs Instagram
* LevelUpTutorials Instagram
* Wesâ Instagram
* Wesâ Twitter
* Wesâ Facebook
* Scottâs Twitter
* Make sure to includeÂ @SyntaxFMÂ in your tweets

Gravnetic

podcastsIn this Hasty Treat, Scott and Wes talk about a common problem youâll encounter in your development career âÂ the n+1 problem. Hasura - Sponsor With Hasura, you can get a fully managed, production-ready GraphQL API as a service to help you build modern apps faster. You can get started for free in 30 seconds, or if you want to try out the Standard tier for zero cost, use the code âTryHasuraâ at this link:Â hasura.info. Weâve also got an amazing selection of GraphQL tutorials atÂ hasura.io/learn. Sentry - Sponsor If you want to know whatâs happening with your errors, track them withÂ Sentry. Sentry is open-source error tracking that helps developers monitor and fix crashes in real time. Cut your time on error resolution from five hours to five minutes. It works with any language and integrates with dozens of other services. Syntax listeners can get two months for free by visitingÂ Sentry.ioÂ and using the coupon code âtastytreatâ. Show Notes 05:00 - What is the n+1 problem? * The N+1 problem can happen in any language but is especially prevalent inÂ GraphQLÂ because itâs so easy to query relationships. 09:33 - The solution * The solution to the n+1 problem is to batch the queries. As you loop over each podcast, keep an array of host IDs to lookup. Once you have looped over the podcasts, make a single query to the database with your large array of podcast host Ids. 11:11 - Should you care? * Sometimes no: its often fine to do multiple DB Calls * Facebook DataLoader * Mercurious * Many ORMs take care of this for you * These then break it down into my appropriate SQL * MongoDBÂ Ruby: eager loading * Laravel ORMÂ does it * Aggregation pipelines * Prisma N+1:Â https://www.youtube.com/watch?v=7oMfBGEdwsc&vl=en * Mongoose Populate * Apollo Studio Tweet us your tasty treats! * Scottâs Instagram * LevelUpTutorials Instagram * Wesâ Instagram * Wesâ Twitter * Wesâ Facebook * Scottâs Twitter * Make sure to includeÂ @SyntaxFMÂ in your tweets

tw-rl

FireFox is blocking Twitter content

To view content on tw-rl, follow these steps...

open

open.spotify.com

My Notes:

Select to add to your #gallery:

Tobias van Schneider

soundcloud.com

My Notes:

Select to add to your #gallery:

peacevans

www.peacevans.com

My Notes:

Select to add to your #gallery:

pca

pca.st

My Notes:

Select to add to your #gallery:

podcasts

podcasts.apple.com

My Notes:

Select to add to your #gallery:

stitcher

www.stitcher.com

My Notes:

Select to add to your #gallery:

podcasts

podcasts.google.com

My Notes:

Select to add to your #gallery:

music

music.amazon.com

My Notes:

Select to add to your #gallery:

Nibel

@Nibellion

My Notes:

Select to add to your #gallery:

demetrios

@demetriosns

My Notes:

Select to add to your #gallery:

InteractiveInc

@interactiveinc

My Notes:

Select to add to your #gallery:

𝗧𝗵𝗲 𝗚𝗮𝗹𝗮𝗰𝘁𝗶𝗰 𝗘𝗺𝗽𝗶𝗿𝗲

@ImperialBase

My Notes:

Select to add to your #gallery:

Pro Curator

$99 /yearPay what you can