721: You should learn Drizzle, the TypeScript SQL ORM

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

Episode source