Querya Desktop 0.4.15

[0.4.15] - 2026-09-07

Multi-tab SQL workspace sessions, fluid motion transitions, cohesive dialog UI system, content-aware adaptive column sizing and auto-fit in data grid, rich cell context menus, desktop file associations (.sql, .sqlite) with CLI open-with handling, categorized Master-Detail preferences with Keymap reference and theme editor modal, server-side column sorting in table views, connection tree quick search and pinning, and comprehensive UI freeze and isolate performance optimizations.

Added

• Fluid Motion Transitions & Micro-Interactions (#707, #708, #709) — Smooth cross-fade and scale tab switching in SqlQueryTabBar, springy hover feedback on buttons, cards, and tree items, and refined modal dialog entry/exit animations.
• Cohesive UI Dialog Card System (#710, #711, #712) — Standardized modal architecture across workspace and schema dialogs using QueryaDialogCard, unifying header titles, action footers, and border radii.
• Multi-Tab SQL Workspace (#679, PR #684) — Full support for multiple independent query sessions per connection with tab strip (SqlQueryTabBar), separate editor state, split panel sizing, query history, result grids, and DML staging buffers with IndexedStack state preservation and tab shortcuts (Ctrl+T, Ctrl+W, Ctrl+Tab, Ctrl+Shift+Tab).
• Adaptive Content-Aware Column Sizing & Auto-Fit (#676, PR #681) — Dynamic header-based minimum column widths (56px) without inflating compact columns (id, status), weighted distribution of excess viewport width in favor of long text fields (name, description), and double-click (onDoubleTap) on column header dividers for instantaneous content-aware auto-fit.
• Data Grid Cell Context Menu & Non-Destructive Actions (#678, PR #683) — Native right-click context menu with TSV/JSON/CSV copy formats (Copy Value, Copy with Headers, Copy as JSON/CSV), instant filter bridge (Filter by this value, Filter out this value), value inspector access (Ctrl+I), setting explicit NULL (Alt+N), and reverting cell changes.
• Desktop File Associations & Open-With Handlers (#694, PR #695) — Native file associations and Open-With support for SQL scripts (.sql) and SQLite databases (.db, .sqlite, .sqlite3) on Linux (.desktop, %F), macOS (Info.plist), and Windows (Inno Setup / Registry) via FileLaunchService.
• Master-Detail Categorized Preferences Dialog (#686, #687, #688, #689, PR #690, #691, #692, #693) — Modern two-pane Master-Detail preferences layout with sidebar categories (General, Appearance, SQL & Editor, Data Grid, Extensions, Keymap, About & Storage), global search (Ctrl+F), deep-linking, unified PreferencesSwitchRow toggles, update channel selector (Stable / Beta), interactive Keyboard Shortcuts (Keymap) reference matrix, and a dedicated visual Theme Editor modal window.
• Connection Tree Quick Search, Filtering & Pinning (#680, PR #685) — Global quick search in sidebar connections tree (Ctrl+F / Cmd+F) with auto-expanding matching folders, compact inline TreeObjectFilterBar for filtering tables/views/procedures in large schemas, and table/view pinning (⭐) with automatic top-of-list sorting.
• Interactive Server-Side Column Sorting (#696, PR #697) — Tri-state interactive server-side sorting (ASC -> DESC -> Natural) in SQLite, PostgreSQL, and MySQL table views with model row index mapping preservation in VirtualResultGrid.
• UI/UX Polishing for Data Grid, Filter Bar & Staging (#700, PR #701) — Semantic theme color tokens for filter suggestions (cs.popover, cs.popoverForeground, cs.border), disambiguated Export ▾ menu vs Save Changes button, keyboard shortcut tooltips (Ctrl+Insert, Ctrl+Delete, Ctrl+Z, Ctrl+S), and quick filter bar close button / Escape dismiss handling.

Changed & Performance

• Staging Buffer & Huge Result Performance Optimizations (#706) — Optimized staging diff resolution for large dataset modifications, avoiding unnecessary buffer cloning during high-throughput updates.
• Elimination of UI Freezes & Isolate Performance Optimizations (#702, PR #703) — Adaptive background isolate offloading for large table sorting (sortResultGridRowsWithIndicesAdaptive, $N \ge 3000$) with version tokenization, zero-allocation clean reads and caching in DataGridStagingBuffer.effectiveRows, caching of groupings tree in DataGridGroupingsView outside of build(), and 150ms debounced JSON/XML validation in DataGridValuePanel.
• Universal Syntax Highlighting & Flicker-Free Editor (#694, PR #695) — Enhanced SQL tokenizer and eliminated visual flicker during typing in QueryaCodeEditor.

Fixed

• Latent Bug Fixes & Stability (#677, #698, PR #682, #699) — Resolved layout overflows and bottom padding breaks across SQLite forms and database overview screens, fixed MySQL/MariaDB backslash escaping in DML generator, prevented memory leaks on Staging Buffer disposal and debounce timers, validated unclosed string literals in SQL filter AST parser, and sanitized pipe characters and quotes in Markdown and SQL INSERT export formats.

---

Downloads

Portable (zip — run from folder, no installer)

• Linux: Querya-Desktop-0.4.15-linux.zip
• Windows: Querya-Desktop-0.4.15-windows.zip
• macOS: Querya-Desktop-0.4.15-macos.zip (signed, notarized and stapled .app when Apple Developer secrets are configured; otherwise unsigned)

Optional USB-style profile: set QUERYA_PORTABLE=1 or create a QueryaData/ folder next to the binary (see docs/packaging.md).

Installable

• Linux AppImage: Querya-Desktop-0.4.15-linux.AppImage (chmod +x then run)
• Linux .deb (Debian/Ubuntu): Querya-Desktop-0.4.15-linux.deb — sudo apt install ./Querya-Desktop-0.4.15-linux.deb
• Linux .rpm (Fedora/RHEL): Querya-Desktop-0.4.15-linux.rpm — sudo dnf install ./Querya-Desktop-0.4.15-linux.rpm
• Linux Flatpak: Querya-Desktop-0.4.15-linux.flatpak — flatpak install --user ./Querya-Desktop-0.4.15-linux.flatpak
• Windows setup: Querya-Desktop-0.4.15-windows-setup.exe (Inno Setup)

Arch (AUR): querya-desktop — yay -S querya-desktop (auto-published when AUR_SSH_PRIVATE_KEY is configured).

Verify checksums: SHA256SUMS.txt

Build info

• pubspec: 0.4.15+1
• Commit: 1a7833b