zqlcrab v0.1.3

🦀 zqlcrab v0.1.3

Fast, lightweight, GPU-accelerated database desktop client built with Rust & GPUI.

📋 Changelog

v0.1.3 Release Highlights:

• 📊 Accurate Affected-Row Counts (影响行数按实际变更显示):
  • Saving a grid change reloads the table with SELECT instead of running the editor's DELETE or UPDATE a second time.
  • BEGIN, COMMIT, and ROLLBACK are left out of the affected-row total, so a delete script reports the rows the DELETE changed.
  • A SELECT that returns no rows keeps its columns instead of showing "0 row(s) affected".

zqlcrab v0.1.2

🦀 zqlcrab v0.1.2

Fast, lightweight, GPU-accelerated database desktop client built with Rust & GPUI.

📋 Changelog

v0.1.2 Release Highlights:

• 🗑️ DataGrid Row Delete Commits by Primary Key (数据浏览按主键删除行):
  • Clicking Delete Row opens the SQL review immediately instead of only marking the row in memory.
  • PostgreSQL column metadata now includes primary keys, so the generated DELETE targets the key instead of every column.
  • A DELETE or UPDATE that matches zero rows rolls the transaction back instead of reporting success.
• 📥 Comprehensive Data Import Wizard for CSV, TSV & SQL (全面支持 CSV/TSV/SQL 数据导入向导):
  • Added native file picker (rfd) and file path input supporting .csv, .tsv, and .sql data formats.
  • Automatic CSV format sniffer with delimiter detection (comma, tab, semicolon, pipe), charset encoding detection (UTF-8, GBK/GB18030, UTF-16, Latin-1), and header row recognition.
  • Live data preview table with intelligent column-to-target field auto-mapping (exact, snake_case, camelCase, case-insensitive).
  • High-performance chunked batch insertion with real-time throughput metrics (rows/sec, progress percentage, elapsed time).
  • Configurable error policies: skip row, abort on error, or isolated row-by-row fallback insertion with downloadable error logs.
  • Accessible via Sidebar table context menu ("Import Data...") and DataGrid toolbar.
• 🚀 Multi-Statement Batch Script Execution & Rich PG Diagnostics (多语句批量执行与PostgreSQL诊断信息):
  • Added robust SQL tokenizer split_sql_statements properly handling single quotes, double quotes, MySQL backticks, PostgreSQL dollar quotes ($$...$$), and nested comments.
  • Enabled sequential multi-statement execution across PostgreSQL, MySQL, and SQLite adapters without failing on semicolons or prepared statement limitations.
  • Implemented detailed PostgreSQL diagnostic error formatting (format_pg_error), unpacking server severity, error message, detail, hint, table, and column rather than obscure db error.
  • Added UTF-8 character boundary safe truncation (truncate_sql_snippet) across all adapters, completely resolving panics when executing SQL scripts containing Chinese comments and multi-byte characters.
• 🏷️ Dialect-Aware Column Data Type Selection & Presets (新建表方言数据类型下拉选择与预设):
  • Added dialect-aware data type selectors in CreateTableModal with dedicated dropdown menus populated with standard types for PostgreSQL, MySQL, and SQLite while retaining direct text editability for custom types and length parameters.
  • Enhanced column header quick presets tailored to the active database family.
• 🛡️ Modal Overlay Event Occlusion & Click Penetration Elimination (遮罩层全局事件隔离防穿透):
  • Added GPUI .occlude() to all modal backdrops throughout the application, ensuring upper-layer dialog interactions strictly block mouse events from penetrating down to the underlying DataGrid cells, toolbar action buttons, editor buffers, and workspace navigation tabs.
  • Comprehensive coverage across all dialog flows: New Connection Modal (ConnectionDialog), Connection Error Diagnostic Modal (ConnectionErrorDialog), Table Visual Designer (CreateTableModal), Destructive Actions Confirmation (ConfirmDialog), Atomic SQL Changeset Review (SqlReviewModal), and Full Cell Value Inspector modal (DataGrid).
• 💻 Mac-Native Monochrome Silhouette Status Bar Tray (系统托盘剪影与高清比例重构):
  • Converted the macOS status bar tray icon into a template monochrome silhouette ([image setTemplate: YES]), automatically adapting to macOS light and dark menu bars with native system styling.
  • Tight bounding-box cropped icon assets (tray-icon.png and tray-icon@2x.png) with proportional dimensions (22.0pt × 16.0pt) for crisp rendering on Retina displays without edge clipping.
• 📐 Pixel-Perfect Colon-Aligned Tray Metrics (托盘指标按冒号精准对齐):
  • Rebuilt the status bar menu metric rows (Active:, DB:, Ping:, Memory:) using native AppKit dual-column NSView items.
  • Right-aligned metric labels and left-aligned metric values perfectly aligned at the colon :, eliminating proportional font spacing misalignments.
  • Real-time memory footprint tracking via macOS Darwin kernel TASK_VM_INFO physical footprint API matching Activity Monitor memory metrics.
• 🔄 Remote Gateway Protocol & Architectural Refinement:
  • Bumped server protocol and mock client specifications to v0.1.2.

zqlcrab v0.1.1

🦀 zqlcrab v0.1.1

Fast, lightweight, GPU-accelerated database desktop client built with Rust & GPUI.

📋 Changelog

v0.1.1 Release Highlights:

• 🔄 Real-Time GitHub Releases Update Checker:
  • Connected the Check for Updates button under Settings -> Appearance to live GitHub Releases REST API (/repos/hyzwhu/zqlcrab/releases/latest).
  • Added robust semantic version comparison logic with prerelease handling.
  • Interactive status badges: displays NEW v{version} badge with direct View Release navigation when updates are available, or a verified up-to-date timestamp.
