Skip to content

VeloxDB v0.2.0

Choose a tag to compare

View all tags
@abeni16 abeni16 released this 20 May 11:07
v0.2.0
438c664

VeloxDB v0.2.0 Release Notes

PostgreSQL, MySQL, and SQLite — with localization, smarter errors, and a much more capable Ask Veloxy.

VeloxDB is no longer PostgreSQL-only on paper. This release makes multi-engine support feel first-class, adds full UI localization, upgrades Ask Veloxy from a SQL generator into a real schema-aware copilot, and surfaces database errors the way a desktop client should — with context you can act on.

Highlights

  • Localization — English and Chinese UI, switchable in Settings
  • Ask Veloxy — streaming responses, stop/cancel, suggestion chips, SQL actions wired into the editor
  • Clearer errors — Postgres SQLSTATE, DETAIL, HINT, and line/caret markers in the editor
  • Stable MySQL support — engine-aware queries, templates, and connection handling alongside PostgreSQL and SQLite
  • Polished onboarding — six-step tour covering engines, query workspace, ER diagram, and Veloxy

Localization

VeloxDB now speaks your language — literally.

  • Full UI internationalization via react-i18next
  • English and Chinese (Simplified) included at launch
  • Language picker in Settings → Appearance
  • Preference saved to local storage; falls back to your browser language on first launch

Menus, connection dialogs, query workspace, settings, onboarding, command palette, and Veloxy strings are all translated. More locales welcome via PR.

Ask Veloxy — Enhanced

Ask Veloxy is a signature VeloxDB feature, and this release makes it feel like a copilot rather than a one-shot prompt box.

Streaming & Control

  • Live streaming of assistant responses over OpenRouter SSE
  • Stop button to cancel in-flight requests
  • Smoother display during generation — no more raw truncated JSON in the chat pane

Smarter Conversation

  • Suggestion chips for quick follow-up questions
  • Clarification banner when the model needs more context
  • Warnings surfaced inline for risky or ambiguous replies
  • Table context chip in the header when Veloxy is scoped to a selected table

SQL Workflow

  • Copy, Insert, Replace, and Open in new tab actions for generated SQL
  • Chat stays read-only until you explicitly generate or run SQL
  • Confirmation guardrails for large reads and non-SELECT statements

Under the Hood

  • Higher token budget for longer, complete answers
  • Backend streaming with veloxy-stream-chunk events and cancel_veloxy_request
  • Markdown rendering for readable assistant replies

Configure your OpenRouter API key and model in Settings → Veloxy.

Enhanced Error Messages

Errors should tell you what went wrong and where — not dump opaque strings.

PostgreSQL

  • Structured formatting: severity, message, SQLSTATE, DETAIL, and HINT
  • Line and column markers with a caret under the offending SQL when Postgres reports a position
  • Editor lint diagnostics aligned with server-reported error locations

All Engines

  • Normalized AppError types with categories: connection, query, validation, transport, internal
  • Consistent toast and inline messaging across Tauri invoke, TanStack Query, and local validation
  • Engine-aware heuristics for common failure patterns (auth, SSL, missing tables/columns, syntax)

Stable MySQL Support

MySQL and MariaDB are supported as production-ready peers, not experimental add-ons.

  • Dedicated connection pooling for MySQL alongside PostgreSQL and SQLite
  • Engine-aware SQL — quick actions (SELECT, COUNT, INSERT/UPDATE/DELETE templates) respect the active connection engine
  • Connection strings — paste mysql://… URIs or use the field-based form
  • Schema explorer & query workspace work the same way across engines
  • SQLite also included: file paths, in-memory databases, and shared UI patterns

Connect to what you already run. Switch engines from the sidebar without changing your workflow.

Connection & Settings Improvements

  • Rename connections without recreating profiles
  • Native file picker for SSL/TLS certificates and SQLite database files
  • Notification level settings — control success and error toast verbosity
  • Detach deleted connections cleanly from open query tabs
  • Auto-reconnect and SSH tunnel support unchanged — now with better error feedback when things fail

Onboarding

First launch now walks through six focused steps:

Step Topic
1 Welcome — local-first, desktop-native SQL
2 Multi-engine — PostgreSQL, MySQL/MariaDB, SQLite
3 Query workspace — Monaco editor, virtualization, history
4 Visual ER diagram — schema design and DDL preview
5 Ask Veloxy — schema-aware copilot
6 Keyboard shortcuts — stay in flow

Other Improvements

  • Transactional SQL building for safer multi-statement execution
  • Improved JSON handling in query results and Veloxy responses
  • Multi-statement SQL splitting on the Rust backend
  • Desktop CI builds for Linux, macOS, and Windows (AppImage, DEB, MSI, NSIS, DMG)
  • Tooling updates: pnpm 10.12.1, workflow and workspace configuration fixes

Upgrade Notes

Before upgrading, review the following:

  • Ask Veloxy requires an OpenRouter API key (Settings → Veloxy)
  • Language defaults to English; change anytime in Settings
  • MySQL connections use port 3306 by default; PostgreSQL uses 5432
  • Existing saved connections and keychain credentials are preserved
Assets 7
Loading