We've had podcast on syntax.fm 🎙️ Drizzle <> Sytnax merch drop - see here

ORM v0.32.1 release

• improved indexes API and typings
• support for limit 0
• array and notInArray accept empty []

Community highlights • drizzle.run ships schema visualizer 👀 • sst dev & drizzle studio update • Hono + Drizzle headless CMS • TypeScript based down migrations

Drizzle Kit goes open-source 🎉 • 2hrs release stream on Jul 30th • added programmatic access • v0.23.1 release with bugfixes

Landing page update 🎉 • our team is 10 devs, now you know • showcase active contributors • TypeScript and JavaScript mention • v1.0 release timeline with a roadmap! • calendar section for our iterations • quick access docs search and ask ai • snake game board 🐍

added announcments page

Updated tutorials: • Drizzle <> Vercel Postgres • Drizzle <> Turso • Drizzle <> Neon Postgres • Todo App with Neon Postgres

Drizzle Gateway closed alpha release 🎉

Brocli - our new open-source library 👀

Snake Game released 🎉 have some fun we've had a lot of fun

Kit v0.24.0 release Breaking changes:

• Fixed Composite primary key order is not consistent by removing `sort` in SQLite

Bug fixes:

• [BUG] When using double type columns, import is not inserted
• [BUG] A number value is specified as the default for a column of type char
• [BUG]: Array default in migrations are wrong
• [FEATURE]: Simpler default array fields
• [BUG]: drizzle-kit generate succeeds but generates invalid SQL for default([]) - Postgres
• [BUG]: Incorrect type for array column default value
• [BUG]: error: column is of type integer[] but default expression is of type integer
• [BUG]: Default value in array generating wrong migration file
• [BUG]: enum as array, not possible?

ORM v0.33.0 release Breaking changes:

• [BUG]: jsonb always inserted as a json string when using postgres-js
• [BUG]: jsonb type on postgres implement incorrectly

Bug fixes:

• [BUG]: boolean mode not working with prepared statements (bettersqlite)
• [BUG]: isTable helper function is not working
• [BUG]: Documentation is outdated on inArray and notInArray Methods

Kit v0.23.2 release

• fixed a bug in PostgreSQL with push and introspect where the schemaFilter object was passed. It was detecting enums even in schemas that were not defined in the schemaFilter.
• fixed the drizzle-kit up command to work as expected, starting from the sequences release

ORM v0.32.2 release

• fix AWS Data API type hints bugs in RQB
• fix set transactions in MySQL bug
• add forwaring dependencies within useLiveQuery, fixes #2651
• export additional types from SQLite package, like AnySQLiteUpdate

Updated tutorials: • Drizzle with Supabase Database • Drizzle with Vercel Edge Functions

We've updated benchmarks 🚀

Some Tweets

ORM v0.36.0 release Row-Level Security Support for PostgreSQL

• Manage roles
• Manage policies
• Enable RLS for tables
• Enable RLS for views!
• Special import `drizzle-orm/neon` for `Neon`
• Special import `drizzle-orm/supabase` for `Supabase`

Kit v0.27.0 release Row-Level Security Support for PostgreSQL

• Manage roles
• Manage policies
• Enable RLS for tables
• Enable RLS for views!
• Special import `drizzle-orm/neon` for `Neon`
• Special import `drizzle-orm/supabase` for `Supabase`

Documentation site restructure and improvements

• New "Get Started" section
• New "Fundamentals" section
• "Connect" is now flat and has proper navigation
• The Kit section is gone, and you now have a "Migrations" section with full information about the Kit
• Updated UI
• Content restructuring
• And more

ORM v0.34.0 release Breaking changes:

• Added new dialect "Turso" that needs a newer libsql version

Features:

• LibSQL/Turso and SQLite migration updates
• SQLite "generate" and "push" statement updates
• LibSQL/Turso "generate" and "push" statement updates
• New `casing` param in `drizzle-orm`
• Monodriver: A new and easy way to start using Drizzle
• Schema improvements: Optional names for columns and callback in Drizzle table
• New "count" API
• Ability to execute raw strings
• Exposed db.$client

Kit v0.25.0 release Breaking changes:

• Added new dialect "Turso" that needs a newer libsql version

Features:

