DbPaw v0.3.4

[0.3.4] - 2026-04-12

🚀 Features

• Add Apache Doris database driver support
• Add alter table UI for modifying table fields
• Replace table export context menu items with a single export dialog

🐛 Bug Fixes

• Quote string/enum default values in generated ALTER/CREATE TABLE SQL

🚜 Refactor

• (editor) Consolidate SQL completion into single customCompletion

⚙️ Miscellaneous Tasks

• Update version to v0.3.4

DbPaw v0.3.31

[0.3.31] - 2026-04-11

🚀 Features

• Export database sql from sidebar
• Add GUI-based create table feature
• Add database export format dialog

🐛 Bug Fixes

• Update bun.lock after version bump
• Update bun.lock after version bump
• Sync lockfiles after version bump to v0.3.3
• Reject SqlDdl format early in query export to prevent unreachable panic

💼 Other

• (deps-dev) Bump vite in the npm_and_yarn group across 1 directory
• (deps) Bump lodash in the npm_and_yarn group across 1 directory

⚡ Performance

• Avoid per-character Vec allocation in parse_sql_statements

⚙️ Miscellaneous Tasks

• Install Linux GTK dependencies for smoke and integration tests
• Split rust check from smoke tests
• Run cargo check directly in rust job

DbPaw v0.3.3

[0.3.3] - 2026-04-10

🚀 Features

• Expand create database charset and collation options
• Split SQL export into DML, DDL, and DML & DDL options
• (datagrid) Add inline column comment display toggle

🐛 Bug Fixes

• Prevent white screen on table load with error boundary and defensive guards
• (mssql) Add notice comment to reconstructed DDL export
• (ci) Pin bun version to 1.3.10 to fix lockfile mismatch

🚜 Refactor

• (transfer) Eliminate duplication and dead code in SQL export

⚙️ Miscellaneous Tasks

• Extract upgradelink-upload into standalone workflow
• Format code
• Update version to v0.3.3

DbPaw v0.3.2

Changelog

[v0.3.2]

Features

• Oracle database support — Added a full Oracle database driver (OCI-based) with connection, query execution, schema browsing, data import, and SSH tunnel support (default port 1521).

• PostgreSQL array column decoding — PostgreSQL array columns (_int4, _text, _jsonb, etc.) are now decoded as proper JSON arrays instead of raw {1,2,3} strings.

• Complex value viewer — JSON and array cells in query results are now clickable and open a viewer dialog with three display modes: JSON (raw), Tree, and Table.

• Column autocomplete in table filters — The filter input in table view now suggests column names as you type.

• Loading indicators — The Run button shows a spinner and is disabled during query execution to prevent duplicate submissions; clicking a table in the sidebar immediately opens a skeleton placeholder tab instead of a blank wait; sidebar tree nodes show a per-node spinner while lazily loading children.

Fixes

• UI: tabs fill full width — Sidebar "Connections / Queries" tabs and JSON viewer tabs now stretch to fill the full available width at any panel size, eliminating the gap that appeared when the panel was widened.

• Sidebar auto-reveal — Auto-reveal now only triggers on tab changes, preventing unintended expansions.

• Oracle: Instant Client missing hint — When an Oracle connection fails due to a missing Instant Client installation, the error message now includes a clear installation hint.

• PolarDB-X compatibility — Queries against PolarDB-X no longer fail on its vendor-specific prepared-statement error message (Preparedoes not support); the driver now correctly falls back to simple protocol.

Refactor

• Centralized all database driver metadata into driver-registry.tsx, removing duplicated definitions scattered across the codebase.

Tests

• Added integration tests for the Oracle driver.

• Expanded frontend unit test coverage across core modules.

---

[v0.3.2] — 中文

新功能

• Oracle 数据库支持 — 新增基于 OCI 的 Oracle 驱动，支持连接、查询、Schema 浏览、数据导入及 SSH 隧道（默认端口 1521）。

• PostgreSQL 数组列解析 — PostgreSQL 数组类型列（_int4、_text、_jsonb 等）现在正确解析为 JSON 数组，不再显示原始的 {1,2,3} 字符串。

• 复杂值查看器 — 查询结果中的 JSON / 数组单元格可点击弹出查看器，提供 JSON 原文、Tree 树形、Table 表格三种视图。

• 表格筛选列名自动补全 — 表格视图筛选输入框在输入时自动提示列名。

• 加载动画 — 查询执行期间 Run 按钮显示 spinner 并禁止重复提交；点击侧边栏表格立即打开骨架屏占位 tab，告别空白等待；侧边栏树节点懒加载时显示 per-node 加载动画。

修复

• UI：标签页填充宽度 — 侧边栏「连接/查询」标签及 JSON 查看器标签现在在任意面板宽度下均匀填满，不再出现拉伸后留白的问题。

• 侧边栏自动展开 — 自动展开逻辑修复为仅在 Tab 切换时触发，避免误触发。

• Oracle：Instant Client 缺失提示 — Oracle 连接因缺少 Instant Client 而失败时，错误信息中增加了清晰的安装提示。

• PolarDB-X 兼容性 — 兼容 PolarDB-X 特有的 prepared statement 报错信息（Preparedoes not support），驱动现在可正确回退至 simple protocol。

重构

• 将所有数据库驱动元数据集中到 driver-registry.tsx，消除各处散落的重复定义。

测试

• 新增 Oracle 驱动集成测试。

• 扩展前端核心模块单元测试覆盖率。

DbPaw v0.3.1

[0.3.1] - 2026-03-31

🐛 Bug Fixes

