Release v1.4.1

JiveDB 1.4.1

One client for all your databases — PostgreSQL, MySQL, SQLite, and Redis in a single lightweight native app.

New Features

• Auto-arrange for ERD diagrams — a toolbar button cycles through several layouts (balanced grid, wide, tall, and grouping by relationship clusters) using each entity's real size so nothing overlaps; click until you find the layout you like. Positions are saved per diagram.
• Zone colors — the ERD zone palette now offers 20 colors with an in-canvas color picker (click the color dot on a zone header to open the swatch grid).
• MySQL database picker — the SQL editor toolbar now lets a single MySQL connection switch between its databases, defaulting to the one you are working in.

Improvements

• Schema-aware SQL autocomplete — table and column suggestions now match the selected PostgreSQL database and schema instead of always falling back to public; switching the database > schema picker reloads suggestions for that schema.
• PostgreSQL connections with many databases/schemas — the Query tab's database > schema picker loads every database and its schemas (in parallel, tolerant of databases you cannot access) and inherits the database/schema you were last working in.
• ERD entities are expanded by default so long column names and types no longer spill outside the box; in collapse mode, long names, types, and titles are shortened with an ellipsis and the full value is shown on hover.
• ERD interaction — drag an entity by its header only (clicking the body selects it without moving it), and double-click an entity's header to expand or collapse just that entity.
• ERD toolbar is now responsive — it collapses to icons only on narrow widths (under 1200px) or when the DDL info panel is open, and every button has a tooltip.
• New zones are placed at the center of the current view instead of a fixed corner.
• ERD focus mode (View ERD for a specific table) keeps the focused table as the diagram's root — it can no longer be removed from the canvas.
• Removing an entity from a diagram now asks for confirmation.
• The DDL info panel no longer flickers when switching between entities — the previous content stays until the new definition loads.

Bug Fixes

• SQLite data safety — fixed an issue where a SQLite file could become corrupted or truncated to zero bytes over time (especially after abrupt shutdowns). Access to the file is now serialized, the connection uses safer write settings (WAL journaling), and connections are closed cleanly on exit so the database is finalized correctly.
• ERD entity selection — fixed clicks on an entity sometimes not registering, so opening an entity's DDL now works reliably.
• Removed the outdated "Double-click a table to edit" hint from the ERD view.

Release v1.4.0

JiveDB 1.4.0

One client for all your databases — PostgreSQL, MySQL, SQLite, and Redis in a single lightweight native app.

New Features

• Secure connections — TLS/SSL for PostgreSQL, MySQL, and Redis with all four modes (disable / require / verify-ca / verify-full), a private CA, and client-certificate auth (mTLS). verify-ca / verify-full require an explicit Server CA (no silent fallback to the system trust store).
• SSH tunnel (single-hop) for any connection — authenticate by password or private key (with passphrase); the tunnel automatically reconnects if the link drops. SSH passwords and key passphrases are encrypted at rest.
• Redesigned connection dialog with tabs — Connection / TLS/SSL / SSH Tunnel — showing only the fields relevant to the selected TLS mode, active badges on the TLS and SSH tabs, and validation for the CA / mTLS certificate pair.
• Partitioned tables for PostgreSQL and MySQL — parent tables are marked and their partitions (and sub-partitions) nest beneath them in the sidebar; open a single partition's data directly, with partition icons and a bound/range tooltip.
• ERD editing — add entities by picking tables not yet on the canvas; create, list, and delete virtual relations (virtual foreign keys, 1‑1 / 1‑many, with an optional note); and group entities into module zones. Positions, hidden/added entities, virtual relations, and zones are saved per diagram.
• JSON Viewer — right-click a row number to view selected rows as JSON, with recursive lazy-loading of foreign keys, node deletion, and Copy JSON. Structured types map to real JSON: json/jsonb → object/array, geometry → number arrays, arrays → JSON arrays, circle → {x, y, r}; precision-sensitive types (bigint, numeric, decimal, money) stay as strings.
• FK Peek — click the foreign-key icon on a cell to preview the referenced row inline (name/type + value), up to 10 columns.
• Type-aware Add/Edit forms — dedicated editors for arrays, enum/set, JSON, binary (view-only), circle, geometry (point/line/segment/box/path/polygon), and a date/time picker.
• Third-party licenses viewer in the About dialog (lazy-loaded).

