Optimizing Data Management in Applications

In this episode of Syntax, Wes and Scott talk about what APIs are, the API standards that exist, and walk through the various layers of what goes into making an API.

Payments Hub - Sponsor

There are hundreds of payments processing companies out there. Hit up developer.paymentshub.com/syntax to learn more about how Payments Hub Developers not only processes ecommerce and in-person payments, but also boards and underwrites your merchants in as little as 90 minutes. We are currently offering Syntax listeners who become new partners 6 months free data through our Business Reporting API!

LogRocket - Sponsor

LogRocket lets you replay what users do on your site, helping you reproduce bugs and fix issues faster. It’s an exception tracker, a session re-player and a performance monitor. Get 14 days free at logrocket.com/syntax.

Freshbooks - Sponsor

Get a 30 day free trial of Freshbooks at freshbooks.com/syntax

Show Notes

• 00:10 Welcome
• 02:40 What are APIs?
• 06:09 API Standards
• 13:56 What about GRPC?
• 15:52 What is TRPC?
• 19:19 Sponsor: Payments Hub
• 20:25 API Cake Layers
• mySQL
• Postgres
• Mongo DB
• SQLite
• SQLizer
• 26:51 Server layer
• 33:28 Sponsor: LogRocket
• 34:36 Authentication layer
• 43:28 Caching layer
• 46:09 Sponsor: Freshbooks
• 46:38 Client layer
• Prisma: Package, but also a service
• keystone: Package
• Strapi: Package
• Sanity: Service
• Prismic: Service
• Hasura: Open Source and Service
• Contentful
• https://hygraph.com/
• 48:01 Should I use x or y?
• 51:35 Tools
• GraphQL Playground
• Graphiql
• Postman
• Insomnia
• TablePlus
• Studio3T
• 56:27 SIIIIICK ××× PIIIICKS ×××
• 00:20 Knife Talk

××× SIIIIICK ××× PIIIICKS ×××

• Scott: Sharp Pebble
• Wes: Laser level

Shameless Plugs

• Scott: LevelUp Tutorials
• Wes: Wes Bos Tutorials

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