SQLite Databases in Bun | Beginner's Guide to Bun #9

Hey everyone, I'm Average. In this episode of "Beginner's Guide to Bun" we check out Bun's native SQLite driver. Inspired by better-sqlite3, it let's us create and use SQLite databases with ease. It's zero-hassle, fast, and extremely versatile. We go through some basic operations using Bun's driver including creating a database, creating/deleting a table, querying a table, prepared statements & queries, transactions, and even type-enforced query returns. Thanks for watching! Bun SQLite: https://bun.com/docs/runtime/sqlite Use Drizzle ORM w/ Bun driver: https://bun.com/docs/guides/ecosystem... Bun Website: https://bun.com [00:00] - Intro [00:54] - Setting Up the Project [01:09] - Creating the Database Connection [02:08] - Creating a Table [03:25] - Querying Data [04:03] - Dropping Tables [05:26] - Inserting Data with Prepared Statements [06:47] - Fetching Specific Users [07:31] - Typing Query Results [08:45] - Iterating Through Rows [09:21] - Transactions & Rollbacks [10:41] - Outro