我们发布速度相当快
Drizzle 团队和活跃的贡献者
Andrew Sherman

Dan Kochetov

Alex Blokh

Mykhailo Stratovych

Roman Nabukhotnyi

Vladislav Stohnii

Serhii Reka

Oleksii Khomenko

Artem Odiiko

Vitalii Staryk

angelelz

rphlmr

mario564

intelligently

June 2024
July 2024
- ORM v0.32.1 发布
- 改善了索引 API 和类型定义
- 支持 limit 0
- 数组和 notInArray 接受空 []
- 社区亮点 • drizzle.run 发布 模式可视化工具 👀 • sst dev 和 drizzle studio 更新 • Hono + Drizzle 无头 CMS • 基于 TypeScript 的 向下迁移
- Drizzle Kit 开源 🎉 • 7月30日进行2小时发布直播 • 添加编程访问 • v0.23.1 发布,包含 bug 修复
- 着陆页更新 🎉 • 我们的团队有 10 名开发者,现在你知道了 • 展示活跃贡献者 • 提到 TypeScript 和 JavaScript • v1.0 发布时间表和路线图! • 我们的迭代日历部分 • 快速访问文档搜索和询问 AI • 贪吃蛇游戏板 🐍
- 添加了 公告 页面
August 2024
- Drizzle Gateway 关闭 alpha 发布 🎉
- Brocli - 我们的新开源库 👀
- 贪吃蛇游戏 发布 🎉 玩得开心 我们玩得很开心
- Kit v0.23.2 发布
- 修复了 PostgreSQL 中与推送和 introspect 相关的错误,其中
schemaFilter
对象被传递。它检测到了即使在schemaFilter
中未定义的模式中的枚举。 - 修复了
drizzle-kit up
命令,以按预期工作,从序列发布开始
- 修复了 PostgreSQL 中与推送和 introspect 相关的错误,其中
- 更新的教程: • Drizzle 与 Supabase 数据库 • Drizzle 与 Vercel 边缘函数
- 我们更新了 基准测试 🚀
September 2024
- 一些推文
October 2024
- ORM v0.36.0 发布 支持 PostgreSQL 的行级安全
- 管理角色
- 管理策略
- 为表启用 RLS
- 为视图启用 RLS!
- 为
Neon
提供特殊导入drizzle-orm/neon
- 为
Supabase
提供特殊导入drizzle-orm/supabase
- Kit v0.27.0 发布 支持 PostgreSQL 的行级安全
- 管理角色
- 管理策略
- 为表启用 RLS
- 为视图启用 RLS!
- 为
Neon
提供特殊导入drizzle-orm/neon
- 为
Supabase
提供特殊导入drizzle-orm/supabase
- 文档网站重组和改进
- 新增“入门”部分
- 新增“基础知识”部分
- “连接”现已扁平化并具有适当的导航
- Kit 部分已移除,现在有一个“迁移”部分,包含有关 Kit 的完整信息
- 更新的 UI
- 内容重组
- 还有更多
- ORM v0.34.0 发布 重大更改:
- 新增方言“Turso”,需要更新的 libsql 版本
- LibSQL/Turso 和 SQLite 的迁移更新
- SQLite 的“生成”和“推送”语句更新
- LibSQL/Turso 的“生成”和“推送”语句更新
- 在
drizzle-orm
中添加新的casing
参数 - Monodriver:一种新的简单使用 Drizzle 的方式
- 模式改进:列的可选名称和 Drizzle 表中的回调
- 新的“计数”API
- 能够执行原始字符串
- 公开 db.$client
- Kit v0.25.0 发布 重大更改:
- 新增方言“Turso”,需要更新的 libsql 版本
- LibSQL/Turso 和 SQLite 的迁移更新
- SQLite 的“生成”和“推送”语句更新
- LibSQL/Turso 的“生成”和“推送”语句更新
- 在
drizzle-kit
中添加新的casing
参数
November 2024
- 🎉 OneDollarStats 现在在 Open Alpha 版本中可用! OneDollarStats 是一个每月 $1 的网络分析工具,由 Drizzle 团队构建
- 🎉 新
drizzle-seed
包现在可用 更多信息请查看我们的 seed 文档 - ORM v0.36.4 发布
- 为 Neon HTTP 驱动程序添加了 .$withAuth() API
- 为 db.insert() 添加了 OVERRIDING SYSTEM VALUE api
- ORM v0.36.3 发布
- 支持 PostgreSQL 和 SQLite 中的 UPDATE ... FROM
- 支持所有方言中的 INSERT INTO ... SELECT
- Kit v0.28.1 发布 和 ORM v0.36.2 发布
- 支持更多类型在 like, notLike, ilike 和 notIlike 表达式中
- 修复拼写错误在仓库中:感谢 @armandsalle, @masto, @wackbyte, @Asher-JH, @MaxLeiter
- 修复:mysql/sqlite introspect 中的错误方言
- 修复 .generated 行为与非严格 tsconfig
- 修复 Drizzle ORM for expo-sqlite
- 修复 sql 中列的 schema 名称缺失
- 修复:调整 neon http 驱动程序实体类型
- 导出 PgIntegerBuilderInitial 类型
- [MySQL] 正确实现 $returningId() 以正确存储选定字段
- Kit v0.28.0 发布 和 ORM v0.36.1 发布
- 添加了一个 OHM 静态导入检查器,以识别 drizzle-kit 仓库中链式导入中的意外导入。例如,它检查 drizzle-orm 是否在 drizzle-kit 之前导入,并验证 drizzle-orm 导入是否在您的项目中可用。
- 添加更多列到 Supabase auth.users 表 schema
-
错误修复
- [BUG]: 在使用 sql.placeholder 与 limit 和/或 offset 进行预处理语句时生成 TS 错误
- [BUG]: 当修改的查询(....$dynamic())包含任何占位符时,会收到错误提示"未提供占位符的值..."
- [BUG]: 尝试插入使用 generatedAlwaysAsIdentity() 为 id 列生成的新行时抛出错误
- [BUG]: 无法在 Bun 和 Drizzle 中使用 BigInt 类型
- [BUG]: [drizzle-kit]: 无法禁用修复断点选项
- [BUG]: drizzle-kit introspect: SMALLINT 导入缺失和不正确的 DECIMAL UNSIGNED 处理
- 无符号 tinyints 阻止迁移
- [BUG]: 无法从数据库解析 float(8,2) (精度和小数位数和/或无符号破坏浮点类型)
- [BUG]: PgEnum 生成的迁移没有转义单引号
- [BUG]: 迁移文件中单引号转义不正确
- [BUG]: 迁移未转义单引号
- [BUG]: 引用的默认字符串值存在问题
- [BUG]: SQL 命令顺序错误
- [BUG]: drizzle-orm/pg-core 中带精度的时间类型在类型周围添加了双引号
- [BUG]: 由于缺少引号导致 Postgres 推送失败
- [BUG]: TypeError: 无法读取未定义的属性 (读取 'compositePrimaryKeys')
- [BUG]: drizzle-kit introspect 在日期列上生成的 CURRENT_TIMESTAMP 缺少 sql 运算符
- [BUG]: Drizzle-kit introspect 未拉取正确的默认语句
- [BUG]: MacBook 上的问题 - 此语句不返回数据。请使用 run() 代替
- [BUG]: 作为数组使用的枚举列名未加引号
- [BUG]: drizzle-kit generate 忽略索引运算符
- [BUG]: dialect 参数配置错误消息有误
- [BUG]: 设置默认枚举字段值时出错
- [BUG]: drizzle-kit 不遵守 primaryKey() 中配置的列顺序
- [BUG]: 无法删除 MySQL 中的唯一约束
- Kit v0.27.2 发布
- [BUG]: 使用 drizzle-kit push 时未定义属性
- [BUG]: TypeError: 无法读取未定义的属性 (reading 'isRLSEnabled')
- [BUG]: 当从 drizzle-orm/supabase 推送包含链接策略的 schema 到表时,推送出现错误
- Kit v0.27.1 发布
- [BUG]: 使用 RLS 策略和视图时,视图是最后一个生成的子句
December 2024
- drizzle-seed v0.3.0 release
- The seed function can now accept Drizzle Relations objects and treat them as foreign key constraints
- ORM v0.38.3 release
- Fix incorrect deprecation detection for table declarations
- SingleStore dialect support for all validator packages
- drizzle-seed v0.2.1 release
- We are introducing a new parameter, version, to the seed function options. This parameter, which controls generator versioning, has been added to make it easier to update deterministic generators in the future.
- interval unique generator was changed and upgraded to v2
- string generators were changed and upgraded to v2
- ORM v0.38.2 release
- New features for MySQL users: USE INDEX, FORCE INDEX and IGNORE INDEX for MySQL
- Kit v0.30.1 release
- New command: drizzle-kit export
- drizzle-seed v0.1.3 release
- Added support for postgres uuid columns
- Added support for postgres array columns
- Added support for cyclic tables. You can now seed tables with cyclic relations.
-
Bug Fixes
- [BUG]: reset fails with a syntax error if using a - in pgTableCreator to prefix tables
- seeding a table with columns that have .default(sql``) will result in an error
- ORM bug fixes
- [FEATURE]: publish packages un-minified
- Don't allow unknown keys in drizzle-zod refinement
- [BUG]:drizzle-zod not working with pgSchema
- Add createUpdateSchema to drizzle-zod
- [BUG]:drizzle-zod produces wrong type
- [BUG]:Drizzle-zod:Boolean and Serial types from Schema are defined as enum
when using CreateInsertSchema and CreateSelectSchema - [BUG]: Drizzle typebox enum array wrong schema and type
- [BUG]:drizzle-zod not working with pgSchema
- [BUG]: drizzle-zod not parsing arrays correctly
- [BUG]: Drizzle typebox not supporting array
- [FEATURE]: Export factory functions from drizzle-zod to allow usage with extended Zod classes
- [FEATURE]: Add support for new pipe syntax for drizzle-valibot
- [BUG]: drizzle-zod's createInsertSchema() can't handle column of type vector
- [BUG]: drizzle-typebox fails to map geometry column to type-box schema
- [BUG]: drizzle-valibot does not provide types for returned schemas
- [BUG]: Drizzle-typebox types SQLite real field to string
- [BUG]: drizzle-zod: documented usage generates type error with exactOptionalPropertyTypes
- [BUG]: drizzle-zod does not respect/count db type range
- [BUG]: drizzle-zod not overriding optional
- [BUG]:drizzle-zod doesn't accept custom id value
- [FEATURE]: Support for Database Views in Drizzle Zod
- [BUG]: drizzle-valibot return type any
- [BUG]: drizzle-zod Type generation results in undefined types
- [BUG]: GeneratedAlwaysAs
- [FEATURE]: $inferSelect on a view
- [BUG]:Can't infer props from view in schema
- ORM v0.38.0 release
- Added new function getViewSelectedFields
- Added $inferSelect function to views
- Added InferSelectViewModel type for views
- Added isView function
- Kit v0.30.0 release Starting from this update, the PostgreSQL dialect will align with the behavior of all other dialects. It will no longer include IF NOT EXISTS, $DO, or similar statements, which could cause incorrect DDL statements to not fail when an object already exists in the database and should actually fail.
January
- ORM v0.39.1 release
- Fixed SQLite onConflict clauses being overwritten instead of stacked
- Added view support to aliasedTable()
- Fixed sql builder prefixing aliased views and tables with their schema
- Kit v0.30.4 release
- Fix bug that generates incorrect syntax when introspect in mysql
- Fix a bug that caused incorrect syntax output when introspect in unsigned columns
-
-
Bug Fixes
- Allow INSERT in CTEs (WITH clauses)]
- Support Raw SQL in CTE Query Builder]
- Include pre-defined database objects related to Neon Identity in drizzle-orm]
- $count is undefined on withReplicas]
- get[Materialized]ViewName, ie getTableName but for (materialized) views.]
- $count API error with vercel-postgres]
- Cannot use schema.coerce on refining drizzle-zod types]
- Type Coercion in drizzle-zod]
- The inferred type of X cannot be named without a reference ...
- drizzle-zod excessively deep and possibly infinite types]
- ORM v0.39.0 release
- You can now use the new Bun SQL driver released in Bun v1.2.0 with Drizzle
- WITH now supports INSERT, UPDATE, DELETE and raw sql template
- New tables in /neon import
- Added getViewName util function
- Kit v0.30.3 release
- As SingleStore did not support certain DDL statements before this release, you might encounter an error indicating that some schema changes cannot be applied due to a database issue. Starting from this version, drizzle-kit will detect such cases and initiate table recreation with data transfer between the tables
February
- Drizzle Studio updates:
- Added the ability to create/alter tables.
- Added the ability to create/alter views.
- Added the ability to refresh db schema.
- Improved dropdowns.
- Improved style customization.
- Added filter by entity type (table/view).
- Revised dependency tree and reduced bundle size.
- Added database metadata to bug report.
- Added range selection with copy/paste capability.
- ORM v0.40.0 release
- Drizzle is getting a new Gel dialect with its own types and Gel-specific logic. In this first iteration, almost all query-building features have been copied from the PostgreSQL dialect since Gel is fully PostgreSQL-compatible. The only change in this iteration is the data types. The Gel dialect has a different set of available data types, and all mappings for these types have been designed to avoid any extra conversions on Drizzle's side. This means you will insert and select exactly the same data as supported by the Gel protocol.
- Kit v0.30.5 release
- Drizzle is getting a new Gel dialect with its own types and Gel-specific logic. Kit is getting new "gel" dialect option
this month
- ORM v0.41.0 release
bigint
,number
modes forSQLite
,MySQL
,PostgreSQL
,SingleStore
decimal
&numeric
column types- Changed behavior of
sql-js
query preparation - Fixed
MySQL
,SingleStore
varchar
allowing not specifyinglength
in config - Fixed
MySQL
,SingleStore
binary
,varbinary
data\\type mismatches - Fixed
numeric
\\decimal
data\\type mismatches - Fixed
drizzle-studio
+AWS Data Api
connection issue - Fixed
isConfig
utility function checking types of wrong fields - Enabled
supportBigNumbers
in auto-createdmysql2
driver instances - Fixed custom schema tables querying in RQBv1
- Removed in-driver mapping for postgres types
- Fixed
SQLite
buffer
-modeblob
sometimes returningnumber[]
- Drizzle Studio updates:
- Added new setting option for expanding subviews.
- Added date and time pickers.
- New settings option for pagination by page or limit offset.
- Improved error handling for INSERT/UPDATE/DELETE statements in data table.
- Added column type to header cell.
- Added export in xlsx format.
- Added callback on bug report button click.
- Added ability to customize the error page.
- Added css variable for run query button color.
- Fixed issues with rowid.
- Improved SQL console with snippet system.
- ORM v0.40.1 release
- Updates to neon-http for @neondatabase/serverless@1.0.0. Starting from this version, drizzle-orm will be compatible with both @neondatabase/serverless <1.0 and >1.0
性能
Drizzle 不会减慢你的速度
Drizzle
v0.33.0
Bun v1.1.25
Prisma
v5.18.0
Bun v1.1.25
avg latency: 0.0ms
avg latency: 0.0ms
avg: 0 req/sec
Failed requests
Drizzle handled xNaN more requests
avg: 0 req/sec
Failed requests
Drizzle handled xNaN more requests
avg CPU load: 0.0%
avg CPU load: 0.0%
Live on the edge
We support every major serverful and serverless runtime

