1.4.8

Changed

  • Added cmd+d,cmd+b and ctrl+d,ctrl+b hotkeys to show the DB Explorer. #106
  • Improved autocomplete suggestions, including support for update, and common table expressions.
  • Added autocomplete support for EXEC procedure statements.
  • Autocomplete will work if statements are not seperated by a semi-colon. #46

1.4.7

Changed

  • Added cmd+f and ctrl+f hotkeys to search the grid. #106
  • Added support for JOIN, GROUP BY, HAVING, and ORDER BY to autocomplete. #59

Fixed

  • Azure Entra ID authentication was not refreshing the token.

1.4.6

Changed

  • Diagrams now show the primary key icon as highlighted.
  • Diagrams can now be saved as PDFs or PNGs. #38

1.4.4

Fixed

  • Postgres better detection of users access to databases when connecting. #105
  • Postgres errors not being raised when unable to connect to the server.

1.4.3

Changed

  • Binary cells can now have files loaded directly into them when editable. #104
  • More values are present in the Set Value menu for editable cells. #76

1.4.1

Fixed

  • SSH Config that failed parsing would cause the extension to crash.
  • Creating tables with single primary key column is now inlined in the DDL.
  • LibSQL was not showing the table structure for empty tables.
  • Creating tables in Cassandra with dual primary keys was producing invalid DDL.
  • Creating tables in Oracle with identity columns and single primary keys was producing invalid DDL.

1.4.0

Changed

  • Added Cassandra as a NoSQL database. #83
  • Added DuckDB as a SQL database. #106

Fixed

  • Fixed introspection query for MySQL 8 that was breaking the SQL parser in MySQL. #100
  • Boolean field editing caused an error. #102

1.3.18

Fixed

  • SQL Server tables were not editable. #93
  • MariaDB 10.4 and below connections did not work if the driver was set to MySQL. #86

1.3.17

Fixed

  • Parser error when loading tables from DB Explorer. #90

1.3.16

Fixed

  • Autocomplete now works with more complex Select statements (nested selects, alaised tables, etc).
  • Autocomplete now works with Delete statements.
  • Autocomplete now works with Insert statements, including nested selects.

1.3.15

Changed

  • New Charts added to the chart menu.
  • Option to expand/shrink the chart. #37

Fixed

  • Selecting MySQL for a MariaDB could lead to incorrect introspection being used, this is now fixed.
  • Tables named after SQL Keywords (eg user) were not editable.
  • Grid lines now show when enabled in a chart. #34
  • Autocomplete now suggests operators and multiple condition where clauses.

1.3.14

Fixed

  • SQL Server 2016 now works with the DB Explorer.

1.3.13

Changed

  • Data can now be changed without signing in/purchasing a subscription, however changes are not verified before applying them when not signed in/subscribed.
  • Updated the new connection UI.
  • Add the count of items in each “folder” in the DB Explorer.

Fixed

  • Introspection is now supported on MariaDB 10.3 and above.

1.3.11

Changed

  • Groups can now be renamed in the DBExplorer. #73

Fixed

  • D1 now shows views.
  • Introspection is now supported on MariaDB 10.0 and above. #74 and #71

1.3.10

Changed

  • Table DDL editing now uses transactions where appropriate.
  • Custom theme extensions are now supported for syntax highlighting in the table editor.

Fixed

  • MongoDB connections can now be created without a username. #70
  • MariaDB 10.5 or higher is required.