Release Notes

FlexTable 0.10.0 sharpens the connection experience and helps you unlock Pro. The connection form now shows a per-pane status dot so you can see at a glance which sections are complete, valid, or still untested; Test Connection pre-validates required fields and gives a clear message instead of a cryptic backend error; and SSH tunnel settings now persist correctly on save and clear cleanly when disabled (MongoDB included). It also adds an in-app way to get FlexTable Pro - a "Get a license" action with one-click Activate, and, during a giveaway, a prompt so you don't miss a free key. macOS builds are Developer-ID signed and notarized, so they open cleanly with no "damaged" warning.

What's Changed

• Per-pane status on the connection form - each section (General, SSL, SSH, Organize) shows a status dot: green when filled and validated, red when something is wrong, white when configured but not yet tested - so you can spot an incomplete pane before saving.
• Test Connection pre-validates required fields - a missing host or connection string now surfaces a clear "required" message and takes you to the field, instead of firing the backend and returning a cryptic connect error.
• Reliable SSH tunnel settings - an SSH tunnel is now saved correctly with the connection and cleared cleanly when you turn the toggle off, MongoDB included.
• Get FlexTable Pro from inside the app - the title bar offers a "Get a license" action plus one-click Activate for an existing key, and surfaces a limited-time free-key giveaway when one is running so you do not miss it.
• Faster startup - the main window handle now loads without an extra lazy chunk.

FlexTable 0.9.0 adds Microsoft SQL Server as a first-class engine - connect, browse, run T-SQL, use the AI assistant, and back up/restore natively - bringing supported databases to six. It also makes integer values render as real numbers (not strings) across MySQL and PostgreSQL, and imports CSV/JSON into their native column types. macOS builds are Developer-ID signed and notarized, so they open cleanly with no "damaged" warning.

What's Changed

• SQL Server (MSSQL) support - a full new engine: connect, browse the schema, run T-SQL, use it with the AI assistant, and take native server-side backups and restores.
• Typed import - CSV and JSON import through their real column types, including JSON arrays into native PostgreSQL array columns, instead of being coerced to text.
• Numbers stay numbers - MySQL and PostgreSQL BIGINT, COUNT(*), and aggregate values render as actual numbers in the grid, export, and filters; only values too large for exact JavaScript integers fall back to a lossless string.
• Faster Redis browsing - opening a key makes a single round-trip instead of two, with safe previews for large values.
• Plus numerous fixes across backup, imports, and the Linux/macOS update flow.

New database engine (MariaDB), safer and clearer database imports, and a major pass on connection reliability - a dropped server, a reconnect, or browsing an offline connection now behave predictably instead of hanging or misreporting status.

What's Changed

• MariaDB support - MariaDB is now a first-class engine (connect, browse, query, structure, backup/restore), sharing the battle-tested MySQL provider.
• Redis Pub/Sub message detail - click a streamed message to inspect its full payload (JSON pretty-printed), not just the truncated row.
• JSON import - import a .json file straight into a table from the table import menu, alongside CSV and SQL.
• MySQL backup, no client needed - MySQL backup/restore now ships bundled client tools, so it works without installing a MySQL client.
• Connection menu - the header three-dot menu now offers View Config and state-aware Connect / Disconnect.
• AI Assistant - toggle the assistant panel from the title bar.
• A dropped server goes offline cleanly - across all engines (PostgreSQL, MySQL, MariaDB, MongoDB, Redis), a lost connection flips to offline with a clear "Connection lost" message instead of a raw driver error and a misleading green status.
• Self-healing reconnect - reopening, refreshing, or hitting Reconnect on an offline connection re-establishes it and reloads, no app restart needed.
• No more hanging on a dead connection - browsing a table on an offline connection fails fast with a "not connected" message and Reconnect, instead of spinning on a timeout.
• Disconnect keeps context - disconnecting keeps the connection selected in an offline view (with Reconnect) rather than dropping to a blank Connect screen.
• Isolated per connection - switching connections no longer leaks one connection's loading/refresh state onto another.
• Atomic SQL import - a SQL import runs in a single transaction: any failure rolls the whole thing back, and cancelling mid-import aborts the running statement and rolls back promptly (PostgreSQL, MySQL, SQLite).
• Honest, accurate import status and error messages; the import error dialog no longer overflows and lets you copy long errors.
• Grid rows keyed by the real primary key, fixing duplicate-key crashes on some tables.
• Correct "Report an issue" links and safer external-URL opening.

