Core Concepts

Learn the fundamentals of working with Drizzle DuckDB.

Topics

• Database Connection - Connect to in-memory, local file, or MotherDuck
• Schema Definition - Define tables, columns, and relations
• Queries - SELECT, INSERT, UPDATE, DELETE, CTEs, and aggregations
• Transactions - Atomic operations and rollback handling
• Array Operations - Working with LIST and ARRAY columns

---

Table of contents

• Database Connection
• Schema Definition
• Queries
• Transactions
• Array Operations