• 🛠️ Live SQL Editor Customization & Real-Time Settings Synchronization:
  • Full real-time synchronization for all configuration options under Settings -> Editor: Font Family, Font Size, Tab Size (indentation width), Line Numbers gutter, Word Wrapping, Format on Run, and Bracket / Quote Auto-closing.
  • Custom font family and font size apply directly to the query console editor without requiring application restarts or tab reloads.
• 🚨 Connection Error Diagnostic Dialog & Overflow Protection:
  • Clear modal diagnostic error alert whenever a database connection fails, equipped with Retry, Edit Connection (pre-fills profile settings for instant correction), and Copy Error.
  • Bounded layout constraints and dynamic long-token wrapping (wrap_error_text) preventing unbroken error messages or URLs from overflowing modal boundaries across all dialogs.
• 🧹 Comprehensive Memory Optimization & Leak Fixes:
  • Integrated mimalloc global allocator for efficient query allocation recycling and lower RSS footprint under heavy query loads.
  • Aligned tray memory metrics with macOS Activity Monitor (PhysFootprint).
  • Resolved Objective-C MRC retention leaks in NSMenuItem and NSString references during macOS status bar menu updates (including Quick Connect submenus).
  • Gracefully teardown and disconnect previous database connection pools upon profile switching.
• ⚡ Zero-Copy Autocompletion Engine & Keystroke Optimization:
  • Eliminated UI freezes during SQL editing by switching to zero-copy schema cache reads under read lock.
  • Implemented zero-heap-allocation case-insensitive token matching and a 64-item cap to maintain a snappy 120 FPS.
  • Prioritized completion ranking: Keywords > Tables & Views > Built-in Functions > Snippets > Global Columns.
• 🛡️ Native macOS Status Bar Memory Leak Fix:
  • Resolved Objective-C MRC retention leak in NSMenuItem and NSString references during status bar menu updates.
• 💡 Instant Dot Syntax Column Autocomplete:
  • Typing . after any table name (e.g. SELECT users.) immediately triggers the full list of columns for that table, even when no column prefix character has been entered yet.
  • Smart identifier parsing with automatic stripping of quotes (`, ", []).
  • Asynchronous background schema prefetching keeps completion snappy and responsive without blocking the UI.
• 🎯 Run Selected SQL Query Range:
  • When text is highlighted or selected in the SQL Query Console, clicking Run (or pressing ⌘↵ / Ctrl+Enter) executes only the selected SQL fragment.
  • Automatically falls back to full-editor execution when no text is selected.
  • Selected query support extends to visual EXPLAIN query plan analysis.
• 🏗️ Cross-Platform Layered Architecture (Web / WASM + HTTP Gateway):
  • Clean separation between core database models, UI presentation, and network transport adapters.
  • Introduced RemoteHttpAdapter and gateway protocol specifications, enabling deployment as a Web/WASM frontend connected to a remote database gateway alongside native desktop direct socket connections.
  • Added comprehensive architectural blueprint in docs/architecture-web-wasm.md.
• 💻 Zedis-Style System Tray Integration:
  • Revamped tray menu with live connection indicators, latency metrics, and quick profile switching.

---

Prior Releases (v0.1.0 Initial Release)

• ⚡ GPU Accelerated 120 FPS UI: Native GPUI desktop application with instant startup and obsidian/light theme support.
• 🔌 Multi-Engine Relational Database Connectivity: Full async support for PostgreSQL, MySQL, and SQLite.
• 📊 Interactive Data Grid: Virtualized data grid with in-place cell editing, clone, insert, delete, and atomic SQL changeset transaction script review.
• 💻 SQL Query Console: Multi-tab query sessions, SQL formatter (sqlformat), and visual EXPLAIN query execution plan tree viewer.
• 🧭 Visual Table & Index Designer: Interactive schema creation with real-time dialect DDL preview, primary key, auto-increment, and index designer.
• 🖥️ macOS Native Integration: Native macOS menu bar, status bar item, Retina DMG installer, and cross-platform keyboard shortcuts.
• 📦 Cross-Platform Release Artifacts: Standalone packages for macOS (Apple Silicon & Intel DMG + tarball), Linux (x86_64 tarball), and Windows (x86_64 portable zip).

zqlcrab v0.1.0

🦀 zqlcrab v0.1.0

Fast, lightweight, GPU-accelerated database desktop client built with Rust & GPUI.

📋 Changelog

• v0.1.0 Initial Release:
  • ⚡ GPU Accelerated 120 FPS UI: Native GPUI desktop application with instant startup and obsidian/light theme support.
  • 🔌 Multi-Engine Relational Database Connectivity: Full async support for PostgreSQL, MySQL, and SQLite.
  • 📊 Interactive Data Grid: Virtualized data grid with in-place cell editing, clone, insert, delete, and atomic SQL changeset transaction script review.
  • 💻 SQL Query Console: Multi-tab query sessions, SQL formatter (sqlformat), and visual EXPLAIN query execution plan tree viewer.
  • 🧭 Visual Table & Index Designer: Interactive schema creation with real-time dialect DDL preview, primary key, auto-increment, and index designer.
  • 🖥️ macOS Native Integration: Native macOS menu bar, status bar item, Retina DMG installer, and cross-platform keyboard shortcuts.
  • 📦 Cross-Platform Release Artifacts: Standalone packages for macOS (Apple Silicon & Intel DMG + tarball), Linux (x86_64 tarball), and Windows (x86_64 portable zip).