SQL Data Lens 3.23 freeware

New Version

SQL Data Lens is the all-in-one tool designed for InterSystems ... 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 2133
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 LensOtherWindows
SQL Data Lens - free data 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

SQL Data Lens

3.23 freeware download

SQL Data Lens is a development tool designed for InterSystems database. It supports developers with a advanced SQL Query Editor.In SQL Data Lens Server Navigator you see all available Namespaces ...

New Version

Mercurial for Mac

7.0.2 freeware download

... also ensures that the system is resilient to data loss. The system's performance is further enhanced by its use of a highly efficient binary patching ...

New Version

DTM ODBC SQL runner

2011 freeware download

DTM SQL runner is a free command line tool for SQL statements execution. The runner allows the user to specify ODBC data source name and file with SQL statement to ...

Git

2.45.2 freeware download

Git is a free & open source, distributed version control system designed ... user name and e-mail address, thus protecting your data and securing it from unauthorized users. Now that ...

Cppcheck

2.16.0 freeware download

... sophisticated algorithms that intelligently assess code paths and data flow, ensuring that only genuine issues are flagged. The tool's configurability allows users to tailor the ...

HxD

2.5.0.0 freeware download

... contrast to a sector/region-limited view that cuts off data which potentially belongs together. Drives and memory can ... main memory o Memory sections are tagged with data-folds * Disk-Editor (Hard disks, floppy disks, ZIP-disks, USB ...

XVI32

2.54 freeware download

XVI32 is a freeware hex editor running under Windows 95, Windows 98, ... note the highlighted advantages of XVI32. * data inspector to view decoded numbers (see screen shot; ...

Jailer

16.5.4 freeware download

"Jailer" is a sophisticated data management tool meticulously crafted by Ralf Wisser, designed to streamline and enhance the process of database subsetting and data extraction. This open-source software stands ...

PyQt4

6.8.0 freeware download

... advanced functionalities like multimedia handling, network communication, and database integration. PyQt also supports Qt's powerful signal and ... makes it a powerful tool for scientific and data-driven applications. The ability to combine PyQt's GUI capabilities ...

Portable D-Fend Reloaded

1.4.4 freeware download

... no need to worry about memory managers or free conventional RAM, but the setup of DOSBox is ... DOS games (D-Fend Reloaded GUI, DOSBox, language files, FreeDos commandline tools). During the first start of D-Fend ...