Skip to content

v0.7.36-beta.1

Pre-release
Pre-release

Choose a tag to compare

@github-actions github-actions released this 20 Nov 15:45
· 0 commits to master since this release

Antares SQL 0.7.36-beta.1

A big beta: a new query editor, a schema diagram, user management, PostgreSQL custom types, and a long list of fixes for connections, exports and editing data.

✨ New features

  • Schema diagram: open it from a schema's context menu to see its tables, their columns and the foreign keys between them. You can pan, zoom, drag tables, highlight relations and export the diagram as SVG.
  • User management (MySQL/MariaDB, PostgreSQL, Firebird SQL): the new "Manage users" tool, first in the workspace tools menu, lets you list, create, edit and delete database accounts with their privileges and roles. On MySQL/MariaDB you can also lock accounts and set resource limits. On PostgreSQL you can set role attributes, connection limits and password expiry. If you don't have management rights, you can still change your own password.
  • User-defined types (PostgreSQL): a new "Types" folder in every schema lets you create, edit and delete enum, composite, domain and range types. You can pick these types as column types in the table editor, and enum columns are edited with a dropdown of their values in the data grid. SQL exports now include every type in the schema.
  • New query editor: the query editor has been rebuilt with SQL highlighting for each engine and smarter autocompletion. It suggests schema objects, keywords and snippets, and lists a table's columns after you type table.. It also has a new search widget, and your existing editor themes carry over.
  • Editor shortcuts: the familiar editor shortcuts still work and no longer override the app's own shortcuts.

🐛 Bug fixes

  • Connections – dropped while idle: connections closed by firewalls or the server after some inactivity are now reopened automatically. Recurring error popups on idle PostgreSQL connections are gone. Fixes #820, #990, #790.
  • Connections – saved connections lost: the encryption key of saved connections is never replaced, so connections are no longer wiped. If they can't be decrypted, the original file is kept and you are told where it is. Fixes #913.
  • Export/Import – reliability: exporting large tables no longer runs out of memory. A crashed export or import no longer freezes the app, and several exports or imports in a row work. Fixes #970, #841, #1024, #897.
  • Query – scripts changed when run: running multi-statement scripts no longer changes text inside strings. Semicolons inside comments no longer split statements, and BEGIN; … COMMIT; blocks run correctly. Fixes #580, #1025.
  • Results – duplicate column names: queries such as SELECT a.id, b.id now show every column with its own value, instead of losing some values or showing them under the wrong header. Fixes #634, #975.
  • SQLite/Firebird – large integers: BIGINT values above 2^53 are no longer rounded. Fixes #997.
  • Data – binary primary keys: you can now update and delete rows whose primary key is a binary column. Fixes #1017.
  • MySQL – stored procedures: every result set returned by a procedure is now shown. Fixes #1040.
  • MySQL – CHECK constraints: column CHECK constraints are kept when you edit columns. Fixes #757.
  • MySQL – decimal parameters: routine parameters and return types keep their decimal scale. Fixes #955.
  • PostgreSQL – custom column types: you can now edit tables that have columns of custom types. Fixes #979.
  • PostgreSQL – procedure parameters: the parameters of stored procedures are shown again. Fixes #984.
  • PostgreSQL – crashes: the app no longer crashes on unexpected messages from the server. Fixes #861.
  • PostgreSQL – routine bodies: dollar-quoted routine bodies are highlighted as SQL.
  • SQLite – AUTOINCREMENT: editing a table keeps AUTOINCREMENT columns and their counter. Fixes #821.
  • SQLite – dates: dates stored as numbers are no longer shown or copied as bogus 1970 dates. Fixes #667.
  • SQLite – column names: inserting, editing, deleting and sorting rows now works with columns whose names need quoting. Fixes #892.
  • Firebird SQL – missing tables: tables now show up in the explorer on databases in older formats. Fixes #856.
  • Table editor – composite primary keys: you can create composite primary keys from the field context menu. Fixes #742.
  • Results – table aliases: edited cells now refresh in the results of queries that use table aliases. Fixes #637.
  • Connections – database switch: switching database now works on connections saved without a default database. Fixes #781.
  • Connections – folders: connection folders now stay in their saved order. Fixes #823.
  • Explorer – search filter: the search filter is cleared after reconnecting when its input is empty. Fixes #1042.
  • Query – save file: the "file saved" message no longer appears when the file wasn't actually written. Fixes #844.
  • Linux – query editor: underscores are no longer cut off. Fixes #888.
  • File selection: choosing a file in file fields (for example SQLite databases or SSH keys in the connection settings) works again.

🔧 Under the hood

  • Linux builds no longer include 32-bit ARM (armv7l) packages, because Electron no longer supports that platform.