• default to fast estimate for TableSize() query
• skip tables that are mere projections of collections and not classes of their own

[2.10.0] - 2025-02-10

Added

• LoadProductionsFromDirectory method to help custom deployment scripts load decomposed productions from the repository (#670)
• Added ability to reset head / revert most recent commit (#586)
• Changes deployed through Git are now logged in a new table SourceControl_Git.DeploymentLog

Fixed

• Fixed not showing warnings on Studio (#660)
• Fixed business processes and rules not being added to source control automatically (#676)
• Embedded Git commits settings when cloning empty repo to avert any issues
• Fixed Import All options not importing the Embedded Git configuration file
• That configuration file now imports before everything else (#697)
• Improved performance of IDE editing and baselining of decomposed productions
• Fixed Discard / Stash not working on deletes (#688)
• Fixed errors deploying decomposed production changes on Windows network drives (#696)
• Improved performance of deploying changes to decomposed production items (#690)
• Fixed errors saving decomposed productions when invalid items in item cache (#701)
• Removed unnecessary Add and Remove menu items from decomposed productions (#701)

SQL DATA LENS 3.20 Release – Elevate Your SQL Experience!

What’s New?

• InterSystems IRIS Integration:
  • New Driver 3.10.2

    from InterSystems IRIS 2024.x

  • New Driver 3.9.0

    from InterSystems IRIS 2024.2 Expand your connectivity with these advanced drivers, ensuring smoother integration with your enterprise databases.

• Upgraded Internal Libraries:

  Enjoy improved performance and reliability with a comprehensive upgrade of many internal libraries and our SQL Formatter.

• Enhanced Database Drivers:
  • MariaDB:

    Upgraded to mariadb-java-client-3.4.1.jar

  • H2:

    Now running on h2-2.3.232.jar

  • PostgreSQL:

    Enhanced with postgresql-42.7.4.jar

  • Access:

    Updated to ucanaccess-5.0.1

  • Firebird:

    Now powered by jaybird-5.0.5.java11

  • SQLite:

    Boosted with sqlite-jdbc-3.46.1.0_win64

  • Trino:

    Improved with trino-jdbc-468

  • MS SQL Server:

    Upgraded to mssql-jdbc-12.8.1

  • DuckDB:

    Now at version 1.1.3

• Java Runtime Environment Upgrade:

  We’ve leaped from Java 11.0.14 to the state-of-the-art

  Java 21.0.3

  . Enjoy:

  • Near-zero pause times and enhanced thread scalability
  • Lightweight concurrency with a low memory footprint
  • SIMD parallelism for data-heavy tasks
  • Faster execution, reduced warm-up times, and lower memory usage These performance improvements translate into a snappier, more resource-efficient application experience.
• New Runtime Environment Info Dialog:

  Quickly access and copy runtime environment details with our sleek new info dialog.

• Drag & Drop File Analysis:

  Simply drag and drop CSV, Parquet, or JSON files into DuckDB. Watch as SQL DATA LENS automatically generates DESCRIBE & SUMMARIZE statements, expediting your file analysis process.

• Improved Stored Procedures:

  Generation of CALL scripts is now more intuitive and robust.

• Revamped SQL Editor:
  • Smart Cell Analysis:

    The result set reading now stops at the first faulty cell, while still capturing detailed row, column, and error value information for easier troubleshooting.

  • Toolbar-Driven Configurations:

    Access settings for result display (text/grid), new tab outputs, and execution plans directly from the toolbar. Plus, enjoy an improved layout for text results that makes your data insights crystal clear.

• Enhanced DB Diagrams:

  The diagram feature now processes VIEWs and can display system objects when selected, giving you a comprehensive visual representation of your database structure.

Bug Fixes & Stability Improvements

• Server Navigator:

  Sorting issues have been resolved to ensure a smooth navigation experience.

• SQL Editor Execution Plan:

  The execution plan display is restored and fully operational.

• TableViewer:

  Fixed a null pointer exception when viewing linked FOREIGN TABLEs.

• Session Restoration:

  Resolved an issue where SQL Editor settings were not restored after restarting SQL DATA LENS.

• XML Library Update:

  Removal of an outdated XML library introduces a breaking change for DB diagrams, paving the way for a cleaner, more efficient system.

Get Ready to Transform Your SQL Workflow