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 🚀