Keep up with latest product news
New IRIS 20251. CORS support introduced
Simplified JSON output for Get requests
Security settings for CSPSystem to support CORS
Dynamic charts
Better management of notebook server
SQL DATA LENS now FREE for using with free databases like the IRIS Community Edition!
The licensing system has been completely revised to make it easier for users to enjoy the benefits of SQL Data Lens .
The former “Home Edition” has been replaced by a new Free Edition, with all previous restrictions —
such as localhost-only access or limits on the number of connections — completely removed.
The Free Edition now supports any database connections to the free, community, or developer editions.
For example: Intersystems IRIS Community Edition, Microsoft SQL Server Developer Edition – SQL Data Lens also provides free, persistent access to free database systems including DuckDB, PostgreSQL, Trino, H2, Apache Derby, and SQLite.
ENH : TableViewer : More details for Intersystems IRIS per Table in Grid available, e.g. LAST_COMPILED, OWNER
ENH : TableViewer : Refresh table view after tune table for entire namespace
ENH : TableViewer : The repeated calculation of the table size added up with each run, so that the value was only correct on the first run.
ENH : SQLite driver upgraded sqlite-jdbc-3.49.1.0.jar
ENH : MariaDB driver upgraded to mariadb-java-client-3.5.3.jar
ENH : MySQL driver removed
ENH : DuckDb upgraded to 1.2.2.0
FIXED: “Nullpointer: Name cannot be null!” happend while opening the SQL Editor on some connections
New an improved SQL scripting features. With just a click, it can generate comprehensive integrity checks for Tables, Views, and Stored Procedures—saving time and helping you stay ahead of hidden data quality issues.
ENH : Some small improvements, like Execute Toolbar button now with text
ENH : Testing connections are now limited to show only 5 namespaces to prevent the UI from getting to big
ENH : Many internal libs upgraded (like POI 5.3.1)
ENH : TableViewer : Table sources (DDL) is improved and handle IRIS default entries for AUTO_INCREMENT columns correctly
ENH : Data Pumper : New feature to copy data from one table to another table, also between different databases and namespaces
ENH : SQL Editor : Improved error handling for values that do not match metadata
ENH : General : A new toggle button on the main toolbar to configure handling for read errors globally