note: no summary for this older release
We summarize recent releases. The original release notes for this version are below.
release-notesgithub.com/drizzle-team/drizzle-orm · 51 lines
- ## New Features
- ### `sqlcommenter` support for PostgreSQL and MySQL
- You can now add custom tags to the query. These tags will be appended to the end of each query, helping the database add metadata/tags to it. This will be especially useful with PlanetScale’s new [Database Traffic Control](https://planetscale.com/blog/introducing-database-traffic-control) feature
- ```ts
- // raw string support
- db.select().from().comment("key='val'");
- db.select().from().comment("my_first_tag");
- // developer friendly dedicated to tags
- db.select().from().comment({ key: 'val' });
- ```
- Example:
- ```ts
- db.select().from(comments).comment({ priority: 'high', category: "analytics" });
- ```
- ```sql
- select "id", "name" from "comments" /*priority='high',category='analytics'*/
- ```
- The only limitation is that you can't use comments with a prepared statement:
- ```ts
- // can't be used
- const p = db.select().from().prepare();
- // ❌
- p.comment({ key: 'val' }).execute();
- ```
- ## Bug fixes
- - [Fixed error message for the defineRelations function](https://github.com/drizzle-team/drizzle-orm/issues/5350)
- - [[BUG]: drizzle-kit push attempts to drop policies in excluded schemas (e.g. cron) despite schemaFilter: ["public"]](https://github.com/drizzle-team/drizzle-orm/issues/5329)
- - [[BUG]: error attempting to drizzle-kit migrate table with char array field generated using drizzle-kit generate](https://github.com/drizzle-team/drizzle-orm/issues/5370)
- - [[BUG]: Ignore Vim *.swp files in drizzle-kit generate](https://github.com/drizzle-team/drizzle-orm/issues/4906)
- - [[BUG]: drizzle-kit pull outputs access method name instead of operator class for ivfflat indexes](https://github.com/drizzle-team/drizzle-orm/issues/5495)
- - [[BUG]: drizzle-kit pull generates not enough data provided to build the relation](https://github.com/drizzle-team/drizzle-orm/issues/5493)
- - [drizzle-kit push fails with Turso/libSQL on table recreation: "cannot commit - no transaction is active"](https://github.com/drizzle-team/drizzle-orm/issues/5489)
- - [[BUG]: Cannot read properties of undefined (reading 'requestLayout') when running drizzle-kit introspect (MySQL)](https://github.com/drizzle-team/drizzle-orm/issues/5488)
- - [[BUG (beta)]: RDS Data API pulling schema error](https://github.com/drizzle-team/drizzle-orm/issues/5308)
- - [[BUG]: drizzle-kit commutative migrations takes only last leaf migration into account](https://github.com/drizzle-team/drizzle-orm/issues/5504)
- ## Updates
- - Updated `migrate()` function for mysql dialect to correctly manage multiple databases
- - The behavior for reading schema files has been updated. From now only files with the following extensions will be processed: `.js` `.mjs` `.cjs` `.jsx` `.ts` `.mts` `.cts` `.tsx`. All other file types will be ignored