Faster, more responsive table browsing with progressive row streaming across MongoDB and SQL engines, plus connection-form and table-view improvements.

What's Changed

• Tables now load progressively in the grid via IPC row streaming, improving perceived performance and time-to-first-paint on slow connections.
• Enabled open-table streaming for MongoDB with results byte-identical to batch loading, so large collections start rendering sooner without changing data fidelity.
• Improved open-table performance through smarter chunk-size ramping, parallelized metadata/count loading, and connection-pool warming for concurrent queries.
• Added a "Modify" action to the table context menu that opens the Structure tab, automatically hidden for read-only views and engines without a structure view.
• Kept the MongoDB connection URI hint visible while typing and added an "Insert example" button that fills a skeleton URL.
• Fixed table-view correctness: honoring the global rows-per-page default, clearing table data/structure caches on "clear all," and connection-name visibility on hover.

This release improves transparency around AI data sharing, speeds up table opening, and tightens the feedback and update flows.

What's Changed

• Added a first-open warning about AI Assistant data sharing, so you can choose an LLM provider you trust before any data leaves the app.
• Faster table opening by reducing database round-trips (structure dedupe and additional guards).
• The Execution Log now shows each query's start time at millisecond precision, so parallel queries no longer look sequential.
• Fixed the in-app feedback and report-issue links to point at the correct public repository.
• Hardened the release and signing flow: stable auto-update is gated behind a manual promote, with fewer macOS credential prompts during signing.

macOS builds are Developer-ID signed and notarized, so they open cleanly with no "damaged" warning.

A security- and reliability-focused release. Connections, credentials, and backups are handled far more safely; the SSL "Auto" default now just works against non-TLS servers; schema editing is more faithful across engines; and data commits, transactions, and updates are more reliable.

What's Changed

Connections & credentials

• The credential encryption key is stored in an owner-only file on your machine (no OS keychain prompt), with a versioned, resilient encryption scheme - an undecryptable secret no longer blocks the app from loading your other connections.
• SSL "Auto" is opportunistic: it uses TLS when the server supports it and falls back to plaintext, so first connections to non-TLS databases just work (choose Require/Verify to enforce). A clear hint points at the right SSL mode when a TLS connection fails.
• Encrypted TLS client keys (PostgreSQL) and client-key passphrases (MongoDB) are supported, plus Redis private-CA and client-cert mTLS - including client certs under a non-verifying mode.
• Connection import/export is encrypted in the backend through a single, trusted path.
• Secrets are redacted from connection lists, trees, and logs, and decrypted secrets are wiped from memory as soon as they are no longer needed.

Backup & restore

• Restore is atomic and non-destructive per engine, and now surfaces warnings and counts in the restore dialog.
• Backup files are owner-only, and the MongoDB tool download is verified against a pinned SHA-256.
• Credentials are kept off command-line arguments and redacted from backup output.
• MySQL/PostgreSQL backups are built from structured config, and SQLite SQL dumps preserve full fidelity.
• Backup scope is validated with honest partial-capture reporting, and only the files a run created are cleaned up on failure.

Structure editor & DDL

• MySQL: a default-kind picker that distinguishes literal from expression defaults on a column.
• PostgreSQL: generated-column kind and full identity options are preserved, and columns resolve correctly across schemas.
• Copy the selected structure-table cell with Cmd/Ctrl+C, and long DDL preview statements now wrap instead of overflowing.

Query editor & sessions

• Run only the selected SQL in the query editor.
• Per-session locking prevents two sessions from interfering with each other.
• The title-bar URL re-syncs after you edit the active connection.

Reliability & updates

• Data edits commit cleanly: no more duplicate or contradictory transaction errors, and Cmd/Ctrl+S commits exactly once while flushing the cell you are still editing.
• Transactions are serialized per connection, so two tabs sharing a connection can't corrupt each other's transaction state.
• A launch-time "Update available" popup with a per-version opt-out, clearer updater failures with macOS app-translocation guidance, and 64-bit integer precision preserved across PostgreSQL, MySQL, SQLite, MongoDB, and Redis.