Vercel functions


Expo
Browser
Connect to any database
We support all platform-specific, tcp, http and websocket based drivers

our sponsor
Gelour sponsor
NeonVercel Postgres
our sponsor
Tursoour sponsor
XataPostgreSQL
our sponsor
TiDB

our sponsor
Temboour sponsor
SQLite Cloudour sponsor
SingleStorenot yet sponsor
Prisma PostgresDrizzle Studio
探索和处理你的数据


定价
开个玩笑,Drizzle 是免费开源的。
你仍然可以做出贡献!
你仍然可以做出贡献!


Developers love Drizzle ORM!

Dax
@thdxr
我讨厌 Drizzle

Anthony Shew
@anthonysheww
我非常讨厌 @DrizzleOrm,所以我为它编写了 Auth.js 适配器。

Adam
@adamdotdev
我知道这不会让我进入主页, 但是
@DrizzleORM 太棒了
Some Body
@dont_know
Django 在 2008 年就拥有了它

Eddy Vinck
@EddyVinckk
我喜欢 @DrizzleORM
就是这样,就是这条推文

Jacob Wolf 🐝
@JacobWolf
我喜欢 @DrizzleORM.

Theo
@t3dotgg
Drizzle 非常糟糕。它甚至都还不支持 Mongo。

Aaron Francis
@aarondfrancis
你们应该照搬 Eloquent 的所有内容

