WHAT'S NEW IN CLEARSQL
Release History
Scroll down to see the highlights of each realease and discover how ClearSQL has changed over the time.
Download ClearSQL
Please fill out the form. The download will start automatically after submitting the contact information.
ClearSQL 9.2.1.136
January 15, 2020
Redesigned import wizard, fast display of diagrams, and new app notifications
Revamped Import Wizard
Double-click or drag&drop scripts to add them to your project, instantly sync files with their sources, and access advanced features from the context menu.
Faster retrieval of visual data
The optimized object tree population mechanism lets you view multiple diagrams and matrices faster than ever before. Works great on huge projects.
Catchy notifications
Get to know about new application updates or tech support messages from the tray notifications. You can view them any time later in your Windows 10 notification area.
Instant filters
Search for stored programs, diagrams, and violated code review rules using the text filters. Frequently entered filter criteria are stored for later reuse.
More in this release:

  • The Pseudocode Wizard now shows only scripts with pseudocode comments.
  • Removed the ability to turn on/off the generation of pseudocode comments. Pseudocode is now
    always generated by default.
  • Added the ability to open the target folder from the notification shown after export is completed.
ClearSQL 9.1.1.133
November 26, 2019
Project navigation, revamped import & export wizards, support for Record Groups
Navigate around the project
Use the browser-like back and forward buttons to move around your project and instantly jump to the necessary tab or script from the history list.
Import & export with ease
Import and export scripts or even whole projects with the dramatically redesigned wizards. Use familiar quick filters to find the project items you need.
Analyze code even faster
Achieve the highest code analysis speed by switching off the code duplication search and code generation in just one move.
Support for Record Groups
Take a granular control over the Oracle Forms. Import Record Groups along with Blocks, Canvases, Program Units, and Triggers.
More in this release:

  • Optimized the speed of CRUD matrix generation and added the ability to navigate to CRUD matrices directly from Call Trees.
  • Now the quick filter displays the list of recently used filter conditions.
  • Added the ability to locate any variable, parameter, a local subprogram, local type, a subprogram of another package, and dataset on Ctrl+Click.
See release notes for version 9.1 ↓
ClearSQL 9.0.1.118
October 1, 2019
New UI, dark mode, and global search
Instant Analysis
Skip the project creation step and run analysis immediately after you start the app. Just upload your scripts from the disk and wait until the analysis completes.
Global Search
Use the advanced search engine to look for project elements and application settings. A double-click lets you instantly jump to the found item.
UI Themes & Dark Mode
Try new themes to change how the UI elements appear in ClearSQL. Switch to the dark mode right from the startup screen for a more contrasting look.
Project tree filter
Enter some text or click on the vivid script status icons to quickly filter out the least important project items and focus on what really matters.
More in this release:

  • Totally reorganized the menus and toolbars all over the application to give you quick access to the most frequently used features.
  • Applied new toolbar icons, stylish and colorful.
  • Added alternating colors to the datagrids to improve your visual experience while working with figures.
  • The Microsoft Visual C++ Redistributable Package 2019 and Oracle Client are now installed automatically, which significantly accelerates the database connection procedure.
ClearSQL 8.1.1.224
April 3, 2019
Column-level CRUD, advanced UI customization, and improved Code Insight
CRUD Matrices
Discover how data is manipulated at the object and column level. In-place call trees show the data flow between subroutines and tables, helping identify potentially problematic areas.
Code autocompletion
Added parameter and variable datatypes to the suggestions list and improved the usability of the Code Insight window. Writing XPath expressions has become more convenient, too.
Export & import of DB connections
Save your database configurations to an XML file and easily restore them in the new installations or share within the team. Sensitive data are safely encrypted.
UI customization
Use options on the View menu to hide irrelevant tabs from the main window. Set up several project and script views and switch between them using workspaces.
More in this release:

  • Added the ability to select Oracle Home from the drop-down list in the Database Connection window.
  • The Conquest application installer now checks for the installation of Oracle Client and other
    prerequisites for a successful database connection.
  • Updated the layout of the Connection Settings window.
See release notes for version 8.1 ↓
ClearSQL 8.0.1
November 12, 2018
$10 subscription, duplicate code detection, and technical debt
Subscription license
Get 100.000 lines for analysis for just $10 per month. Every 10.000 lines more add only $1 to the total bill.
Duplicate code
Reduce undesired workload and maintenance costs by removing duplicate code from your project.
Technical debt metrics
Count the price of poor coding decisions and drive down maintenance costs with the technical debt metrics.
Code Quality Trend
Set a code quality threshold. Works great for large teams and boosts the performance of the juniors.
More in this release:

  • The service Annual Maintenance & Support is no longer automatically renewed for another period. Now it will get expired in a year but can be extended for another period upon request.
  • New startup window.
  • Added the ability to search for files and objects in the file system and database.
  • Optimized work of SQL*Plus.
Helpful?