¶Changelog

The authoritative changelog is CHANGELOG.md in the repository, which is private. Highlights of each release are below, newest first.

¶0.8.3

Two fixes for MySQL and MariaDB, both introduced when those engines were added in 0.8.1.

• Queries now run against the database you picked. An unqualified query could fail with "No database selected" even though the database was open in the navigator and its tables were listed.
• TIMESTAMP columns show their values. Columns such as created_at and updated_at rendered as empty cells. A value that cannot be decoded now says so instead of showing nothing.
• A new query tab opens empty rather than on SELECT 1;.

¶0.8.2

The navigator is a tree, and deleting a connection asks first.

• One tree — connection, then its databases, then Tables and Views. Expand a connection to open it; several can be open at once. Objects load when you expand a database rather than all at once.
• Deleting a connection now asks, and says that only the saved profile and its password go — the database itself is untouched.
• Disconnect is a button on the connection row. It used to be hidden behind a right-click.
• The database from the connection's profile is the one opened, and it is expanded straight away.

¶0.8.1

Connect through an SSH tunnel, and to MySQL and MariaDB.

• SSH tunnelling (Pro) — reach a database behind a bastion. It uses your own ssh, so ~/.ssh/config, ssh-agent, hardware keys and ProxyJump work as they already do. Sign-in is by key or agent; an unknown host key is refused, so connect once from a terminal to accept the fingerprint first.
• MySQL and MariaDB join ElyraSQL and SQLite in the engine list, with the right default port and the right privilege model for each.
• Fixed: on MySQL, database and column names could appear as "[21 bytes]" instead of names.
• Fixed: a server offering TLS with a certificate the client would not accept could not be connected to at all, even with TLS left optional.

¶0.8.0

Updates are now signature-verified, and a security review is closed at all three severities. Little changes in daily use; what changes is what the app refuses.

• Signed updates — each downloaded artifact is checked against an ed25519 signature, not just a checksum. An update without a valid signature is refused.
• Binary columns are no longer silently corrupted when copying between connections. A BLOB rendered as [N bytes] used to be written to the target as that literal text, and reported as success.
• Passwords no longer appear in the query history — IDENTIFIED BY and SET PASSWORD values are redacted before a statement is recorded.
• Paging a table without a single-column primary key is stable. Without an ORDER BY the server may return rows in a different order between requests, so rows could be skipped or shown twice.
• User administration asks for confirmation on a production connection, like every other write.
• CSV export no longer emits live spreadsheet formulas from cell values.
• The licence key is stored in the keychain rather than a cleartext file.
• The macOS disk image is signed and notarized.

¶0.7.0

Query control, role-based user administration, and a security pass — plus the first release verified end to end against a real ElyraSQL Server in CI.

• Stop a running query with ⌘., and set an optional statement timeout per connection. It interrupts the statement, rather than just abandoning the results.
• User administration uses roles. ElyraSQL has three tiers — read, write, admin — and they form a ladder. The old privilege checkboxes implied combinations that don't exist, and never worked against the server anyway.
• Fixed: the client could not connect to ElyraSQL Server 1.9.4. Note that TIMESTAMP values now arrive in the server's timezone rather than UTC; the server offers no way to pin it.
• Safety rails no longer fail open. A statement the classifier didn't recognise used to execute unchecked on a read-only connection.
• Large reads are streamed, so an unbounded SELECT no longer pulls a whole table into memory before discarding it.
• The webview is locked to its own origin with a CSP, updates can be signature-verified, and the rsa advisory is gone from the dependency tree.

¶0.6.0

Security, correctness and performance — closes every finding from an audit of the data paths.

• Correct SQL quoting. Values containing a backslash were corrupted on SQLite, and text that merely looked numeric (007) could be altered. All SQL now goes through one engine-aware, unit-tested quoting layer; LIKE filters escape %/_ properly.
• Write rails everywhere. Read-only and production confirmation now apply to every write path (Tools, import, inline editing, designer), enforced once in the connection broker.
• Data Transfer is ~1.8× faster with flat memory (keyset paging + streaming into one transaction), and can no longer skip or duplicate rows.
• Unencrypted remote connections are flagged, and Require TLS defaults on for non-local hosts.
• Bounded column profile sampling, honest chart row limits, and a single-query FK map for SQLite.

¶0.5.0

• Tools sync trio: Structure Synchronization (schema diff/apply) and Data Synchronization (row diff/merge) join Data Transfer.
• Charts — visualise any result as bar/line/area/pie.
• Column profile — right-click a header for instant stats + top values.

¶0.4.0

• Tools menu: Data Transfer (copy tables between databases/connections), Data Generation (fill a table with test data), plus data dictionary, console, find-in-database, server monitor and history log.
• Right-click context menus on connections (colour tags, duplicate, edit…) and databases (dump schema, new/drop database, backup…).
• Filter & Sort panel with server-side multi-column sort, and an icon toolbar above the grid.
• The command palette also opens with ⌘/Ctrl + P.

¶0.3.1

• Fix: clicking a table shows its rows again.

¶0.3.0

• SQLite support — connect to local SQLite files alongside ElyraSQL Server.
• Automatic updates with checksum-verified downloads from elyracode.com.
• Click a column header to sort; browse loads up to 1000 rows.
• All features are always visible; gated actions open a friendly upgrade dialog.
• About dialog, and inline Test connection feedback.

¶0.2.0

• Single binary with online licensing (Free / Pro / Premium) validated against elyracode.com and cached with a 14-day offline grace period.
• Self-contained workspace (vendored shell/runtime) and a complete docs site.

See Editions & Licensing for what each tier unlocks.

¶0.1.0 — first release

• Connections with environment tags, keychain-stored secrets, optional TLS, and production/read-only safety rails.
• Object navigator, tabbed workspace, and a ⌘K command palette.
• CodeMirror SQL editor with schema autocomplete, EXPLAIN, formatting, history and saved queries; a visual Query Builder.
• Virtualized data grid with server-side keyset pagination, no-SQL filters, foreign-key jumps, and transactional inline editing.
• Table designer, ER diagram, import/export (CSV/JSON/SQL/XLSX), backup, and server tools (status, process list, user administration).