How do I define database schema?

# Step 2: Create Schema Files In `src/db/index.ts`, set up DB connection: ```ts import Database from 'better-sqlite3'; import { drizzle } from 'drizzle-orm/better-sqlite3'; import * as path from 'path'; import { fileURLToPath } from 'url'; const __filename = fileURLToPath(import.meta.url); const __dirname = path.dirname(__filename); const sqlite = new Database(path.join(__dirname, '../drizzle.db')); export const db = drizzle(sqlite); ``` In `src/db/schema/users.ts`: ```ts import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core'; export const users = sqliteTable('users', { id: integer('id').primaryKey({ autoIncrement: true }), name: text('name').notNull(), email: text('email').notNull().unique() }); export type User = typeof users.$inferSelect; export type NewUser = typeof users.$inferInsert; ``` In `src/db/schema/index.ts`: ```ts export * from './users'; ```

How do I configure migrations and apply schema?

# Step 3: Set Up Drizzle Kit Create `drizzle.config.ts`: ```ts import type { Config } from 'drizzle-kit'; export default { schema: './src/db/schema/*.ts', out: './drizzle', dialect: 'sqlite', dbCredentials: { url: './src/db/drizzle.db' } } satisfies Config; ``` Add to `package.json` scripts: ```json "db:push": "drizzle-kit push:sqlite", "db:studio": "drizzle-kit studio" ``` Run: ```bash npm run db:push npx drizzle-kit studio ``` This creates the DB file and opens Studio for inspection.

How do I implement crud operations?

# Step 4: Build and Test CRUD Create `src/crud.ts`: ```ts import { db } from './db/index.js'; import { users, type NewUser } from './db/schema/index.js'; import { eq } from 'drizzle-orm'; async function main() { // Create const newUser: NewUser = { name: 'John Doe', email: 'john@example.com' }; await db.insert(users).values(newUser); console.log('User created'); // Read const allUsers = await db.select().from(users); console.log('All users:', allUsers); // Update await db.update(users).set({ name: 'Jane Doe' }).where(eq(users.email, newUser.email)); console.log('User updated'); // Delete await db.delete(users).where(eq(users.email, newUser.email)); console.log('User deleted'); } main(); ``` Run: `npx tsx src/crud.ts`

How do I add relations and advanced queries?

# Step 5: Define Relations Add `posts` schema in `src/db/schema/posts.ts`: ```ts import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core'; import { users } from './users.js'; export const posts = sqliteTable('posts', { id: integer('id').primaryKey({ autoIncrement: true }), title: text('title').notNull(), userId: integer('user_id').references(() => users.id) }); ``` Update `src/db/schema/index.ts` to export posts. In `src/db/relations.ts`: ```ts import { relations } from 'drizzle-orm'; import { users, posts } from './schema/index.js'; export const usersRelations = relations(users, ({ many }) => ({ posts: many(posts) })); export const postsRelations = relations(posts, ({ one }) => ({ author: one(users, { fields: [posts.userId], references: [users.id] }) })); ``` Update DB conn `src/db/index.ts`: ```ts import { relations } from 'drizzle-orm'; // ... existing export const db = drizzle(sqlite, { schema: { users, posts, usersRelations, postsRelations } }); ``` Query in new `src/relations.ts`: ```ts import { db } from './db/index.js'; const usersWithPosts = await db.query.users.findMany({ with: { posts: true } }); console.log(usersWithPosts); ``` Re-run `npm run db:push`, insert data, then `npx tsx src/relations.ts`.

Master Drizzle ORM: Type-Safe SQL in 5 Steps

Q: How do I set up project and install drizzle orm?

# Step 1: Initialize Your Environment Create a new directory and set up a Node.js project: ```bash mkdir drizzle-learn && cd drizzle-learn npm init -y npm pkg set type=module ``` Install Drizzle ORM with SQLite (local DB, no setup needed) and TypeScript tools: ```bash npm i drizzle-orm better-sqlite3 dotenv npm i -D drizzle-kit typescript tsx @types/better-sqlite3 @types/node npx tsc --init ``` Update `tsconfig.json`: ```json { "compilerOptions": { "target": "ESNext", "module": "ESNext", "strict": true, "esModuleInterop": true, "skipLibCheck": true, "forceConsistentCasingInFileNames": true } } ``` Create folders: `mkdir -p src/db/schema`

🧰

Instant Toolkit

2 artifacts

📋
Step-by-Step Guide

1

Step 1: Initialize Your Environment

Create a new directory and set up a Node.js project:

mkdir drizzle-learn && cd drizzle-learn
npm init -y
npm pkg set type=module

Install Drizzle ORM with SQLite (local DB, no setup needed) and TypeScript tools:

npm i drizzle-orm better-sqlite3 dotenv
npm i -D drizzle-kit typescript tsx @types/better-sqlite3 @types/node
npx tsc --init

Update tsconfig.json:

{
  "compilerOptions": {
    "target": "ESNext",
    "module": "ESNext",
    "strict": true,
    "esModuleInterop": true,
    "skipLibCheck": true,
    "forceConsistentCasingInFileNames": true
  }
}

Create folders: mkdir -p src/db/schema

Why this step matters:

-Establishes a reproducible development environment
-Allows immediate hands-on coding without external dependencies

15-30 minutes

Node.js, npm/yarn, VS Code, Terminal

$0

Definition of Done

•New project folder with package.json
•All packages installed without errors
•tsconfig.json configured

Common Mistakes to Avoid

❌ Skipping 'type=module' in package.json

→Run 'npm pkg set type=module' for ES modules support

❌ Installing without -D for dev tools

→Use 'npm i -D' for typescript, drizzle-kit

2

Following along, or just reading? 👀

Spin up a personalized “learn Drizzle ORM” plan you can save, check off, and return to anytime — unlimited on the free trial.

Start free trial →

3

4

5

🎥
Suggested Videos

Drizzle ORM Tutorial - Full Drizzle Course for Beginners

Learn Drizzle In 60 Minutes

Drizzle ORM Full Course Tutorial For Beginners

📚
Learning Resources

📖 Online Courses

Drizzle ORM: A Beginner's Guide

beginner

Paid

Udemy

🌐 Helpful Websites

Drizzle ORM Official Documentation

documentation

Comprehensive guides on setup, schema, queries, and more

Drizzle ORM GitHub Repository

repository

Source code, examples, and issue tracker

Drizzle ORM Schema Declaration

documentation

Detailed schema and table definition reference

🛠️ Useful Tools

Drizzle Kit

Database

CLI for migrations and schema management

Drizzle Studio

Database

Visual database explorer

better-sqlite3

Database

Fast SQLite driver for Node.js

Master Drizzle ORM: Type-Safe SQL in 5 Steps