Changelog

Track our development progress with detailed updates, improvements, and bug fixes.

  • v1.16.6

    Changed

    • Execution Plans: Initial preview of execution plan support has been added. #376.
    • Connection Pinning: Added Oracle, DB2, ClickHouse, and Snowflake (with SSO token caching) support for connection pinning to maintain session state across query executions. #663
    • BigQuery: Use table list api when opening a table (only possible when no sorting or filtering applied). #693
    • BigQuery: Added support for dry run query execution. #693
    • BigQuery: Always show bytes billed, even if 0. #693
    • BigQuery: Added BI Engine information to the meta data display when present. #693
  • v1.16.5

    Changed

    • Keyboard Shortcut: shift+cmd/ctrl+d shift+cmd/ctrl+b will open up selector to choose database (or connection) when in a SQL file. #690
    • Connection Pinning: Added MariaDB, and MySQL to pin a connection to the editor. #663
    • Connection Settings: Added variable substitution support for file paths in connection configurations. Supports ${workspaceFolder}, ${workspaceRoot}, ${home}, ${env:VARIABLE_NAME}, and relative paths. #683
    • USE Command: Will update displayed database when database supports USE command and connection pinning.
    • Bigquery: Added Bytes billed metadata. #693
  • v1.16.4

    Changed

    • Results: Added keyboard shortcuts to the tooltips.

    Fixed

    • SQLite: Fixed issue where primary keys were not detected when not present in PRAGMA_index_list.
    • Cassandra: Fixed SSL certificate validation errors. #640
    • Oracle: Fixed crash when using Instant Client after initialization. #674
  • v1.16.3

    Changed

    • Firebase: Added support for editing sub collections.
    • Firebase: Added support for multiple Firestore databases.
    • Code Completion: Experimental LS now provides table/column context and CTE understanding.

    Fixed

    • Trino: Fixed map, array, and row types displaying as “[object Object]” in query results. #670
  • v1.16.2

    Changed

    • Firebase: Handles setting (undefined) for a value to make the key undefined.
    • MongoDB: Handles setting (undefined) for a value to make the key undefined.

    Fixed

    • Added groups to escaped identifier list.
  • v1.16.1

    Changed

    • Result: Editor now auto formats and focuses when opened, as well as auto detecting language.
    • Firebase: Will destructure data into keys where possible allowing specific key editing.
    • Code Completion: Will use new experimental language server if enabled.

    Fixed

    • SQL Server: Fixed BIT columns incorrectly exported as ‘true’/‘false’ instead of 1/0 in SQL Insert statements. #658
  • v1.16.0

    Changed

    • Firebase: Added initial preview support for Firestore and Realtime (editing not supported yet, might be some bugs.) #295
    • Syntax validation: Fixed semantic validation not working, enhanced grammar support, added fallback ANSI grammar.
  • v1.15.0

    Changed

    • Parquet: Added support for parquet files. #177
    • Avro: Added support for Avro files.
    • Redis: Added editing support (update, delete, insert), as well as editor logic for hash/sets. #39
    • CSV and Excel: Underlying files will be watched for changes, and re-load the data if the underlying file changes.

    Fixed

    • Tunnels: Will now better handle reconnecting, and if it fails, will close connections that were using them to avoid connections attempting to use closed tunnels.
    • Notebooks: Fixed issue with canceling and connection pinning. #663
  • v1.14.30

    Changed

    • Syntax validation: Experimental support for SQL syntax validation added (Postgres and Maria/MySQL initially).

    Fixed

    • Postgres: Would not format data types correctly on initial table load in some cases. #107
    • Excel: Was not filtering reserved words in sheet names. #659
  • v1.14.29

    Changed

    • Results: VSCode editor now used in JSON/XML datatypes, and can be opened on any field using the open in editor icon (replaces old open in editor). #107
    • Connection Pinning: Will now destroy a connection if keep alive statement fails. #578 #648

    Fixed

    • Trino: Uses line numbers in errors to reduce highlighting when present.
    • Export: Fixed issue with SQL Insert statement export. #655
    • Inspector: Show correct data types in the JSON view.
    • Inspector: Added proper editor to JSON and XML data types. #107
  • v1.14.28

    Changed

    • Results: Support for data formatting completed.
    • Inspector: Updated to use VSCode editor.

    Fixed

    • DB2: Fixed issue with SSL connections. #652
  • v1.14.26

    Changed

    • Results: Added support for data formatting (work in progress).
    • Results: Selecting a full row and pressing delete/backspace will now delete the row, rather than clear the contents (cmd/ctrl+delete/backspace will delete partially selected row).

    Fixed

    • Dragging a table to a new window did not load the data.
    • Greenplum: Fixed introspection issue. #651
    • Doris: Fixed introspection issue. #645
    • Results: Fixed issue with sorting other columns, when primary key sorting setting was enabled.
  • v1.14.25

    Fixed

    • Autocomplete: Fixed issue where it was not working for some databases. #643
    • Redshift: Removed JSON method from introspection. #644
  • v1.14.24

    Changed

    • Connection Pinning: Added support in notebooks, and for Postgres. #578
    • Redshift: Added support for external tables (Spectrum). #613

    Fixed

    • Postgres: Introspection does not get columns for partitioned tables (redundant).
    • Postgres: Don’t change schemas for non user based SQL execution. #507
    • Oracle: Fixed syntax error being displayed rather than driver error in certain cases.
  • v1.14.23

    Changed

    • Export/Share: Added support for tab delimiters in CSV export.

    Fixed

    • Improved introspection performance for large schemas (1000+ schemas)

Ready to try DBCode?

Install DBCode today and transform your database workflow in Visual Studio Code.