Changelog

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

  • v1.17.33

    Changed

    • Oracle: Added preliminary support for packages in database explorer.

    Fixed

    • Explorer: Fixed sequence/identity column default values being truncated in database tree (missing closing bracket after type cast). #807
    • SQLite: Fixed introspection error when database contains orphaned views (views referencing dropped tables). #819
    • MySQL/MariaDB: Fixed backup and restore failing over SSH tunnels by forcing TCP protocol to prevent socket connection attempts. #808
    • PostgreSQL: Fixed SSL connection failures with servers using ECDSA P-521 certificates (secp521r1) by appending missing signature algorithm to BoringSSL defaults. #777
    • Snowflake: Added debug logging to help diagnose connection issues. #814
  • v1.17.32

    Changed

    • Notebooks: Added Python cell support with Jupyter kernel integration and SQL-to-Python result injection using @var annotations. #621
    • Team Seats: Added role management with Owner, Admin, and Member roles for team subscriptions. Admins can manage seats while only owners can change roles.

    Fixed

    • Activation: Fixed web and email activation causing account section to not display license details. #810
    • ClickHouse: Fixed connection failure when connecting to servers with readonly mode enforced at credential/server level. #817
  • v1.17.31

    Changed

    • Transaction Control: Manual transaction management with auto-commit toggle, commit/rollback actions, and uncommitted change tracking for supported databases. #368
    • CSV/Excel/Parquet/Avro: Now supports opening a folder of files and loading all files as tables in a single connection.
    • ERD: Added multi-table selection support #812

    Fixed

    • PostgreSQL: Fixed backup failing on macOS due to pgAdmin 4.app extraction errors in the PostgreSQL tools package.
    • SQLite: Fixed sqlean extension not loading due to incorrect required check and filename handling.
    • Connection Tree: Fixed tables starting with underscore not appearing in tree view.
    • PostgreSQL: Fixed DDL scripting for external tables (FDW). #806
    • Language Server: Fixed incorrect suggestions for CTEs in autocomplete. #204
    • Zero Config: Fixed postgres:// protocol not being recognized in .env files for PostgreSQL connection discovery. #813
  • v1.17.30

    Changed

    • Table Tabs: Added customizable tab title setting dbcode.tabTitle.format format with template variables for tables and views. #579
    • SQL Formatting: Added support for .sql-formatter.json configuration files in workspace folders
    • SQL Formatting: Added tabulateAlias option to align AS keywords in column lists for improved readability. #103
    • Settings: Added Formatting section to specify default formatting configuration.

    Fixed

    • SQL Parser: Fixed comments after semicolons being treated as separate statements causing execution errors.
    • SQL Server: Fixed semicolons now treated as statement boundaries alongside GO delimiters. #802
  • v1.17.29

    Changed

    • Scratch Files: Added “none” rotation option for persistent scratch files without timestamp.
    • Language Server: Added Clickhouse support. #795
    • PostgreSQL: Added support for external tables (FDW). #800
    • Filters: Can now be edited/deleted from the explorer, and maintain sync with the results grid.

    Fixed

    • Export: Fixed grid data not visible in webpage/notebook exports. #799
    • Filters: Fixed filters duplicating when saved and not updating across panels and notebooks. #790
    • Hover: Fixed table column preview formatting with improved layout, smart column hiding, and better alignment. #797
    • PostgreSQL: PostGIS geometry columns now display as readable EWKT format instead of raw hex in result grids.
    • Language Server: Fixed case-insensitive column name matching in both editor and grid WHERE filters. #792 #773
    • Language Server: Fixed partial keyword matching in autocomplete suggestions. #792
  • v1.17.27

    Fixed

    • ClickHouse: Fixed infinity and NaN values displaying as null in query results. #794
    • Language Server: Fixed diagnostics incorrectly showing for unsupported dialects like ClickHouse. #795
    • Editor: Fixed “No SQL to execute” error when executing queries in files without assigned connections. #798
    • Results: Fixed initial loading performance. #789
    • PostgreSQL: Fixed table row counts showing stale data by using pg_stat_all_tables when available. #791
  • v1.17.26

    Fixed

    • Results: Fixed tooltip sizing and formatting for JSON content.
    • Results: Fixed json cell editor saving JSON with whitespace instead of condensed format.
    • SQLite: Fixed attached databases showing main database’s tables instead of their own tables. #784
    • Filters: Fixed WHERE clause filters not including schema qualification, causing “table not found” errors. #787
    • Connection: Fixed USE statement not triggering database context switch after parser update.
  • v1.17.25

    Changed

    • Language Server: Included SQLite support.
    • Connections: Added file-based post-connection SQL support. #784

    Fixed

    • ERD: Fixed incorrect cardinality display for junction tables with composite primary keys. #785
    • SQLite: Fixed ATTACH DATABASE and DETACH DATABASE statements not being recognized to refresh the explorer. #784
    • SQLite: Fixed introspection error when database has read-only file permissions. #783
  • v1.17.24

    Changed

    • Language Server: Included MySQL and Trino support.
    • Filters: Table filters that are saved can now be loaded directly from the explorer.

    Fixed

    • ClickHouse: Fixed CREATE FUNCTION statement boundary parsing. #781
    • Results: Fixed JSON columns being double-stringified when opening grid selections in editor with JSON format.
    • Results: Fixed cell editor treating formatting-only changes as data modifications for JSON and XML content.
    • Notebooks: Fixed result grid disappearing when clicking refresh or save dropdown menus. #780
  • v1.17.23

    Changed

    • Results: Added ability to save filters and re use on tables.
    • Language Server: Added PL/SQL and T-SQL dialect support to the experimental language server for autocomplete and syntax validation.

    Fixed

    • Monaco Editor: Fixed theme initialization crash when VS Code themes contain non-string color values.
    • Language Server: Disable diagnostics for unsupported dialects to prevent false positives. #772
    • Themes: Adjusted some colors from the VSCode theme css provided. #776
  • v1.17.18

    Changed

    • Results: Added SQL based where filter to results. #745
    • Files: Added custom editor support for data and database files (CSV, XLSX, Parquet, Avro, SQLite, DuckDB) - users can now use “Open With…” to open files in DBCode. #764

    Fixed

    • Autocomplete: No longer suggests items immediately after typing a comma - now requires at least one character to be typed for context-aware suggestions. #765
    • Editor: Fixed DECLARE block parsing. #772
  • v1.17.17

    Changed

    • Editor: Opening SQL now reuses existing untitled files for the same connection instead of creating multiple tabs.
    • Editor: Added scratch files for persistent SQL files organized by connection with configurable rotation (hourly/daily/weekly/monthly) and automatic cleanup.
    • Editor: Reworked statement boundary parsing to better handle functions, procedures, and other complex SQL constructs. #768 #767
    • Connection Roles: Added new statement types for transactions, maintenance, grant/revoke, set/use.
    • Explorer: Added table search to right click context menu in explorer, supports multiple table selection.
    • Oracle: Added “Include Oracle Maintained Schemas” option to show system schemas (SYS, SYSTEM, etc.). #769
    • Redis: Added support for executing statements in the editor.
    • Results: Added “Open” to context menu to open data directly in editor. #630

    Fixed

    • Parameters: Fixed parameter detection incorrectly interpreting string concatenation operator (||) as parameter definitions. #770
    • Redis: Follows pagination correctly when loading keyspaces.
    • Results: CSV and Excel exports now respect the grid’s column order, including user-reordered columns.
    • Table Editing: Not correctly handling tables with columns already set to null.
  • v1.17.16

    Changed

    • Snowflake: Added support for dynamic tables, hybrid tables, transient tables, external tables and materialized views. #113

    Fixed

    • All databases: Added more sql keywords to the escape list. #763
    • MySQL: Fixed timestamp values in SQL INSERT exports including timezone suffix that MySQL doesn’t accept. #761
    • Oracle: Fixed schema detection failing when connecting with system accounts (SYSTEM, SYS, etc.). #760
    • SQLite/D1: Fixed introspection error when database metadata references non-existent tables. #667
    • Snowflake: Warehouse and Security Role now fetch from the server. #762
  • v1.17.15

    Changed

    • MongoDB: Added authentication database (authSource) option to connection settings. #752

    Fixed

    • RisingWave: Fixed connection errors with RisingWave versions below 2.0 due to missing information_schema support. #753
    • Results: Expansion now handles more complex nested data, along with correctly displaying row numbers and background stripes. #710
    • Bigquery: Fixed JSON data types being quoted. #710
  • v1.17.13

    Changed

    • ERD: Can now choose to display multiple schemas in the diagram. #744
    • Import: You can now create a new table when importing. #529
    • Import: Now supports importing from parquet and avro files.

    Fixed

    • ERD: Filtering to start a specific table was not showing tables that did not contain that table’s name.

Ready to try DBCode?

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