github/dbx
4
0 Fork 0
mirror of https://github.com/t8y2/dbx.git synced 2026-11-14 14:49:41 +00:00
Code Issues Packages Projects Releases Wiki Activity
6,866 Commits 35 Branches 496 Tags
packages-v0.4.91
Commit Graph
2481 Commits
Author SHA1 Message Date
github-actions[bot] b5bf45e224 chore(packages): release 0.4.91 [skip node-packages-release] 2026-09-19 12:05:35 +00:00
t8y2 f638e31a79 chore(release): prepare v0.6.17 2026-09-19 19:42:29 +08:00
zipgandzipg 0adef6e16a fix(export): 分页导出按列名对齐每一页，修复字段错位 (#9583) 
Schemaless 引擎（Elasticsearch/Easysearch）的列集合是按每个响应里的文档现算的，
因此 select * 的不同分页可能给出不同的列顺序或列集合。查询结果导出把表头冻结在
第一页，却按位置写入后续页的行，导致第二页起的值落到错误的列里（#9522 反馈的
"导出字段错位"，例如 beta 的值被写进 alpha 列）。

- 新增 export_column_remap/realign_page_cells/realign_page_rows：后续页按列名映射到
  冻结表头，列名缺失时填 NULL，列顺序不同也能正确还原；
- 列类型同样按列名对齐，保证按页的日期/时间格式化使用正确的类型；
- spatial_values 随行一起对齐，保持与单元格的 SRID 对应关系；
- 第一页仍是表头来源，新增列（表头里没有的列）与被删除的列都会被忽略，行为与写出
  表头保持一致。

Co-authored-by: zipg <4047349+zipg@users.noreply.github.com>
 2026-09-19 15:23:22 +08:00
zipgandzipg 687b988b7d fix(mysql): 显式配置的 group_concat_max_len 稳定生效并补充连接表单提示 (#9582) 
DBX 连接 MySQL 时会执行 SET SESSION group_concat_max_len = 1048576，
避免 GROUP_CONCAT 结果被静默截断（#2775）。但当用户在 URL 参数里用
Connector/J 语法 sessionVariables=group_concat_max_len=... 显式指定值时，
内置语句与用户语句的执行先后取决于底层驱动，覆盖行为不具备确定性；
连接表单也没有任何提示，导致按服务端配置排查问题时被误导（#9412）。

- 新增显式覆盖检测：解析 sessionVariables 中的赋值目标，命中
  group_concat_max_len（含大小写、@ 前缀、session 限定）时不再下发内置的
  SET SESSION，用户/服务端的值始终生效；@user 变量与 @@global. 赋值不影响
  默认行为。
- 连接表单 URL 参数下方为 MySQL 增加提示，说明可用的覆盖写法
  （sessionVariables=group_concat_max_len=@@global.group_concat_max_len 即
  完全跟随服务端配置），并补齐 10 个语言包文案。

Co-authored-by: zipg <4047349+zipg@users.noreply.github.com>
 2026-09-19 15:23:16 +08:00
zipgandzipg 74c275b2ce fix(sqlserver): 表结构支持查看约束（主键/唯一/外键/检查/默认值） (#9581) 
SQL Server 连接的「编辑表结构」面板里只有 DDL/字段/索引/外键/触发器，
没有「约束」页签；用户无法查看某张表的约束。

list_constraints 在 SQL Server 驱动中完全缺失：驱动侧没有对应实现，
dbx-core 的 list_constraints_core 没有 SQL Server 分支，直接落到默认的
空数组；前端 tableMetadataCapabilities 也没有声明 sqlserver 支持，
因此即使是空页签也不会渲染。

- dbx-drivers 新增 list_constraints，用一条 UNION ALL 查询汇总
  sys.key_constraints（PK/UNIQUE）、sys.foreign_keys（含引用库表列、
  ON UPDATE/DELETE 动作、is_not_trusted）、sys.check_constraints、
  sys.default_constraints；列名用 FOR XML PATH('') 聚合，兼容 SQL Server
  2008（无 STRING_AGG）
- list_constraints_core 增加 SQL Server 分支与链接服务器早退
- tableMetadataCapabilities 为 sqlserver 打开 constraints，前端显示「约束」页签
- 新增单测覆盖 SQL 形态与列名拆包，并补充前端能力断言

Co-authored-by: zipg <4047349+zipg@users.noreply.github.com>
 2026-09-19 13:31:45 +08:00
КГБ Lieu 30fe61d440 fix(sql-file): extend relational constraint bypass to Postgres and SQL Server 2026-09-19 09:47:58 +08:00
Jinpy 2b15327de3 feat(plugins): hand SOCKS5 transport proxy routes to connections 2026-09-19 09:47:15 +08:00
ReadMe.md 1f43d184aa feat(sidebar): add nested virtual table groups with drag and batch move 2026-09-19 09:24:34 +08:00
Elias 0db9756a57 fix(xugu): restore table import support 2026-09-19 09:24:16 +08:00
zipg 00c4d30453 fix(agent): keep offline import resilient per item with os error detail 2026-09-19 00:22:18 +08:00
zipg e0e6a696b0 fix(kingbase): prefer factory default test database for empty connections 2026-09-19 00:21:57 +08:00
zipg c3d4061868 fix(agents): resolve system java from JAVA_HOME before PATH 2026-09-19 00:21:43 +08:00
Abeautifulsnow 5278594ed2 feat(mcp): make dbx_execute_query row limit configurable 2026-09-19 00:20:33 +08:00
t8y2 54652951d1 fix(mcp): use slice contains for sql risk classification 2026-09-18 23:20:01 +08:00
ccq 0f6db4b2c7 feat(mcp): record SQL executions in query history 2026-09-18 22:50:26 +08:00
zipg 68f905e0c2 fix(elasticsearch): retry /_sql with PUT on 405 for legacy clusters 2026-09-18 22:48:27 +08:00
zipg 2b075625f2 fix(mysql): stop single-statement BEGIN pinning autocommit read snapshot 2026-09-18 22:47:15 +08:00
Freedom 1321dc9b9d feat(plugins): improve connection lifecycle and session tabs 2026-09-18 22:10:37 +08:00
jearhe f033e50ef5 fix(compare): preserve duplicate keys while removing sample overlap 2026-09-18 21:17:38 +08:00
t8y2 24179cb45d fix(postgres): decode text-protocol booleans as typed values 2026-09-18 20:15:48 +08:00
dienaso ace100695f fix(export): preserve high-precision XLSX numbers as text 2026-09-18 17:29:41 +08:00
t8y2 23790bd5ee fix(mcp): validate sibling MongoDB commands 2026-09-18 17:01:04 +08:00
Loc Nguyen f1e0f54a2b feat(mongodb): support db.getSiblingDB() 2026-09-18 15:38:53 +08:00
大峰 b44e1080a8 feat(editor): semantic column navigation for CTE columns 2026-09-18 15:06:37 +08:00
Loc Nguyen 7c51454bfd feat(mongodb): support db.createCollection() and db.dropDatabase() 2026-09-18 15:06:29 +08:00
Loc Nguyen 2db28fc236 feat(mongodb): support db.collection.renameCollection() 2026-09-18 14:12:39 +08:00
jearhe 392138f59a refactor(sqlserver): resolve object source via OBJECT_ID identity 2026-09-18 14:12:12 +08:00
amwps290 1e99f12b1b fix(postgres): cast xml preview columns to text 2026-09-18 14:11:49 +08:00
二丫讲梵 3dea25eaa7 feat(data-grid): optional database/schema prefix in copied INSERT SQL 2026-09-18 14:11:41 +08:00
dadong a782039e1f fix(oracle): emit DEFAULT before NOT NULL in create-table columns 2026-09-18 14:11:33 +08:00
t8y2 bc00431834 feat(core): split foundational capabilities into dedicated crates 2026-09-18 13:00:56 +08:00
github-actions[bot] 97f7d9d396 chore(packages): release 0.4.90 [skip node-packages-release] 2026-09-17 18:39:57 +00:00
t8y2 1cb99f7b52 chore(release): prepare v0.6.16 2026-09-18 02:27:08 +08:00
t8y2 717cc318ed fix(transfer): omit unsupported Oracle create-table guards 
Closes #9298
 2026-09-18 01:32:31 +08:00
t8y2 d1a2d51351 fix(plugins): block updates while connections are active 2026-09-17 22:32:47 +08:00
Abeautifulsnow c040f9c9c3 fix(plugins): allow reinstalling rolled-back marketplace versions 2026-09-17 21:07:13 +08:00
t8y2 3b4f46253c fix(query): preserve integers beyond 64 bits in result serialization 
Closes #9310
 2026-09-17 20:13:04 +08:00
guan xin 6b81a98453 feat(dameng): show view validity and support recompilation 2026-09-17 19:30:44 +08:00
Jinpy e4bda693fb feat(plugins): add interactive prompts and richer connection forms 2026-09-17 19:29:28 +08:00
t8y2 fac270fc8a fix(mysql): refresh stale snapshots and streamline table reloads 2026-09-17 19:29:09 +08:00
Mo-Moore e00fbabb35 fix(oracle): include dictionary comments in table and view DDL 2026-09-17 19:28:50 +08:00
t8y2 be251d596e feat(sql-file): show byte-based import progress 
Closes #9440
 2026-09-17 18:37:56 +08:00
t8y2 fb25a66d7a fix(plugins): trust official signing keys for offline installation 2026-09-17 18:03:47 +08:00
t8y2 455117b8c5 feat(formatter): add custom default SQL layout engine 2026-09-17 17:21:47 +08:00
zipg 6d2c8a5edb fix(grid): exclude postgres serial primary keys in pk-free copies 2026-09-17 17:16:02 +08:00
gggaiitx dc4764e930 feat(export): add HTML export for query result grids 2026-09-17 17:14:55 +08:00
高桥凉介 d17ce46626 feat(export): honor exclude-primary-keys in SQL script exports 2026-09-17 14:13:36 +08:00
songpaopao 137a1a4161 fix(transfer): rewrite Oracle-family owner schema in reused DDL 2026-09-17 13:18:01 +08:00
Loc Nguyen f78dc1ba16 feat(mongodb): support bulkWrite 2026-09-17 12:54:21 +08:00
Abeautifulsnow 3f3c21aae9 feat(ai): add opt-in auto intent routing for the assistant 2026-09-17 12:53:55 +08:00