ORM 已为你准备妥当cross-out快速迭代
JavaScript
TypeScript
开始使用
文档
with db with db front front
back back
board
Play
Normal
powered by 3310snake.com
with db with db front front
back back love

我们发布速度相当快

Drizzle 团队活跃的贡献者

Andrew Sherman Andrew Sherman
Dan Kochetov Dan Kochetov
Alex Blokh Alex Blokh
Mykhailo Stratovych Mykhailo Stratovych
Roman Nabukhotnyi Roman Nabukhotnyi
Vladislav Stohnii Vladislav Stohnii
Serhii Reka Serhii Reka
Oleksii Khomenko Oleksii Khomenko
Artem Odiiko Artem Odiiko
Vitalii Staryk Vitalii Staryk
angelelz angelelz
rphlmr rphlmr
mario564 mario564
intelligently intelligently
June 2024
July 2024
August 2024
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.
  • Kit v0.29.0 发布 and ORM v0.37.0 发布
    • 新方言 SingleStore 在 Drizzle 中可用
    • 新驱动程序 Durable Objects SQLite 在 Drizzle 中可用
    • [BUG]: $with 在 withReplicas 上未定义
    • [BUG]: Neon 无服务器驱动程序接受 authToken 作为一个 promise,但 $withAuth 不接受。
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 for SQLite, MySQL, PostgreSQL, SingleStore decimal & numeric column types
    • Changed behavior of sql-js query preparation
    • Fixed MySQL, SingleStore varchar allowing not specifying length 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-created mysql2 driver instances
    • Fixed custom schema tables querying in RQBv1
    • Removed in-driver mapping for postgres types
    • Fixed SQLite buffer-mode blob sometimes returning number[]
  • 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 Logo
Prisma
v5.18.0
Bun Logo
avg latency: 0.0ms
avg latency: 0.0ms
avg: 0 req/sec
Failed requests
Drizzle handled xNaN more requests
0
avg: 0 req/sec
Failed requests
Drizzle handled xNaN more requests
0
avg CPU load: 0.0%
avg CPU load: 0.0%
前往基准测试结果
Live on the edge
We support every major serverful and serverless runtime
live on the edge
Cloudflare Workers
Supabase functions
Vercel functions
Created by potrace 1.15, written by Peter Selinger 2001-2017
Created by potrace 1.15, written by Peter Selinger 2001-2017
Deno deploy
Bun Logo
Bun Logo
Bun
Lagon
Fly.io
ElectronJS
Expo
React Logo
React Logo
React Native
Browser
Connect to any database
We support all platform-specific, tcp, http and websocket based drivers
connect everywhere
Drizzle Studio
探索和处理你的数据
Drizzle Studio Drizzle Studio
我们的赞助商
你帮助我们建设更美好的未来
成为赞助商
定价
开个玩笑,Drizzle 是免费开源的。
你仍然可以做出贡献!
Developers love Drizzle ORM!
thdxr
Dax
我讨厌 Drizzle
anthonysheww
Anthony Shew
我非常讨厌 @DrizzleOrm,所以我为它编写了 Auth.js 适配器。
adamdotdev
Adam
我知道这不会让我进入主页, 但是 @DrizzleORM 太棒了
dont_know
Some Body
Django 在 2008 年就拥有了它
EddyVinckk
Eddy Vinck
我喜欢 @DrizzleORM 就是这样,就是这条推文
JacobWolf
Jacob Wolf 🐝
我喜欢 @DrizzleORM.
t3dotgg
Theo
Drizzle 非常糟糕。它甚至都还不支持 Mongo。
aarondfrancis
Aaron Francis
你们应该照搬 Eloquent 的所有内容
imfelquis
Ofelquis Gimenes
不可预知的结果才是人类的生存之本,现在就禁止 Drizzle 和所有这些打字乱码
james_r_perkins
James Perkins
抱歉 @DrizzleORM 你太糟糕了!
James Perkins
tslamoon1
tslamoon
如果 drizzle 能在 9 月底之前增加对 MSSQL 的支持,我就剃光头。
FredKSchott
fks
Astro DB 由 Drizzle 提供支持! ...我们对一切感到遗憾,天哪,这件事太糟糕了
_raynirola
Ray
Drizzle Orm 不是一个 ORM ,它只是一个被高估的类型安全 SQL 包装器,甚至不是一个查询构建器。
saltyAom
SaltyAom
Prisma Bun: 1.4 MB/s Drizzle Bun: 9.8 MB/s
SaltyAom
chribjel
Christoffer Bjelke
这种小事已经多少次潜入你的依赖中了?
Christoffer Bjelke
hisbvdis
Roma Zvarych
我终于从 @prisma 切换到了 @DrizzleORM。这不是一件容易的事。亲爱的 Drizzle 团队,你们创造了一个很棒的 orm,但是文档很糟糕。无论如何,祝你们好运,谢谢。
aokijs
Aoki
坦白说,我不在乎哪个基准测试更快。我只能说,Drizzle 让我的数据库工作生活有了显著的改善,这一点对我来说才是最重要的。感谢你的辛勤工作 🙏🏻
silvenon
Matija Marohnić
每次我听说 @DrizzleORM
Matija Marohnić
spacesexdragon
Joseph Mama 🐀
Joseph Mama 🐀