Free course

Drizzle ORM Course

Build a typed SQLite data layer with Drizzle ORM: schemas, migrations, CRUD, relations, transactions, tests, query plans, and production choices.

5 modules · 25 lessons · No signup

Prerequisites: TypeScript, SQL, SQLite and Node.js

Download this course as PDF or EPUB

Read it offline, on your Kindle, or print it. Join my free newsletter and you get this course plus every other book and course I published.

Download PDFDownload EPUB
~~~

Your progress

of lessons completed.

Course completed.

What you'll learn

Build, migrate, query, test, inspect, and prepare a complete Drizzle-powered notes data layer for deployment.

Course contents

  1. Drizzle foundations

    Choose Drizzle deliberately, set up the project, open SQLite, and inspect the first query.

    1. ✓ Choose Drizzle with open eyes
    2. ✓ Create the notes project
    3. ✓ Open SQLite with Drizzle
    4. ✓ Run and inspect the first query
    5. ✓ Check your understanding: drizzle foundations

  2. Schema and migrations

    Declare tables and constraints, configure Drizzle Kit, and apply reviewed migrations.

    1. ✓ Define users and notes
    2. ✓ Put rules in the schema
    3. ✓ Configure Drizzle Kit
    4. ✓ Generate, review, and apply migrations
    5. ✓ Check your understanding: schema and migrations

  3. Typed CRUD

    Insert, select, filter, update, and delete rows through narrow typed queries.

    1. ✓ Insert users and notes
    2. ✓ Select, filter, order, and limit
    3. ✓ Update one owned note
    4. ✓ Delete with a deliberate boundary
    5. ✓ Check your understanding: typed crud

  4. Relations and transactions

    Connect users and notes, compare joins, and keep related writes atomic.

    1. ✓ Separate foreign keys and relations
    2. ✓ Define one-to-many relations
    3. ✓ Choose a join or relational query
    4. ✓ Make multiple writes atomic
    5. ✓ Check your understanding: relations and transactions

  5. Test, inspect, and ship

    Infer useful types, test real databases, inspect plans, and change drivers deliberately.

    1. ✓ Infer select and insert types
    2. ✓ Test real queries in isolation
    3. ✓ Inspect SQL, plans, and data
    4. ✓ Change drivers and ship safely
    5. ✓ Check your understanding: test, inspect, and ship