ORM [BREAKING] Fixed postgres-js transparent parsers set by drizzle() constructors breaking driver's own serializers for timestamptz, timestamp, date, time, json, jsonb types (fixes #3171, #4426, #5789) paramsInErrors ❗ Any existing workarounds with manual JSON.stringify(jsonValue) in raw sql or raw driver calls must be removed to prevent double stringification of JSON params; For array-type JSON…
Fixed postgres-js not using prepared queries on explicit .prepare(name)
Warn about silent migration skips on drizzle-kit checks - thanks @shaneikennedy
New Netlify DB Driver Note: The Netlify DB driver is developed and maintained by the Netlify team. Installation: npm i @netlify/db Usage example: import { drizzle } from 'drizzle-orm/netlify-db'; // reads NETLIFY_DB_URL and NETLIFY_DB_DRIVER env vars const db = drizzle(); const result = await db.execute('select 1'); import { drizzle } from 'drizzle-orm/netlify-db'; const db = drizzle(process.env.D…
v1.0.0-rc.4 Fixed broken View types when using Subquery in selection Fixed custom types' JSON field API not being applied when column is used as a decoder on SQL fields Fixed codecs not getting applied to SQL field when .mapWith(column) is set (fixes #5724) Fixed Subquery fields' columns' codecs not being applied to subquery Fixed broken in rc.3 db.select in bun-sql/pg driver (fixes #5779) Updated…
v1.0.0-rc.3 Porting all the changes that were made in PostgreSQL to other dialects. This release is about MySQL: Removed RQBv1 from mysql dialect (._query) Internal MySQL sessions refactoring and moving to a unified query preparation function Fallback to regular queries on iterators for drivers that don't support streaming instead of throwing an error for compatibility Enabled optimized non-jit ma…
Updates Disabled default codec type selectors for custom columns (fixes #5711) Сallback type overload for codec selector in custom pg columns (codec: (config) => config?.withTimeZone ? 'timestamptz' : 'timestamp') Extended list of postgis types for codecs (improvement for #5711) Updated codecs: geometry -> geometry(point), geometry:tuple -> geometry(point):tuple Switched PG transactions from class…
v1.0.0-rc.1 ⚠️ This release introduced a breaking change into our casing API(see below) and removes RQB v1 ._query for postgres JIT mappers Drizzle ORM now has an opt-in API for JIT(just in time compilated) mappers which make most expensive part of the db request pipeline(row mapping) as fast as humanly possible. const db = drizzle({ ..., jit: true }) const query = db.select().from(users).prepare(…
Bug fixed drizzle-kit generate fails to generate correct migrations.js file on Windows [BUG]: MSSQL real() column returns imprecise float64 values -- missing mapFromDriverValue Object key collision [BUG]:beta20 Migration to Cloudflare D1 fails [BUG]: drizzle-kit migrate: migration SQL failures exit with code 1 but print no error (MigrateProgress hides rejection) [BUG]: MS SQL Filtered Index - Driz…
More fixes for the drizzle-kit migration process and commutativity checks Adding a value to a PostgreSQL enum will no longer be treated as commutative Enum values added in different leaves will now be merged properly
Fixed sql.identifier(), sql.as() escaping issues. Previously all the values passed to this functions were not properly escaped causing a possible SQL Injection (CWE-89) vulnerability Thanks to @EthanKim88, @0x90sh and @wgoodall01 for reaching out to us with a reproduction and suggested fix
Fixed sql.identifier(), sql.as() escaping issues. Previously all the values passed to this functions were not properly escaped causing a possible SQL Injection (CWE-89) vulnerability Thanks to @EthanKim88, @0x90sh and @wgoodall01 for reaching out to us with a reproduction and suggested fix
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 feature // raw string support db.select().from().comment("key='val'"); db.select().from().comment("my_first_tag"); // de…
New driver support for kit and studio You can now use the node:sqlite driver to run migrations and browse Drizzle Studio. If node:sqlite is available at runtime, we will automatically detect it and use it. Fixes resolved tsconfig path aliases in drizzle-kit loader using get-tsconfig + jiti alias mapping added fixtures and tests covering wildcard and non-wildcard path aliases ensured schema load su…