Antares SQL 0.7.36-beta.0
This beta brings a few workflow improvements to the query editor and the data grid, a new language, and several fixes for MySQL/MariaDB, PostgreSQL and saved connections.
✨ New features
- Run the query under the cursor: press
Ctrl+Enter(Cmd+Enteron macOS) in a query tab to run only the statement where the cursor is, without selecting it first.F5still runs the whole tab. Thanks to @alvesbeto! - Go to a foreign key row: in query results, you can now jump from a foreign key value straight to the row it points to in the referenced table (from the right-click menu, or by clicking the value). Thanks to @devag-al!
- Named saved queries: you can now give a name to queries saved in the scratchpad, so they are easier to find. Thanks to @dajiaohuang!
- Table size in the sidebar (MySQL/MariaDB): a new per-connection option shows each table's size in the sidebar. It is off by default, because on schemas with many tables it can slow down loading.
- Polish translation: Antares is now available in Polish (pl-PL). Thanks to @Kristuff6669!
🐛 Bug fixes
- MySQL/MariaDB – table editing: saving changes to a table now runs a single
ALTER TABLEand only moves the columns you actually moved. You can now add a column after one you renamed in the same save, which used to fail with an "Unknown column" error (#991). Big tables are also rebuilt at most once per save. - MySQL/MariaDB – collations: fixed an error when loading collations on servers that return empty values for charset or default/compiled fields.
- PostgreSQL: dollar-quoted blocks (
$$ ... $$,$tag$ ... $tag$) are now detected correctly when a$appears inside a quoted string, so queries are split into statements correctly. Thanks to @Kovania! - Saved connections: fixed saved connections sometimes going missing after a restart. Thanks to Ohansyah!
- Saved connections: if the connections file can't be read, Antares now saves a backup copy (
.corrupt) before resetting it, so your data can still be recovered.
🔧 Under the hood
- Connection handling has been rewritten for all engines. SSH tunnels are now shared by all tabs and background tasks of a connection, which makes tunneled connections more reliable.
- Improved how SQL values and DDL statements are generated across engines, for more consistent behavior when editing data and table structures.