• LibSQL/Turso and SQLite migration updates
• SQLite "generate" and "push" statement updates
• LibSQL/Turso "generate" and "push" statement updates
• New `casing` param in `drizzle-kit`

🎉 OneDollarStats is now available in Open Alpha release! OneDollarStats is a $1 per month web analytics built by Drizzle Team

🎉 New `drizzle-seed` package is now available For more info check our seed documentation

ORM v0.36.4 release

• Added .$withAuth() API for Neon HTTP driver
• Added OVERRIDING SYSTEM VALUE api to db.insert()

ORM v0.36.3 release

• Support for UPDATE ... FROM in PostgreSQL and SQLite
• Support for INSERT INTO ... SELECT in all dialects

Kit v0.28.1 release and ORM v0.36.2 release

• Support more types in like, notLike, ilike and notIlike expressions
• Fixed typos in repository: thanks @armandsalle, @masto, @wackbyte, @Asher-JH, @MaxLeiter
• fix: wrong dialect set in mysql/sqlite introspect
• Fixed .generated behavior with non-strict tsconfig
• Fix Drizzle ORM for expo-sqlite
• Fixed lack of schema name on columns in sql
• fix: Adjust neon http driver entity kind
• Export PgIntegerBuilderInitial type
• [MySQL] Correct $returningId() implementation to correctly store selected fields

Kit v0.28.0 release and ORM v0.36.1 release

• Added an OHM static imports checker to identify unexpected imports within a chain of imports in the drizzle-kit repo. For example, it checks if drizzle-orm is imported before drizzle-kit and verifies if the drizzle-orm import is available in your project.
• Adding more columns to Supabase auth.users table schema

Bug Fixes
• [BUG]: Using sql.placeholder with limit and/or offset for a prepared statement produces TS error
• [BUG] If a query I am trying to modify with a dynamic query (....$dynamic()) contains any placeholders, I'm getting an error that says No value for placeholder.... provided
• [BUG]: Error thrown when trying to insert an array of new rows using generatedAlwaysAsIdentity() for the id column
• [BUG]: Unable to Use BigInt Types with Bun and Drizzle
• [BUG]: [drizzle-kit]: Fix breakpoints option cannot be disabled
• [BUG]: drizzle-kit introspect: SMALLINT import missing and incorrect DECIMAL UNSIGNED handling
• Unsigned tinyints preventing migrations
• [BUG]: Can't parse float(8,2) from database (precision and scale and/or unsigned breaks float types)
• [BUG]: PgEnum generated migration doesn't escape single quotes
• [BUG]: single quote not escaped correctly in migration file
• [BUG]: Migrations does not escape single quotes
• [BUG]: Issue with quoted default string values
• [BUG]: SQl commands in wrong roder
• [BUG]: Time with precision in drizzle-orm/pg-core adds double-quotes around type
• [BUG]: Postgres push fails due to lack of quotes
• [BUG]: TypeError: Cannot read properties of undefined (reading 'compositePrimaryKeys')
• [BUG]: drizzle-kit introspect generates CURRENT_TIMESTAMP without sql operator on date column
• [BUG]: Drizzle-kit introspect doesn't pull correct defautl statement
• [BUG]: Problem on MacBook - This statement does not return data. Use run() instead
• [BUG]: Enum column names that are used as arrays are not quoted
• [BUG]: drizzle-kit generate ignores index operators
• dialect param config error message is wrong
• [BUG]: Error setting default enum field values
• [BUG]: drizzle-kit does not respect the order of columns configured in primaryKey()
• [BUG]: Cannot drop Unique Constraint MySQL

Kit v0.27.2 release

• Fix [BUG]: Undefined properties when using drizzle-kit push
• Fix TypeError: Cannot read properties of undefined (reading 'isRLSEnabled')
• Fix push bugs, when pushing a schema with linked policy to a table from drizzle-orm/supabase

Kit v0.27.1 release

• Fix: [BUG]: When using RLS policies and Views, the view is the last clause generated

Kit v0.29.0 release and ORM v0.37.0 release

• New dialect SingleStore is available in Drizzle
• New driver for Durable Objects SQLite is available in Drizzle
• [BUG]: $with is undefined on withReplicas
• [BUG]: Neon serverless driver accepts authToken as a promise, but the $withAuth does not