What is Drizzle ORM?

Drizzle ORM is a performance-oriented and lightweight ORM library built for TypeScript. Compared to Prisma, it offers a lower level of abstraction and is closer to SQL.

Drizzle uses a SQL-like API and supports PostgreSQL, MySQL, SQLite, and many other databases.

Schema Definition

To define a schema with Drizzle, you use functions like pgTable, serial, text, and integer. TypeScript types are automatically inferred from your schemas.

You can define relationships with the relations function and write type-safe JOIN queries.

Query Building

Drizzle offers a SQL-like query API. You can perform basic CRUD operations with db.select(), db.insert(), db.update(), and db.delete().

Type-safe SQL-like queries Prepared statement support Relation queries with JOIN Running raw SQL queries

Migration Management

Drizzle offers migration management through the drizzle-kit CLI tool. It automatically detects schema changes and generates SQL migration files.

Comparison with Prisma

Drizzle ORM is lighter and faster than Prisma. It gives you more control over SQL with fewer abstraction layers. However, it lacks some features like Prisma's visual interface.