# Drizzle Orm

> Documentation for Drizzle Orm

## Pages

- [Drizzle Orm Documentation](drizzle-orm-documentation.md)
- [Drizzle](drizzle.md): Drizzle is a modern TypeScript ORM developers wanna use in their next project. It is lightweight at only ~7.4kb minif...
- [drizzle-arktype](drizzle-arktype.md): `drizzle-arktype`is a plugin for **[Drizzle ORM](https://github.com/drizzle-team/drizzle-orm)** that allows you to g...
- [Batch API](batch-api.md): **LibSQL Batch API explanation**:
- [Cache](cache.md): Drizzle sends every query straight to your database by default. There are no hidden actions, no automatic caching
- [Drizzle \<\> AWS Data API MySQL](drizzle-aws-data-api-mysql.md): Currently AWS Data API for MySQL is not implemented in Drizzle ORM
- [Drizzle \<\> AWS Data API Postgres](drizzle-aws-data-api-postgres.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> Bun SQL](drizzle-bun-sql.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> Bun SQLite](drizzle-bun-sqlite.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> Cloudflare D1](drizzle-cloudflare-d1.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> Cloudflare Durable Objects SQLite](drizzle-cloudflare-durable-objects-sqlite.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Bind a Durable Object. Durable objects are a scale-to-zero compute primitive based on the actor model.](bind-a-durable-object-durable-objects-are-a-scale-to-zero-compute-primitive-base.md)
- [Durable Objects can live for as long as needed. Use these when you need a long-running "server", such as in realtime apps.](durable-objects-can-live-for-as-long-as-needed-use-these-when-you-need-a-long-ru.md)
- [Docs: https://developers.cloudflare.com/workers/wrangler/configuration/#durable-objects](docs-httpsdeveloperscloudflarecomworkerswranglerconfigurationdurable-objects.md): [[durable_objects.bindings]]
- [Docs: https://developers.cloudflare.com/workers/wrangler/configuration/#migrations](docs-httpsdeveloperscloudflarecomworkerswranglerconfigurationmigrations.md): [[migrations]]
- [We need rules so we can import migrations in the next steps](we-need-rules-so-we-can-import-migrations-in-the-next-steps.md): [[rules]]
- [Drizzle HTTP proxy](drizzle-http-proxy.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> Effect Postgres](drizzle-effect-postgres.md): This page explains concepts available on drizzle versions`1.0.0-beta.9`and higher.
- [Drizzle \<\> Expo SQLite](drizzle-expo-sqlite.md): According to the **[official website](https://expo.dev/)**, Expo is an ecosystem of tools to develop, build and ship ...
- [Drizzle \<\> Neon Postgres](drizzle-neon-postgres.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> Nile](drizzle-nile.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> OP SQLite](drizzle-op-sqlite.md): According to the **[official github page](https://github.com/OP-Engineering/op-sqlite)**,
- [Database connection with Drizzle](database-connection-with-drizzle.md): Drizzle ORM runs SQL queries on your database via **database drivers**.
- [Drizzle \<\> PGlite](drizzle-pglite.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> PlanetScale Postgres](drizzle-planetscale-postgres.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> PlanetScale MySQL](drizzle-planetscale-mysql.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> Prisma Postgres](drizzle-prisma-postgres.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> React Native SQLite](drizzle-react-native-sqlite.md): Please use`Expo SQLite`to run Drizzle ORM with React Native apps.
- [Drizzle \<\> SQLite Cloud](drizzle-sqlite-cloud.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> Supabase](drizzle-supabase.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> TiDB Serverless](drizzle-tidb-serverless.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> Turso Database](drizzle-turso-database.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> Turso Cloud](drizzle-turso-cloud.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> Vercel Postgres](drizzle-vercel-postgres.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> Xata](drizzle-xata.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Common way of defining custom types](common-way-of-defining-custom-types.md): The best way to see how`customType`definition is working is to check how existing data types
- [Drizzle Queries + CRUD](drizzle-queries-crud.md): - How to define your schema - [Schema Fundamentals](/docs/sql-schema-declaration)
- [SQL Delete](sql-delete.md): You can delete all rows in the table:
- [Drizzle Kit configuration file](drizzle-kit-configuration-file.md): - Get started with Drizzle and`drizzle-kit`- [read here](/docs/get-started)
- [`drizzle-kit check`](drizzle-kit-check.md): - Get started with Drizzle and`drizzle-kit`- [read here](/docs/get-started)
- [`drizzle-kit export`](drizzle-kit-export.md): - Get started with Drizzle and`drizzle-kit`- [read here](/docs/get-started)
- [`drizzle-kit generate`](drizzle-kit-generate.md): - Get started with Drizzle and`drizzle-kit`- [read here](/docs/get-started)
- [`drizzle-kit migrate`](drizzle-kit-migrate.md): - Get started with Drizzle and`drizzle-kit`- [read here](/docs/get-started)
- [`drizzle-kit pull`](drizzle-kit-pull.md): - Get started with Drizzle and`drizzle-kit`- [read here](/docs/get-started)
- [`drizzle-kit push`](drizzle-kit-push.md): - Get started with Drizzle and`drizzle-kit`- [read here](/docs/get-started)
- [`drizzle-kit studio`](drizzle-kit-studio.md): - Drizzle Kit [overview](/docs/kit-overview) and [config file](/docs/drizzle-config-file)
- [`drizzle-kit up`](drizzle-kit-up.md): - Get started with Drizzle and`drizzle-kit`- [read here](/docs/get-started)
- [Dynamic query building](dynamic-query-building.md): By default, as all the query builders in Drizzle try to conform to SQL as much as possible, you can only invoke most ...
- [ESLint Drizzle Plugin](eslint-drizzle-plugin.md): For cases where it's impossible to perform type checks for specific scenarios, or where it's possible but error messa...
- [FAQ & Troubleshooting](faq-troubleshooting.md): Those are logically 2 different commands.`generate`is used to create an sql file together with additional
- [Generated Columns](generated-columns.md): To use this feature you would need to have`drizzle-orm@0.32.0`or higher and`drizzle-kit@0.23.0`or higher
- [Drizzle \<\> PostgreSQL](drizzle-postgresql.md): This page explains concepts available on drizzle versions`1.0.0-beta.2`and higher.
- [Drizzle \<\> Gel](drizzle-gel.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> MSSQL](drizzle-mssql.md): This page explains concepts available on drizzle versions`1.0.0-beta.2`and higher.
- [Drizzle \<\> MySQL](drizzle-mysql.md): To use Drizzle with a MySQL database, you should use the`mysql2`driver
- [Drizzle \<\> PostgreSQL](drizzle-postgresql-2.md): - Database [connection basics](/docs/connect-overview) with Drizzle
- [Drizzle \<\> SingleStore](drizzle-singlestore.md): To use Drizzle with a SingleStore database, you should use the`mysql2`driver
- [Drizzle \<\> SQLite](drizzle-sqlite.md): Drizzle has native support for SQLite connections with the`libsql`and`better-sqlite3`drivers.
- [Get started with Drizzle](get-started-with-drizzle.md): import Npm from '@mdx/Npm.astro';
- [Get Started with Drizzle and SQLite in existing project](get-started-with-drizzle-and-sqlite-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Bun:SQLite](get-started-with-drizzle-and-bunsqlite.md): - **bun** - javaScript all-in-one toolkit - [read here](https://bun.sh/)
- [Get Started with Drizzle and Bun:SQLite in existing project](get-started-with-drizzle-and-bunsqlite-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Bun:SQLite](get-started-with-drizzle-and-bunsqlite-2.md): - **bun** - javaScript all-in-one toolkit - [read here](https://bun.sh/)
- [Get Started with Drizzle and CockroachDB in existing project](get-started-with-drizzle-and-cockroachdb-in-existing-project.md): This page explains concepts available on drizzle versions`1.0.0-beta.2`and higher.
- [Get Started with Drizzle and CockroachDB](get-started-with-drizzle-and-cockroachdb.md): This page explains concepts available on drizzle versions`1.0.0-beta.2`and higher.
- [Get Started with Drizzle and D1 in existing project](get-started-with-drizzle-and-d1-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and D1](get-started-with-drizzle-and-d1.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and SQLite Durable Objects in existing project](get-started-with-drizzle-and-sqlite-durable-objects-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Bind a Durable Object. Durable objects are a scale-to-zero compute primitive based on the actor model.](bind-a-durable-object-durable-objects-are-a-scale-to-zero-compute-primitive-base-2.md)
- [Durable Objects can live for as long as needed. Use these when you need a long-running "server", such as in realtime apps.](durable-objects-can-live-for-as-long-as-needed-use-these-when-you-need-a-long-ru-2.md)
- [Docs: https://developers.cloudflare.com/workers/wrangler/configuration/#durable-objects](docs-httpsdeveloperscloudflarecomworkerswranglerconfigurationdurable-objects-2.md): [[durable_objects.bindings]]
- [Docs: https://developers.cloudflare.com/workers/wrangler/configuration/#migrations](docs-httpsdeveloperscloudflarecomworkerswranglerconfigurationmigrations-2.md): [[migrations]]
- [We need rules so we can import migrations in the next steps](we-need-rules-so-we-can-import-migrations-in-the-next-steps-2.md): [[rules]]
- [Get Started with Drizzle and SQLite Durable Objects](get-started-with-drizzle-and-sqlite-durable-objects.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Bind a Durable Object. Durable objects are a scale-to-zero compute primitive based on the actor model.](bind-a-durable-object-durable-objects-are-a-scale-to-zero-compute-primitive-base-3.md)
- [Durable Objects can live for as long as needed. Use these when you need a long-running "server", such as in realtime apps.](durable-objects-can-live-for-as-long-as-needed-use-these-when-you-need-a-long-ru-3.md)
- [Docs: https://developers.cloudflare.com/workers/wrangler/configuration/#durable-objects](docs-httpsdeveloperscloudflarecomworkerswranglerconfigurationdurable-objects-3.md): [[durable_objects.bindings]]
- [Docs: https://developers.cloudflare.com/workers/wrangler/configuration/#migrations](docs-httpsdeveloperscloudflarecomworkerswranglerconfigurationmigrations-3.md): [[migrations]]
- [We need rules so we can import migrations in the next steps](we-need-rules-so-we-can-import-migrations-in-the-next-steps-3.md): [[rules]]
- [Get Started with Drizzle and Effect PostgreSQL in existing project](get-started-with-drizzle-and-effect-postgresql-in-existing-project.md): This page explains concepts available on drizzle versions`1.0.0-beta.13`and higher.
- [Get Started with Drizzle and Effect PostgreSQL](get-started-with-drizzle-and-effect-postgresql.md): This page explains concepts available on drizzle versions`1.0.0-beta.13`and higher.
- [Get Started with Drizzle and Expo in existing project](get-started-with-drizzle-and-expo-in-existing-project.md): We don't have a proper guide for getting started with Expo in an existing project, and we believe that
- [Get Started with Drizzle and Expo](get-started-with-drizzle-and-expo.md): - **Expo SQLite** - A library that provides access to a database that can be queried through a SQLite API - [read her...
- [Get Started with Drizzle and Gel in existing project](get-started-with-drizzle-and-gel-in-existing-project.md): - **tsx** - package for running TypeScript files - [read here](https://tsx.is/)
- [Get Started with Drizzle and Gel](get-started-with-drizzle-and-gel.md): - **tsx** - package for running TypeScript files - [read here](https://tsx.is/)
- [Get Started with Drizzle and MSSQL in existing project](get-started-with-drizzle-and-mssql-in-existing-project.md): This page explains concepts available on drizzle versions`1.0.0-beta.2`and higher.
- [Get Started with Drizzle and MSSQL](get-started-with-drizzle-and-mssql.md): This page explains concepts available on drizzle versions`1.0.0-beta.2`and higher.
- [Get Started with Drizzle and MySQL in existing project](get-started-with-drizzle-and-mysql-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and MySQL](get-started-with-drizzle-and-mysql.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Neon in existing project](get-started-with-drizzle-and-neon-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Neon](get-started-with-drizzle-and-neon.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Nile in existing project](get-started-with-drizzle-and-nile-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Nile](get-started-with-drizzle-and-nile.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and OP-SQLite in existing project](get-started-with-drizzle-and-op-sqlite-in-existing-project.md): We don't have a proper guide for getting started with OP-SQLite in an existing project, and we believe that
- [Get Started with Drizzle and OP-SQLite](get-started-with-drizzle-and-op-sqlite.md): - **OP-SQLite** - SQLite library for react-native - [read here](https://github.com/OP-Engineering/op-sqlite)
- [Get Started with Drizzle and PGLite in existing project](get-started-with-drizzle-and-pglite-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and PGlite](get-started-with-drizzle-and-pglite.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and PlanetScale in existing project](get-started-with-drizzle-and-planetscale-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and PlanetScale](get-started-with-drizzle-and-planetscale.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and PlanetScale Postgres in existing project](get-started-with-drizzle-and-planetscale-postgres-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and PlanetScale Postgres](get-started-with-drizzle-and-planetscale-postgres.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and PostgreSQL in existing project](get-started-with-drizzle-and-postgresql-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and PostgreSQL](get-started-with-drizzle-and-postgresql.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and SingleStore in existing project](get-started-with-drizzle-and-singlestore-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and SingleStore](get-started-with-drizzle-and-singlestore.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and SQLite Cloud in existing project](get-started-with-drizzle-and-sqlite-cloud-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and SQLite Cloud](get-started-with-drizzle-and-sqlite-cloud.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and SQLite in existing project](get-started-with-drizzle-and-sqlite-in-existing-project-2.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and SQLite](get-started-with-drizzle-and-sqlite.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Supabase in existing project](get-started-with-drizzle-and-supabase-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Supabase](get-started-with-drizzle-and-supabase.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and TiDB in existing project](get-started-with-drizzle-and-tidb-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and TiDB](get-started-with-drizzle-and-tidb.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Turso Database in existing project](get-started-with-drizzle-and-turso-database-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Turso Database](get-started-with-drizzle-and-turso-database.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Turso Cloud in existing project](get-started-with-drizzle-and-turso-cloud-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Turso Cloud](get-started-with-drizzle-and-turso-cloud.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Vercel Postgres in existing project](get-started-with-drizzle-and-vercel-postgres-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Vercel Postgres](get-started-with-drizzle-and-vercel-postgres.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Xata in existing project](get-started-with-drizzle-and-xata-in-existing-project.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Get Started with Drizzle and Xata](get-started-with-drizzle-and-xata.md): - **dotenv** - package for managing environment variables - [read here](https://www.npmjs.com/package/dotenv)
- [Drizzle gotchas](drizzle-gotchas.md): This will be a library of`gotchas`with Drizzle use cases
- [drizzle-graphql](drizzle-graphql.md): Create a GraphQL server from a Drizzle schema in one line, and easily enhance it with custom queries and mutations.
- [Indexes & Constraints](indexes-constraints.md): SQL constraints are the rules enforced on table columns. They are used to prevent invalid data from being entered int...
- [SQL Insert](sql-insert.md): Drizzle ORM provides you the most SQL-like way to insert rows into the database tables.
- [Joins [SQL]](joins-sql.md): Join clause in SQL is used to combine 2 or more tables, based on related columns between them.
- [Migrations with Drizzle Kit](migrations-with-drizzle-kit.md): - Get started with Drizzle and`drizzle-kit`- [read here](/docs/get-started)
- [Drizzle migrations for teams](drizzle-migrations-for-teams.md): This section will be updated right after our release of the next version of migrations folder structure.
- [Migrations with Drizzle Kit](migrations-with-drizzle-kit-2.md): - Get started with Drizzle and`drizzle-kit`- [read here](/docs/get-started)
- [Drizzle Kit data seeding](drizzle-kit-data-seeding.md): This section will be updated right after our release of`drizzle-seed`package.
- [Drizzle migrations in web and mobile environments](drizzle-migrations-in-web-and-mobile-environments.md): This section will be updated in the next release.
- [Drizzle migrations fundamentals](drizzle-migrations-fundamentals.md): SQL databases require you to specify a **strict schema** of entities you're going to store upfront
- [Filter and conditional operators](filter-and-conditional-operators.md): We natively support all dialect specific filter and conditional operators.
- [Drizzle ORM](drizzle-orm.md): Drizzle ORM is a headless TypeScript ORM with a head. 🐲
- [Query performance](query-performance.md): When it comes to **Drizzle** — we're a thin TypeScript layer on top of SQL with
- [Drizzle Serverless performance](drizzle-serverless-performance.md): You can get immense benefits with`serverless functions`like AWS Lambda or Vercel Server Functions (they're AWS Lamb...
- [Drizzle extension for Prisma](drizzle-extension-for-prisma.md): If you have an existing project with Prisma and want to try Drizzle or gradually adopt it,
- [Drizzle query utils](drizzle-query-utils.md): import Npm from "@mdx/Npm.astro";
- [Quick start](quick-start.md): Lets build a quick start app with`PostgreSQL`+`postgresjs`and run our first migration.
- [Read Replicas](read-replicas.md): When your project involves a set of read replica instances, and you require a convenient method for managing
- [Drizzle Relations Fundamentals](drizzle-relations-fundamentals.md): In the world of databases, especially relational databases, the concept of relations is absolutely fundamental.
- [Migrating to Relational Queries version 2](migrating-to-relational-queries-version-2.md): This page explains concepts available on drizzle versions`1.0.0-beta.1`and higher.
- [Drizzle relations](drizzle-relations.md): This page explains concepts available on drizzle versions`1.0.0-beta.1`and higher.
- [Drizzle soft relations](drizzle-soft-relations.md): The sole purpose of Drizzle relations is to let you query your relational data in the most simple and consise way:
- [Row-Level Security (RLS)](row-level-security-rls.md): With Drizzle, you can enable Row-Level Security (RLS) for any Postgres table, create policies with various options, a...
- [Drizzle Queries](drizzle-queries.md): This page explains concepts available on drizzle versions`1.0.0-beta.1`and higher.
- [Drizzle Queries](drizzle-queries-2.md): Drizzle ORM is designed to be a thin typed layer on top of SQL.
- [Table schemas](table-schemas.md): If you declare an entity within a schema, query builder will prepend schema names in queries:
- [Generators](generators.md): For now, specifying`arraySize`along with`isUnique`in generators that support it will result in unique values bein...
- [Drizzle Seed](drizzle-seed.md): `drizzle-seed`can only be used with`drizzle-orm@0.36.4`or higher. Versions lower than this may work at runtime but...
- [Versioning](versioning.md): `drizzle-seed`uses versioning to manage outputs for static and dynamic data. To ensure true
- [SQL Select](sql-select.md): Drizzle provides you the most SQL-like way to fetch data from your database, while remaining type-safe and composable.
- [Sequences](sequences.md): Sequences in PostgreSQL and CockroachDB are special single-row tables created to generate unique identifiers, often u...
- [Set Operations](set-operations.md): SQL set operations combine the results of multiple query blocks into a single result.
- [Drizzle schema](drizzle-schema.md): Drizzle lets you define a schema in TypeScript with various models and properties supported by the underlying database.
- [Magical `sql` operator 🪄](magical-sql-operator.md): When working with an ORM library, there may be cases where you find it challenging to write a
- [Transactions](transactions.md): SQL transaction is a grouping of one or more SQL statements that interact with a database.
- [create a tenant](create-a-tenant.md): curl --location --request POST 'localhost:3001/api/tenants' \
- [get tenants](get-tenants.md): curl -X GET '
- [create a todo (don't forget to use a real tenant-id in the URL)](create-a-todo-dont-forget-to-use-a-real-tenant-id-in-the-url.md): curl -X POST \
- [list todos for tenant (don't forget to use a real tenant-id in the URL)](list-todos-for-tenant-dont-forget-to-use-a-real-tenant-id-in-the-url.md): curl -X GET \
- [drizzle-typebox](drizzle-typebox.md): `drizzle-typebox`is a plugin for **[Drizzle ORM](https://github.com/drizzle-team/drizzle-orm)** that allows you to g...
- [SQL Update](sql-update.md): await db.update(users)
- [New Features](new-features.md): **🎉 Pull relations**
- [Upgrading to Drizzle v1 RC](upgrading-to-drizzle-v1-rc.md): - **beta.1** release notes - a set of changes between`latest`and`beta`versions - [read here](https://github.com/d...
- [drizzle-valibot](drizzle-valibot.md): `drizzle-valibot`is a plugin for **[Drizzle ORM](https://github.com/drizzle-team/drizzle-orm)** that allows you to g...
- [Views](views.md): There're several ways you can declare views with Drizzle ORM.
- [Drizzle ORM](drizzle-orm-2.md): Drizzle is a good friend who's there for you when necessary and doesn't bother when you need some space.
- [drizzle-zod](drizzle-zod.md): `drizzle-zod`is a plugin for **[Drizzle ORM](https://github.com/drizzle-team/drizzle-orm)** that allows you to gener...