Ofelquis Gimenes
@imfelquis
不可预知的结果才是人类的生存之本,现在就禁止 Drizzle 和所有这些打字乱码

James Perkins
@james_r_perkins
抱歉 @DrizzleORM 你太糟糕了!


tslamoon
@tslamoon1
如果 drizzle 能在 9 月底之前增加对 MSSQL 的支持,我就剃光头。

fks
@FredKSchott
Astro DB 由 Drizzle 提供支持! ...我们对一切感到遗憾,天哪,这件事太糟糕了

Ray
@_raynirola
Drizzle Orm 不是一个 ORM ,它只是一个被高估的类型安全 SQL 包装器,甚至不是一个查询构建器。

SaltyAom
@saltyAom
Prisma Bun: 1.4 MB/s
Drizzle Bun: 9.8 MB/s


Christoffer Bjelke
@chribjel
这种小事已经多少次潜入你的依赖中了?


Roma Zvarych
@hisbvdis
我终于从 @prisma 切换到了 @DrizzleORM。这不是一件容易的事。亲爱的 Drizzle 团队,你们创造了一个很棒的 orm,但是文档很糟糕。无论如何,祝你们好运,谢谢。

Aoki
@aokijs
坦白说,我不在乎哪个基准测试更快。我只能说,Drizzle 让我的数据库工作生活有了显著的改善,这一点对我来说才是最重要的。感谢你的辛勤工作 🙏🏻

Matija Marohnić
@silvenon
每次我听说 @DrizzleORM。


Joseph Mama 🐀
@spacesexdragon