• (mysql) When the preprocessing protocol does not support it, the original query will be returned
• Allow selecting extensionless ssh keys on macos
• Honor embedded mysql host ports

💼 Other

• (deps) Bump picomatch in the npm_and_yarn group across 1 directory
• (deps) Bump yaml in the npm_and_yarn group across 1 directory

🎨 Styling

• Unify code formatting style, repair long line auto wrapping

🧪 Testing

• Add command integration tests for all databases

⚙️ Miscellaneous Tasks

• Improve the development tool chain and CI hierarchical access control
• Update version to v0.3.1

---

DbPaw v0.3.0

[0.3.0] - 2026-03-29

🚀 Features

• (db/ssh) Improve connection error handling and SSH tunnel default port
• (transfer) Supports importing SQL files to MySQL/PostgreSQL and full rollback
• (clickhouse) Supports the creation, update and deletion of ClickHouse tables
• (import) Extend SQL import support to more databases and improve error handling
• (test) Extend integration test to support MariaDB, SQL Server and SQLite
• (tests) Added ClickHouse and DuckDB integration test support
• (mssql) Introduce connection pool to improve concurrency performance and refactor tests
• (lib) Add direct call command function and extend integration test
• Add a new database integration script and update the ignore configuration

🐛 Bug Fixes

• (DataGrid) Fix the problem that the selected status is not reset correctly after deletion
• Fix the processing of empty passwords during the generation and normalization of connection strings
• (models) Hide sensitive fields in the Debug implementation of ConnectionForm
• Add ssl mode=DISABLED parameter in MySQL test DSN
• (mysql) Correctly handle the number of affected rows of INSERT/UPDATE/DELETE statements

🚜 Refactor

• (ai) Refactor prompt build to use system messages and independent history assembly

🎨 Styling

• Format code to conform to the project code style specification

🧪 Testing

• API key encryption and decryption test using random key
• Add integration test for all database drivers

⚙️ Miscellaneous Tasks

• Add integration test automation and CI pipeline
• Remove the old change log file to prepare for the new release process
• Update the project version number to 0.3.0

---

DbPaw v0.2.9

🚀 DbPaw v0.2.9 – 2026-03-25

We're excited to release DbPaw v0.2.9! This update brings several improvements to the sidebar, better SQL handling, table display consistency, and foundational enhancements for future features.

✨ Features

• Sidebar enhancements:

  • Added a new query function with support for the default database.
  • Added dedicated Database and Query folders in the sidebar tree for better organization.
  • Added localization support for sidebar layout options (i18n).

• Theme improvements:

  • Refactored theme system: removed custom theme color function and now uniformly uses the accent color across the app.

🐛 Bug Fixes

• Fixed MySQL error caused by excessive semicolons at the end of sub-query SQL.
• Improved subquery handling: strip trailing semicolons before JSON projection in the database layer.
• Fixed table column ordering: columns are now consistently kept in the order defined by metadata.
• Unified SQL editor selection styling.
• Aligned Tauri plugin versions for better compatibility.

⚙️ Other Changes

• Updated version to v0.2.9.
• Updated license information to Apache License 2.0.
• Fixed type-safe call of resolveInstall in the updater unit test.
• Merged several feature and fix branches into the release.
• Various internal cleanups and preparations for upcoming features.

📋 Full Changelog

You can view the complete list of commits on GitHub (or the specific release tag).

---

DbPaw v0.2.8

[0.2.8] - 2026-03-21

🚀 Features

• Disable the right-click menu in the production environment to improve security
• (data table) Add a new query button in the table view
• (connection) Add connection form input validation and normalization
• (settings) Add delete function to AI provider list

🐛 Bug Fixes

• (ssh) Set the ssh key path to None when it is an empty string
• (db) URL encoding the user name and password in the MySQL and PostgreSQL connection strings
• (DataGrid) Repairs replication operations and optimizes selected state management

💼 Other

• (deps) Bump tar
• (deps) Bump rustls-webpki

🚜 Refactor

• (ai/prompt) Simplify the construction logic of prompt words and remove hard coding rules

🧪 Testing

• Add unit tests for connection pool keys, error detection, and query processing
• Add a unit test to connect form validation and update services

⚙️ Miscellaneous Tasks

• Update version to 0.2.8

---

DbPaw v0.2.7

[0.2.7] - 2026-03-19

🚀 Features

• (i18n) Add multi-language support for sidebar tabs

🐛 Bug Fixes

• Fix the problem that resolveTableScope calls lack schema parameters in table data queries
• (ui) Fix the layout jitter problem during tab content switching
• (ui) Fix the problem that the tab close button is truncated when hovering

📚 Documentation

• Add multi-language contribution and development guide documentation

⚙️ Miscellaneous Tasks

• Update version to v0.2.7

DbPaw v0.2.6

[0.2.6] - 2026-03-14

🚀 Features

• (tauri) Enable development tools to facilitate debugging
• (updater) Implement background update task management and restart prompts
• (sidebar) Add schema nodes for databases that support multiple schemas
• (sidebar) Add context menu for database schema nodes
• (db) Improve high-precision numerical processing and error handling of multi-database drivers
• (editor) Supports executing selected SQL statements

🐛 Bug Fixes

• (duckdb) Extend SQL keyword detection to support more query types
• Prevent schema overview request race condition when switching databases
• Prevent query result race conditions from causing incorrect data to be displayed
• (DataGrid) Show Copy as SQL menu item only when table context exists

🚜 Refactor

• (Sidebar) Separate scrolling intention registration and UI state synchronization logic

📚 Documentation

• (settings) Update license information from MIT to Apache-2.0

⚙️ Miscellaneous Tasks

• Update version number to 0.2.6