datamanagement

We’re doing a Tasty overview of Drizzle in this episode. What is Drizzle? What are different types of databases? How do you host databases? What have we built with Drizzle? And how does Drizzle handle relational data, TypeScript, querying, selects, transactions, and more!

Show Notes

• 00:10 Welcome

• 00:52 Syntax Brought to you by Sentry

• 01:50 What is Drizzle?

• 09:11 Different types of databases

• 17:58 Why pay for SQLite hosting?

• 20:36 Defining your data structures

• 24:27 What we’ve built using Drizzle

• 28:28 Relational data

• 36:17 TypesScript and Drizzle

• 40:53 Querying + Selects with Drizzle

• 46:23 Transactions

• 47:09 Syntax Drizzle Studio theme

• 48:27 Sick Picks

• Drizzle ORM

• Drizzle ORM - Overview

• Meet Drizzle Studio

• Benchmarks

• Sequel Pro

• TablePlus

• phpMyAdmin

• Cloudflare D1

• Bun

• habitpath.io

• Chartable

• Neon

• Answer Overflow

• Drizzle Studio Themes

Sick Picks

• Scott: BlackBerry - Apple TV (CA)
• Wes: Candle Warmer Lamp

Shameless Plugs

• Syntax Tiktok

Hit us up on Socials!

Syntax: X Instagram Tiktok LinkedIn Threads

Wes: X Instagram Tiktok LinkedIn Threads

Scott: X Instagram Tiktok LinkedIn Threads

In this episode of STBYM’s The Monstrefact, Robert discusses the horror of the Boxenwolf…

See omnystudio.com/listener for privacy information.

After nearly 16,000 cases disappeared off coronaviruses spreadsheets, we ask what went wrong. How common are lasting symptoms from Covid-19? If you survey people about the death toll from Covid, they’ll make mistakes. What do those mistakes teach us? Pedants versus poets on the subject of exponential growth. And we dive deep into the unholy marriage of mathematicians, gamblers, and actuaries at the dawn of modern finance.

Snipcart — Sponsor

Snipcart allows you to create online shopping carts without any backend work. It's entirely client-side which means it's the perfect fit for anyone building a SPA in React, Angular or any other framework. Check out the full list of features over at Snipcart.com/syntax and sign up for three months free!

Freshbooks — Sponsor

If you are a small business or freelancer check out Freshbooks.com Cloud Accountingand get 30 days free. Make sure to enter SYNTAX into the "How did you hear about us" section.

{ show(id: 027) { notes }}

02:40

• What is GraphQL anyways?
• GraphQL Relational Data

04:45

• How is it different than REST?

08:30

• GraphQL's self documenting Nature

09:20

• You don't need to replace your existing REST api
• It can sit infront of multiple APIs

10:00

• GraphQL Resolvers
• Apollo Link State does local data as well

11:50

• GraphQL on the client side
• Relay
• Apollo
• GraphQL Request
• Lokka
• Nano

13:30

• Why we like Apollo
• Setup is amazingly fast

15:00

• Pagination
• Refreshing of data

18:00

• The GraphQL Core Concepts
• Queries
• Mutations
• Filtering and Sorting
• It's not really a query language

21:00

• How do you say Schema?

22:00

• More on Resolvers

22:50

• Mutations
• Updating the cache

27:00

• Using with existing APIs
• Do you have two schemas now? One for MongoDB and one for GraphQL?

35:00

• CMS and Static Site Generators that run on GraphQL
• Gatsby
• WP-GraphQL
• GraphCMS

45:00

• Graph Cool

53:00

• Apollo Link
• Apollo VS Redux

56:00

• Graphiql

SIIIIICK PICKS

• Wes: The Indicator Podcast
• Scott: You Don't Know JS

Shameless Plugs

• Free GraphQL Tuts from Scott
• CSS Grid Course is coming sooooon!

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