Drizzle ORM

When to Use

• Serverless: Zero runtime overhead makes it perfect for Lambdas.
• SQL Lovers: You prefer

  db.select().from(users)

  over object APIs.
• Performance: Faster query building than Prisma.

Core Concepts

Schema Definition

export const users = pgTable('users', { ... })

Query Builder

Relational API

db.query.users.findMany({ with: { posts: true } })

Best Practices (2025)

• Use

  drizzle-kit

  : For migration management.
• Use

  run

  : Explicit execution model.
• Use Driver Specifics: Drizzle embraces database-specific features (JSONB, Arrays).

• Don't over-abstract: Drizzle shines when you stay close to SQL.

References

• Drizzle ORM Documentation