SQL Data Lens 3.23 freeware

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 2158
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
(56 rating)
SQL Data LensOtherWindows
SQL Data Lens - all Freeware Download Notice

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.

SQL Data Lens freeware - The Latest User Reviews
SQL Data Lens freeware - The Latest Versions History
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

Most popular Other freeware downloads

Pandoc

3.7.0.2 freeware download

Pandoc, developed by John MacFarlane, is a highly versatile document conversion tool that stands as a cornerstone for writers, academics, and developers alike. With its inception ...

FOX Toolkit

1.7.83 freeware download

... including header files), applications work virtually identically on all these platforms. FOX stands for Free Objects ... of the underlying concepts; but only FOX brings all these together in one integrated system. Some ...

AllDllDeps

2.1.4 freeware download

All Dlls Dependencies is a static analyzer for Dlls dependencies.It is a clone of Depends supporting Windows 7 and Windows 10 stub dlls. Like Dependency ...

Qt Creator for Linux

13.0.1 freeware download

... or create one from scratch, Qt Creator generates all the necessary files. Support for cross-qmake and CMake is included. Desktop & Mobile Targets Qt ...

PeStudio

9.58 freeware download

... potential security risk for your customer's infrastructure? All these questions, and many more, can be answered ... PeStudio shows you much more details, like: · all libraries that are used by an application. · ...

Qt Creator

17.0.0 freeware download

... or create one from scratch, Qt Creator generates all the necessary files. Support for cross-qmake and CMake is included. Desktop & Mobile Targets Qt ...

Qt Creator for Mac OS X

13.0.1 freeware download

... or create one from scratch, Qt Creator generates all the necessary files. Support for cross-qmake and CMake is included. Desktop & Mobile Targets Qt ...

FurMark

1.16.0 freeware download

... or Linux, Multipass ensures a consistent experience across all major operating systems. This flexibility is further enhanced by its integration with cloud-init, allowing users to ...

New Version

Portable SmartGit

24.1.4 freeware download

... Git Support:** Portable SmartGit offers extensive support for all Git operations, including cloning, committing, merging, and branching. The software also supports other version control systems ...

New Version

SmartGit

24.1.4 freeware download

... Features** 1. **Comprehensive Git Support**: SmartGit supports all major Git operations, including commit, merge, rebase, and ... support for SmartGit users. The comprehensive documentation covers all aspects of the tool, from basic operations to ...

New Version