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 - know 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

Racket for Linux

8.13 freeware download

... Whether you're just starting out, want to know more about programming language applications or models, looking to expand your horizons, or ready to dive ...

Bugee

1.0 freeware download

... want to work with Bugee#@! you need to know several things. You need a http server with php scripting and MYSQL. Bugee#@! has a client ...

newLISP

10.7.5 freeware download

... casual, simple to learn without requiring you to know advanced computer science concepts. Like any good scripting language, newLISP is quick to get into ...

UniversalIndentGUI for Linux

1.2.0 Rev 1070 freeware download

... indenter for your programming language you even didn't know that it exists. FEATURES: · Directly ... for example the file "gc.cfg") · Not yet known indenters can be added by creating a ini ...

iBored for Mac

1.1.19 freeware download

... rendering the entire disk unusable. So you better know what you're doing, especially if you use any "write" operations. And keep backups of your data ...

Developer's Tips & Tricks

1.2.1.3 freeware download

Database for Code Snippets (Tips and Tricks) collecting to avoid the double working. Features: - Integrated editor with syntax highlight features (Supported languages: C#, C++, COBOL, ...

Reg2exe

2.25a freeware download

... readme file for more information. If you don't know what reg-files are, you should better not use ... to the windows regestry. If you don't know what Reg-files are, or what the windows registry ...

newLISP for Linux

10.7.5 freeware download

... casual, simple to learn without requiring you to know advanced computer science concepts. Like any good scripting language, newLISP is quick to get into ...

Racket for Mac

8.13 freeware download

... Whether you're just starting out, want to know more about programming language applications or models, looking to expand your horizons, or ready to dive ...

Android SDK for Mac and Linux

Release 35.0.1 freeware download

... a Linux kernel. If you want to know how to develop applications for Android, you're in the right place. This site provides a variety ...