Drizzle ORM
Drizzle ORM is a TypeScript ORM for SQL databases designed with maximum type safety in mind. It comes with a drizzle-kit (opens in a new tab) CLI companion for automatic SQL migrations generation. Drizzle ORM is meant to be a library, not a framework. It stays as an opt-in solution all the time at any levels. The ORM's main philosophy is "If you know SQL, you know Drizzle ORM". We follow the SQL-like syntax whenever possible, are strongly typed ground up, and fail at compile time, not in runtime.
Documentation (opens in a new tab)
Dependencies Installed
- Regular
drizzle-orm
drizzle-zod
@t3-oss/env-nextjs
zod@3.21.4
postgres
- Developer
drizzle-kit
tsx
dotenv
pg
Files Scaffolded
lib/db/index.ts
lib/db/migrate.ts
drizzle.config.ts
Files Updated
.env
lib/env.mjs
package.json
Note: if you decide to include example mode, the following additional files will be scaffolded:
lib/db/schema/computers.ts
lib/api/computers/queries.ts
lib/api/computers/mutations.ts