Initial Release

Initial Release

This is an AI generated release news.
Have fun ;-)

SQL DATA LENS 3.20 Release – Elevate Your SQL Experience!

Welcome to the exhilarating new release of SQL DATA LENS 3.20! This version is packed with dynamic enhancements and powerful upgrades designed to streamline your SQL workflows, boost performance, and provide a richer user experience. Whether you’re connecting to new data sources or optimizing your queries, this release has something to thrill every SQL enthusiast.

---

What’s New?

Cutting-Edge Drivers & Library Enhancements

• 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

Performance & Usability Breakthroughs

• 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.

Feature Enhancements for Streamlined Workflows

• 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

SQL DATA LENS 3.20 is here to redefine your SQL analysis experience with advanced drivers, stellar performance upgrades, and smarter, user-centric features. Dive in and explore the enhanced functionalities that will empower you to analyze, troubleshoot, and visualize data like never before.

Thank you for being a valued user of SQL DATA LENS —your feedback and support drive our continuous innovation. Happy querying!

Add Developer Community article

Initial Release

Initial Release

1. Add on-demand task to export stats to file (in protocol line format)

• Memory usage optimisation

Tracing is off by default

bug fixes

[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)

Add Audience Restriction tag

Fixed expired license

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

Initial Release

Initial Release

Initial Release

bug fixes & improvements

Initial Release

Initial Release

Made error filtering more robust.

• added missing "Singapore" to default GeoJSON

[1.1.4] - 2025-01-23

Fixed

• Now compatible with IPM 0.9.x versions

improvements

Initial Release

• Error search added

New Namespace: The FEDERATION namespace is designed to facilitate the integration of data from multiple namespaces. IRIS does not support executing SQL statements that combine tables from different namespaces. To address this limitation, this federated namespace leverages the concept of creating foreign servers to include other namespaces. By defining foreign tables, it becomes possible to seamlessly combine tables across namespaces, allowing users to write SQL statements that unify data into a single query. This namespace is used to explore this feature, serves as a practical demonstration of this capability, showcasing how to explore and utilize it.

Initial Release

[2.9.0] - 2025-01-09

Added

• Menu option to export production to support migrating to production decomposition (#665)

Fixed

• Fixed errors on production page when item settings need to be XML escaped (#667)
• Fixed push button not appearing after commit (#654)
• Fixed merge conflict resolution on stash popping (#531)
• Improvements to the performance of the instance-wide uncommitted check (#674)
• Fix "Max $ZF String" error when committing lots of files (#617)

bug fixes & improvements