Release Notes

Make FlexTable look the way you want. Pick the fonts and colours for the editor, the data grids and the sidebars, in a redesigned Settings. Windows and dialogs keep their size, and Redis over TLS connects again.

What's Changed

• Fonts and colours for the editor, data grids, sidebars and panels, with a live preview per theme
• Settings redesigned as a desktop preference form
• Dialogs move and resize, and the main window keeps its size across launches
• Redis over TLS connects again
• The connection form asks each engine for the right fields, Oracle for a service name
• macOS builds are signed and notarized, so they open with no "damaged" warning

Oracle connections now work with older servers. Each connection picks its own Instant Client version, and FlexTable installs it for you.

What's Changed

• Choose the Oracle client version per connection: 23ai, 19c or 11.2
• 23ai downloads and installs automatically
• Use your own Instant Client for the versions Oracle's licence stops us shipping
• A login rejected with ORA-28040 or ORA-28041 now offers the fix inline
• macOS builds are signed and notarized, so they open with no "damaged" warning

FlexTable 0.11.0 adds three new database engines - Oracle, ClickHouse, and Amazon Redshift - bringing the total to 11 supported databases. Oracle arrives as a full engine with backup/restore, TLS, and Oracle-native schema modeling; ClickHouse and Redshift bring native query cancel and flavor-aware introspection. This release also introduces runtime driver downloads (fetch native drivers like the Oracle Instant Client on demand, signed and verified), plus a broad round of correctness fixes across SQLite, MongoDB, MariaDB, and schema-qualified table handling. macOS builds are Developer-ID signed and notarized - they open cleanly, with no "damaged" warning.

What's Changed

• New engine: Oracle - a full engine with its own provider and UI module: backup/restore (all schemas by default, with an optional schema filter), PDB-as-database / user-as-schema modeling, verify-full TLS with hostname enforcement, and instant-client pre-warm for a faster first connection.
• New engine: ClickHouse - columnar OLAP over the HTTP interface, with native query cancel, autocommit grid edits (no transactions), and AI-assistant tool support.
• New engine: Amazon Redshift - a PostgreSQL-flavor engine with Redshift-aware introspection for structure and object listing.
• Runtime driver downloads - fetch native database drivers (for example the Oracle Instant Client) on demand from a signed feed, gated in the connection form, with cancel support and hardened macOS de-quarantine for the downloaded bundles.
• Correctness fixes - SQLite DROP now targets the right table; MongoDB text-index fields read back correctly; MariaDB current_timestamp() defaults stay raw; schema-qualified and composite table references are handled consistently across export, import, structure, and grid refresh; and primary-key row identity matches case-insensitively.

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.