Improvements

• Row and Cell edit modes (default Row) — double-clicking a cell opens a focused single-field form; the old full-size edit modal is gone.
• Saves only the cells you changed (diffed against the original by primary key), with a modified-field indicator.
• Richer cell selection — adjacent cells (Shift+Click), whole rows and columns, and ⌘/Ctrl+A to select all cells.
• "Set value" action for a whole column (simple types), a rows-per-page popover (25–10,000), and a go-to-page popover.
• Column headers now show the data type beneath the column name, with a comment/type tooltip.
• Sidebar — highlights the default database (when there are more than three), flags databases that failed to open, and lets you hide/unhide databases (persisted) without reloading the tree.
• Deleting a connection now closes its live connection and clears its tabs and schema cache.
• Schema object types display readable names instead of raw PostgreSQL OIDs.
• Certificate and key file pickers now work on macOS.

Bug Fixes

• A burst of notifications no longer covers the header — toasts are capped and the toaster height is bounded.
• The cell you're editing is now committed when you click another cell.
• Cell interaction polish — hover highlight and the correct default cursor on cells.

Release v1.3.1

JiveDB 1.3.1

One client for all your databases — PostgreSQL, MySQL, SQLite, and Redis in a single lightweight native app.

New Features

• Automatic update check on launch against the release server, with a pulsing "new version" badge on the title bar that opens the About dialog.
• Select the entire table at once: ⌘/Ctrl+A, or click the top-left "#" corner.
• Data exports are named after the table (e.g. users.csv, users-selection.xlsx); query results fall back to export.*.
• Minimum window size so the layout no longer breaks when the window is shrunk.
• Feedback form preview (under development) — the UI is available, but sending is disabled for now.

Bug Fixes

• Fixed ERD "Export SVG" producing a blank image when opened outside the app — colors are now embedded so the diagram renders in any viewer.
• ERD table headers are inset slightly so the card border wraps around them evenly.
• Light-theme ERD exports now use the correct background instead of a forced dark one.

Release v1.3.0

JiveDB 1.3.0

One client for all your databases — PostgreSQL, MySQL, SQLite, and Redis in a single lightweight native app.

New Features

• Multi-database connections: PostgreSQL, MySQL, SQLite, Redis; passwords encrypted at rest (AES-256-GCM).
• Metadata tree: databases, schemas, tables, views, routines, sequences, types.
• Powerful data grid: inline cell editing, add/delete rows, undo (⌘Z), filter & sort.
• Free-form WHERE / ORDER BY bar right on the data tab (power users).
• Pagination and jump-to-referenced-row via foreign keys (FK navigation).
• Data export: CSV, JSON, clipboard, and Excel (.xlsx).
• SQL editor (CodeMirror): run statements, format, column autocomplete, multi-statement.
• Query history and Command Palette (⌘K) for quick actions.
• ERD diagram (view-only) with a DDL panel and SVG export.
• Schema Info tab for an overview of schemas/tables.
• Redis operations: browse keys, view/edit values, run commands.
• Multi-provider AI: chat, SQL generation, dialect conversion, optimize/explain, data dictionary.
• Built-in AI provider & model editor in Settings.
• Light/dark themes with accent colors; bilingual Vietnamese / English.
• Customizable hotkeys; App Logs panel to track activity.
• Automatic update check on launch plus a notice in the title bar.

Bug Fixes

• Cells are no longer marked "edited" when only selected/clicked without changing the value.
• Fixed the About dialog showing a blank screen due to a missing update binding.
• Standardized hotkeys (Command Palette ⌘K, Toggle Sidebar ⌘B, Format ⇧⌥F).
• Disabled all hotkeys when no connection exists to avoid accidental actions.
• Added a minimum window size to prevent the UI from breaking when shrunk.
• SQLite now reloads the correct data and closes related tabs after structure changes.