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

In this supper club episode of Syntax, Wes and Scott talk with James Mikrut about Payload, how Payload isn’t just a CMS, where Payload fits in a tech stack, why they picked Drizzle for an ORM, what Payload Cloud is, and where’s the Rails for JavaScript?

Show Notes

• 00:31 Welcome
• 02:00 Who is James Mikrut and what’s the idea behind Payload?
• 05:22 Payload isn’t just a CMS
• Payload
• Payload on GitHub
• Payload on Twitter
• Payload on YouTube
• 09:08 Where does Payload fit in the tech stack?
• KeystoneJS
• Supabase
• Retool
• 11:22 Is Payload using TypeScript?
• 13:44 Why did you pick Drizzle?
• Drizzle ORM
• 18:08 Do you have to maintain MongoDB and Drizzle?
• SvelteKit
• 26:31 Does Payload have visual editing elements?
• 30:34 Do you build a custom UI for users?
• 35:10 What is Payload Cloud?
• 38:12 Where is the Rails for JavaScript?
• Next.js by Vercel
• Laravel Spark
• Deploy your Laravel PHP application painlessly
• RedwoodJS: The App Framework for Startups | RedwoodJS.com
• 41:39 How do you manage contributions from open source?
• 43:46 GitHub + AI
• 48:18 Syntax Brought to you by Sentry
• Error Management Magic: Introducing the Sentry Plugin for Payload
• 50:26 Supper Club questions

Shameless Plugs

Payload on GitHub

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 supper club episode of Syntax, Wes and Scott talk with Nikolas Burk from Prisma about the role an ORM plays in a tech stack, how Prisma has changed over the years, ways to query data in Prisma, and how migrations work with Prisma.

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.

Storyblok - Sponsor

Storyblok is a headless component-based CMS with a real-time visual editor. It offers the flexibility for developers to craft their perfect tech stack, but it also empowers content creators to make changes independently. The result is that every team has the freedom to quickly and easily create the ideal website with limitless extensibility. Other key features include robust Storyblok SDKs and APIs, powerful internationalization options, and an eCommerce-ready platform.

FireHydrant - Sponsor

Incidents are hard. Managing them shouldn’t be. FireHydrant makes it easy for anyone in your organization to respond to incidents efficiently and consistently. Intuitive, guided workflows provide turn-by-turn navigation for incident response, while thoughtful prompts and powerful integrations capture all of your incident data to drive useful retros and actionable analytics.

Did we mention that FireHydrant is free? Get started at Firehydrant.com/syntax.

Show Notes

• 00:35 Welcome
• 01:30 Guest intro
• @NikolasBurk on Twitter
• 04:56 How has Prisma evolved?
• Prisma
• Keystone
• GraphQL
• 10:44 What was Prisma V1?
• 17:04 Is there any GraphQL specific functions in Prismic?
• 21:26 Sponsor: Hasura
• 22:26 What role does an ORM play in a tech stack?
• 29:54 What is Planetscale?
• Planetscale
• The T3 Stack
• 32:22 Where does TRPC fit?
• tRPC
• 33:46 Sponsor: Storyblok
• 35:28 What is an ORM?
• Prisma VS Code plugin
• 42:00 How do migrations work with Prisma?
• 45:58 Query your data with Prisma client
• 49:43 Have you looked into alternative JavaScript environments?
• 55:16 Sponsor: FireHydrant
• 57:05 Supper Club questions
• 58:50 SIIIIICK ××× PIIIICKS ×××

××× SIIIIICK ××× PIIIICKS ×××

• Lichess

Shameless Plugs

• Prisma blog

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