drizzle-orm Releases

Drizzle ORM 0.36.0 introduces significant Row-Level Security (RLS) support for PostgreSQL, including the ability to enable RLS on tables, define roles with pgRole, create policies with pgPolicy, and integrate with Neon and Supabase. The release also changes the third parameter of table definitions to accept an array instead of an object (with the object API being deprecated). This version requires drizzle-kit@0.27.0.

Oct 30, 2024

This release introduces comprehensive Row-Level Security (RLS) support for PostgreSQL databases, including policies, roles, and integration with popular providers like Neon and Supabase. It also fixes several Drizzle Studio bugs related to timezone formatting, CORS errors, and timestamp display.

Oct 30, 2024

This release adds native support for all `@libsql/client` driver variations in Drizzle ORM, enabling connectivity to LibSQL/Turso databases across different platforms and protocols.

Oct 21, 2024

This is a bug fix release addressing import issues across multiple environments after driver implementation updates, along with fixes for PgTransaction type errors and Cloudflare deployment failures. The release also includes approximately 240 new tests to verify ESM and CJS builds for all drivers.

Oct 18, 2024

This is a maintenance release focused on internal version synchronization between drizzle-kit and drizzle-orm packages. The release addresses compatibility issues that were introduced in the previous minor release, requiring users to upgrade both packages together to ensure proper functionality.

Oct 16, 2024

This is a maintenance release that updates internal versions for both drizzle-kit and drizzle-orm packages to ensure they remain synchronized and work correctly together.

Oct 16, 2024

Oct 15, 2024

This release fixes the unusable API from 0.34.0 by introducing a cleaner way to initialize Drizzle with connection strings directly. It also adds .orderBy() and .limit() functions to update/delete queries for SQLite and MySQL, along with a new drizzle.mock() function for type checking scenarios.

Oct 15, 2024

This release introduces checks and views support in drizzle-kit, allowing management of check constraints and views defined in drizzle-orm schema definitions across all dialects. It also includes significant updates to PostgreSQL enum behavior, including support for adding values before/after, dropping values, dropping enums, moving between schemas, and renaming enums.

Oct 15, 2024

This is a bug fix release addressing dynamic import issues in the `/connect` module for both CommonJS (CJS) and ES Modules (MJS) environments.

Oct 7, 2024

This release introduces major improvements to Drizzle ORM including a new simplified connection API, automatic casing conversion between TypeScript camelCase and database snake_case, and a new $count API. Turso users require migration to a separate dialect with updated @libsql/client@0.10.0+, while SQLite migration generation has been updated to generate actual SQL statements instead of comments.

Oct 7, 2024

This release introduces a dedicated Turso/LibSQL dialect in drizzle-kit, requiring users to update their configuration from `dialect: 'sqlite'` to `dialect: 'turso'`. It also adds a new `casing` parameter for automatic mapping between snake_case database columns and camelCase TypeScript code, and improves migration generation for both SQLite and LibSQL/Turso.

Oct 7, 2024

This minor release adds support for the pglite driver, allowing users to use pglite with all drizzle-kit commands including Drizzle Studio. It also includes a bug fix for mysql-kit related to GENERATED ALWAYS AS columns with NOT NULL constraints.

Aug 26, 2024

This is a bug fix release for Drizzle Kit CLI's introspect command, addressing multiple critical issues with database schema introspection across PostgreSQL and MySQL dialects. The release fixes the CLI not working properly, adds support for special characters in column names, includes PostgreSQL sequences in introspection, and resolves various type casting and default value issues.

Aug 22, 2024

This release primarily addresses a significant bug in how PostgreSQL-JS handles JSON/JSONB values, changing the behavior to pass raw JSON values instead of stringified strings. The release also includes three bug fixes affecting better-sqlite's boolean mode with prepared statements, the isTable helper function, and documentation for inArray/notInArray methods.

Aug 8, 2024

This release primarily focuses on fixing array-related bugs in drizzle-kit, including issues with array defaults in migrations, incorrect type handling for array column defaults, and simpler default array fields. There's a breaking change for SQLite users where composite primary key order is now consistent with PostgreSQL and MySQL.

Aug 8, 2024

This is a bug fix release that addresses type hints issues in AWS Data API for the Relational Query Builder (RQB), fixes a MySQL set transactions bug, adds forwarding dependencies to useLiveQuery, and exports additional SQLite types.

Aug 5, 2024

This is a bug fix release for drizzle-kit addressing two issues: a PostgreSQL schemaFilter bug where enums were incorrectly detected in schemas not defined in the filter, and fixing the `drizzle-kit up` command which wasn't working properly since the sequences release.

Aug 5, 2024

This is a bug fix and improvement release for drizzle-orm 0.32.1. The release addresses several issues including fixing index typings to support 3+ columns with mixed columns and expressions, adding "limit 0" support across all dialects, and allowing inArray and notInArray to accept empty lists.

Jul 23, 2024

This release introduces comprehensive support for generated columns across PostgreSQL, MySQL, and SQLite, along with new PostgreSQL sequences and identity columns. It also adds MySQL's $returningId() function to handle insert IDs, and includes new Drizzle Kit features like the --force flag for push commands and customizable migration file prefixes.

Jul 10, 2024