v0.3.0 — The Engine Room

Core Architecture (Rust Refactor)

The entire Rust backend has been restructured for maintainability and extensibility.

• Module split — db.rs (1,090 lines) → 4 focused modules: connection_pool, retry, identifier_guard
• VeloxError enum — 7 typed error variants replacing ad-hoc Result<T, String> everywhere
• DatabaseEngineOps trait — EngineDispatcher static-dispatch enum, 6 per-engine modules in engines/
• 138 regression tests — integration tests covering all 6 engines, pure functions, and in-memory DB roundtrips

Connection Experience

• Connection string tab — paste any URI (postgresql://, mysql://, redis://, mongodb+srv://, sqlite://) and it auto-detects engine, host, port, and credentials
• MongoDB Atlas (SRV) — toggle "SRV connection" to use mongodb+srv:// scheme for Atlas clusters
• Redis polish — labels changed to "DB Number" / "default (optional)", user/password now optional
• JSON-based engine form config — replaced 233 lines of inline ternaries with a declarative ENGINE_FORM_CONFIG object per engine

Theming

6 new themes added to Light/Dark/System:

• Sepia — warm paper tones for long reading sessions
• Ocean — cool blue professional (Linear/Vercel feel)
• Forest — sage green, easy on eyes for extended coding
• Rose — warm mauve, soft evening palette
• Slate — high-contrast blue-gray (VS Code Darcula style)
• Amber — CRT terminal amber on black, minimal blue light

ER Diagram Intelligence

• "Inferred Schema" labels for MongoDB and Redis — shows collection/key structure discovered from sampling, with average field presence percentages
• BSON type inference — MongoDB columns now show types (string, objectId, array, integer) next to presence rates
• Redis key structure — lists, hashes, sets display their field layout in the diagram
• PostgreSQL partitions — partition children hidden from table list; only parent tables shown
• Model Inspector — collapses when no table selected (canvas fills space)

Auto-Update System

• Rust backend checks GitHub releases via semver comparison — no CSP bypass needed
• React Query frontend with 30-minute cache, 4-hour background auto-check
• Platform-specific download links (.dmg / .msi / .AppImage)
• Settings → About shows "Update Available" badge when a new version exists

UI Polish

• Settings moved to compact gear icon in header
• Ask Veloxy moved to header — always one click away
• Tighter tab padding, cleaner header layout
• No empty divs in connection form layout

---

Upgrading from v0.1.x: All existing connections, stored settings, and workflows are fully compatible. No migration needed.

VeloxDB v0.2.0

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

VeloxDB Release Notes

What's New

VeloxDB adds Ask Veloxy for AI-assisted SQL, expands to MySQL & SQLite, improves SSL cert picking, rename connection, toast levels, About + updates, and fixes maxQueryRows end-to-end — plus CI and docs polish.

---

Ask Veloxy — AI Assistant

• Natural language → SQL: Generate SQL from plain language prompts.
• Chat-style experience: Conversations and history for iterative refinement.
• Richer answers: Markdown rendering in the Ask Veloxy dialog (react-markdown).
• Stronger SQL generation: Iterations on prompts and model integration (OpenRouter-related fixes and typings).

---

Connections & Databases

• MySQL and SQLite: Connect alongside PostgreSQL; connection UI uses radio selection for engine type.
• Rename connection: Rename saved profiles without recreating them.
• SSL client certificates: Native file picker for choosing cert/key files where applicable.
• After-delete behavior: If a connection is removed, the query workspace detaches that connection cleanly instead of leaving stale state.

---

Settings & App Info

• Notification levels: Control how chatty toasts are (toast severity / volume settings).
• About: Version, license, links, and update check from Settings.
• Support: Sponsorship / support section in Settings.

---

Model (Diagram) Workspace

• Catalog & workspace: Clearer table counts on the diagram / model surfaces.

---

Reliability & Correctness

• maxQueryRows: Setting is wired through to query execution so the cap actually applies; follow-up fix so it stays applied consistently; tests added for the wiring.

---

Build, Release & Docs

• Desktop / Tauri CI: Workflow updates (pnpm order, Tauri build command, assets).
• Linux .deb package: Debian/Ubuntu package now supported as a distribution target.
• Versioning: Versioning scheme and asset references aligned with builds.
• Site & README: Project domain noted as veloxdb.dev; README updates ( contributing).
• Community: CODE_OF_CONDUCT.md added.

---

Misc Fixes

• Linting loop: Fix for a runaway / looping lint behavior (fix/linting-loop).

---

What's Changed

• feat: add notification level settings by @MowlCoder in #22
• feat: add rename connection function by @MowlCoder in #23
• Feat/support ai by @abeni16 in #24
• feat: implement detachDeletedConnection functionality in query workspace by @abeni16 in #27
• feat: add possibility to select file natively by @MowlCoder in #26

New Contributors

• @MowlCoder made their first contribution in #22

Full Changelog: 0.1.0-beta.8...veloxdb_0.1.0-8

VeloxDB 0.1.0-beta.8

VeloxDB 0.1.0-beta.8

This beta delivers the new multi-engine groundwork and ships the latest desktop build for macOS (Apple Silicon).

Highlights

• Added support for MySQL and SQLite connections in addition to PostgreSQL.
• Upgraded the connection flow with a clearer database-engine selector.
• Improved model workspace visibility with diagram table counts.
• Added support/sponsorship entry points from settings.

Also included

• Fix to ensure maxQueryRows settings are wired and applied correctly.
• About tab and update-checker improvements carried into this build.
• Documentation and onboarding polish from recent merged work.

Download

• veloxdb_0.1.0-beta.8_macos_aarch64.dmg (attached asset)

Integrity

• SHA-256: 306c6f9408887816e4af99e0a56478ee5ca026b6321229710aff40d891b3c9d0

Thanks for testing the beta and sharing feedback as we expand engine support.

0.1.0-beta.7

• Connection string mode — paste a PostgreSQL URI to auto-populate fields
• Toggle between connection string and individual fields modes
• Wider connection dialog with pinned footer and scrollable body
• Advanced parameters — configure connect_timeout, application_name, options, keepalives, TLS certs (sslrootcert/sslcert/sslkey), and custom libpq params
• Right-click context menus on database nodes (Refresh databases, Copy name)
• Connection context menu: Copy connection string
• Table context menu: Copy name, Truncate
• Result table column headers now display in original casing
• Rust: extra connection params applied to pool config, custom TLS cert support

v0.1.0-beta.6

What's New

Rust-Powered Export System

• Diagram PNG export via native save dialog (2x resolution)
• Results CSV/JSON export via native save dialog
• Rust SVG renderer backend (resvg) for high-quality diagram rendering

4-Level Tree Explorer

• Connection → Database → Table → Field hierarchy
• Keyboard navigation (arrow keys, Space/Enter)
• Lazy loading with inline spinners
• Virtualized rendering for large datasets
• Emerald green active states

Database Switcher

• Switch databases from sidebar (pgAdmin-style)
• [PG] engine badge on database nodes

Delete Rows

• PK-based deletion from results grid with confirmation

Fixes

• Model canvas zoom/pan on node hover
• Enhanced empty states with CTAs
• Query actions open new tabs

Download: veloxdb_0.1.0-beta.6_aarch64.dmg

v0.1.0-beta.5

What's New

4-Level Tree Explorer

• Connection → Database → Table → Field hierarchy in sidebar
• Keyboard navigation (arrow keys, Space/Enter)
• Lazy loading with inline spinners
• Virtualized rendering for large datasets
• Expanded state persists across sessions
• Emerald green active states throughout

Database Switcher

• Switch databases from sidebar without creating new connections
• [PG] engine badge on database nodes
• Auto-loads tables on database switch

Delete Rows

• Delete selected rows from results grid
• PK-based deletion with confirmation dialog
• Transaction-safe (BEGIN/COMMIT/ROLLBACK)

Other

• Generated SELECT queries now open in new tabs
• Fixed model canvas zoom/pan when hovering nodes
• Enhanced empty states with CTAs

VeloxDB v0.1.0 — mac and windows

Release Notes (v0.1.6)

PostgreSQL, Unleashed.
VeloxDB is now officially available on Windows. This release focuses on bringing a premium, lightweight, and developer-first experience to PostgreSQL management.

Features included in this release:

• Performance: Near-instant startup times and low RAM footprint.
• Editor: Full SQL syntax highlighting and auto-formatting.
• UI/UX: Modern, glassmorphism-inspired interface built with Shadcn/UI and Tailwind CSS.
• Connectivity: Secure PostgreSQL connections with robust error handling.

Full Changelog: v0.1.0-beta.5...VeloxDB-v0.1.0-windows

v0.1.0-beta.3

Changes

Bug Fix

• Cell editing fixed: Editing a cell in the results grid now correctly accepts typed input. Previously, column definitions recomputed on every parent render (e.g. SQL typing), causing the edit input to unmount/remount and reset to the original value.

New Feature

• Create Table in visual designer: The diagram toolbar now has a + button to create new tables. Define schema, table name, and columns — the CREATE TABLE is included in the migration preview and applied alongside your other model changes.

Post-install (macOS)

After installing, run this command to remove the quarantine flag:

xattr -cr /Applications/veloxdb.app

v0.1.0-beta.2

Fixes

• Cell editing bug fixed: Editing a cell in the results grid now correctly writes the typed value. Previously, a stale-ref issue caused the cell to show the original value instead of the edit.

Post-install (macOS)

After installing, run this command to remove the quarantine flag:

xattr -cr /Applications/veloxdb.app