Navigation:
SQL Data Lens 3.23 freeware
New
Version
SQL Data Lens is the all-in-one tool designed for InterSystems IRIS. It combines many tools with a smart sql editor to provide easy access to the database for IRIS developers, administrators and data analysts. Try it and use it for free! ...
| Author | SQL Data Lens |
| Released | 2025-05-04 |
| Filesize | 20.63 MB |
| Downloads | 2131 |
| OS | Windows |
| Installation | Install and Uninstall |
| Keywords | sql, editor, database, intersystems, iris, query, tool, tuning, execution plan, ms sql server, PostgreSQL, MySQL, Access, Firebird |
| Users' rating (54 rating) |
SQL Data Lens Free Download - we do not host any SQL Data Lens torrent files or links of SQL Data Lens on rapidshare.com, depositfiles.com, megaupload.com etc. All SQL Data Lens download links are direct SQL Data Lens download from publisher site or their selected mirrors.
| 3.23 | May 4, 2025 | Major release | V 3.23 (04.05.2025) - ENH : 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, ALLOW_DROP - 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 V 3.22 (23.04.2025) - ENH : SQL Editor : More SQL scripting features added like "SELECT with numeric check" and "SELECT with length check" V 3.21 (21.04.2025) - 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 lib |
| 3.22 | Apr 23, 2025 | Major release | V 3.22 (23.04.2025) - ENH : SQL Editor : More SQL scripting features added like "SELECT with numeric check" and "SELECT with length check" V 3.21 (21.04.2025) - 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 corretly - 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 readerrors globaly V 3.20 (23.02.2025) - ENH : New Driver 3.10.2 from InterSystems IRIS 2024.x added - ENH : New Driver 3.9.0 from InterSystems IRIS 2024.2 added - ENH : Many internal libs upgraded - ENH : SQL Formatter upgraded - ENH : MariaDB driver upgraded to mariadb-java-client-3.4.1.jar - ENH : H2 driver upgraded to h2-2.3.232.jar - ENH : PostgreSQL driver upgraded to postgresql-42.7.4.jar - ENH : Access driver upgraded to ucanaccess-5.0.1 - ENH : Firebird driver upgraded to jaybird-5.0.5.java11 - ENH : SqlLite driver upgraded to sqlite-jdbc-3.46.1.0_win64 - ENH : Trino driver upgraded to trino-jdbc-468 - ENH : MS SQL Server driver upgraded to mssql-jdbc-12.8.1 - ENH : DuckDb upgraded to 1.1.3 - ENH : New info dialog with copy action about runtime environment - ENH : Drag and drop the csvparquetjson fil |
| 3.20 | Feb 23, 2025 | Major release | V 3.20 (23.02.2025) - ENH : New Driver 3.10.2 from InterSystems IRIS 2024.x added - ENH : New Driver 3.9.0 from InterSystems IRIS 2024.2 added - ENH : Many internal libs upgraded - ENH : SQL Formatter upgraded - ENH : MariaDB driver upgraded to mariadb-java-client-3.4.1.jar - ENH : H2 driver upgraded to h2-2.3.232.jar - ENH : PostgreSQL driver upgraded to postgresql-42.7.4.jar - ENH : Access driver upgraded to ucanaccess-5.0.1 - ENH : Firebird driver upgraded to jaybird-5.0.5.java11 - ENH : SqlLite driver upgraded to sqlite-jdbc-3.46.1.0_win64 - ENH : Trino driver upgraded to trino-jdbc-468 - ENH : MS SQL Server driver upgraded to mssql-jdbc-12.8.1 - ENH : DuckDb upgraded to 1.1.3 - ENH : New info dialog with copy action about runtime environment - ENH : Drag and drop the csvparquetjson files to DuckDB generate now DESCRIBE and SUMMARIZE statements for faster file analyzing - ENH : Runtime environment upgraded from 11.0.14 to = 21.0.3 Summary of Key Performance-Related Improvements in Java Runtime 21 Near-zero pause times, improved scalability, Lightweight concurrency with low memory footprint, SIMD parallelism for data-heavy tasks, Efficient native function calls and memory handling, Faster execution, reduced warm-up times, Lower memory usage for string-heavy applications Faster startup and reduced memory usage In sum, Java 21’s performance improvements primarily focus on lowering GC pause times, enhancing thread scalability, and optimizing CPU and memory efficiency, all of which lead to faster, more resource-efficient applications across a broad range of workloads. - ENH : StoredProcedures: Generation of CALL scripts improved - ENH : SQL Editor |
