Improvements

• Updated the connection manager, it has become more convenient and easier to work with. Removed unnecessary buttons

• Updated the main form, removed pictures, added a description

• As always, code optimization to improve performance

• Disabled automatic adjustment of the column width in the grid. Control of the width adjustment and enabling the editing mode is performed either through the context menu or by pressing Ctrl + D

• Added the ability to change the size of the code prompter window when it is opened

• Fixed a bug due to which when changing the font size of the text, the line size in the code prompter does not change

• Optimized the styles of the SQL editor window

The main changes in the current version concern code optimization, performance improvement.

But besides that:

* Added a grid menu, allows you to save selected lines to files, generate insert, update, delete commands, etc.

* Updated icons

During the development of this version, the main attention was paid to the work of the SQL editor and that's what was done:

1. We rewrote the code hint (Code AutoCompletion), now it works strictly within the boundaries of the current SQL block. The separation of blocks inside the tooltip is performed according to the general rules for the editor, namely, the create commands are terminated with the / symbol, the rest ;

2. The code prompter now remembers the keys used to generate hints, saves the data to an array and extracts the data from memory the next time the key is entered. (currently working for PostgreSQL DBMS, the rest of the DBMS will be added in the next version)

Points 1 and 2 actually increase the performance of the code hint many times over!

3. Information about the column data type in the form of a code has been added to the grid in the column headers.

4. The data type is displayed in the grid in the column hint

5. Well, we tweaked the code to optimize the column width when uploading data to the grid.

Fixes for identified bugs in version 24.1

• Expanding the list of supported keys for a language pack

• The query editor for the MSSQL DBMS has been improved

• Changing the program operation logging system. Data is written to a file on disk and to memory structures without accessing the vlc components.

• Added program log rotation by date

• Extending the functionality of the Form Wizard to support the ability to create custom forms that integrate into various query editor menus (support for all query editor menus for PostgreSQL and MySQL DBMSs).

• Add: SQL editor update for MySQL DBMS

• Add: switching the MySQL editor to a single connection manager

• Add: language pack editor in table form. Allows you to quickly create translations.

• Update: Default style change

• Update: SQL editor engine performance has been improved

• Add: Removed the modal password entry window and moved it to the main form

• Add: Added the ability to change the font name in the query editor.

Identified bugs have been fixed

Query editor

• The query editor has been speeded up

• ctrl+s - save the current sheet to a file on disk (tmp directory)

• ctrl + mouse click - displays the code of an object (table, function, view) [PostgreSQL]

• new structures in memory for storing operating parameters to speed up work

• when you click the mouse in the editor window, information about the pointer position is displayed in the status bar

• fix: fixed a bug with de-highlighting selected text

CerebroSQL cluster

• * shared database configurator updated

• * password manager support

• Fix: Исправлена ошибка в функционале перетаскивания имени объекта из дерева в поле ввода SQL. Ошибка заключается в не корректном определении позиции в случаи если произошла прокрутка листа

• Fix: Изменен приоритет уровней для подсказчика кода, для случая если в БД есть схема с аналогичным названием, с БД на схему

• Add: Оптимизировано использование памяти подсказчиком кода, а так же повышена производительность его работы

• Add: Переписано хранилище паролей. Введено понятие пространства, поддержка работы в режиме с центральной базой

• Add: Переписана система хранения "шаблонов кода" для редактора запросов. Переход на концепцию пространств. Поддержка многоуровневого дерева

Add: Added the SQL$PG$AUTO_COMMIT parameter to enable/disable the autocommit mode for connecting a sheet of the query editor for PostgreSQL DBMS

Add: Added dragging the object name (with schema) from the object tree to the code entry field

Query Editor

Fix: Speed up work, increased responsiveness of the SQL input window by disabling some of the background processes that do not affect the work

Document storage

Complete rethinking of the module.

• Added concept of space - top-level grouping of documents.

• Each document opens in a new sheet

• When the program starts, all open documents of the last session are restored.

• Added the ability to put documents in "Favorites"

• Updated design

Bug: Fixed error "ERROR: near "err_text": syntax error " when viewing the history of executed queries in central database mode

Bug: fixed error when deleting an entry in the "Data transfer (lite)" tree - the entry is deleted, but the information in the tree is not displayed

Bug: added sorting by name of VIEW node records in the query editor for PostgreSQL DBMS

Bug: Fixed problem with program running in wine environment on Astra Linux OS

Add: MSSQL table code output switched to separate popup window

Add: unified code execution functions in the query editor (single execution process logging format)

Add: Added the cdwid parameter (id of the connection to the CDW database) in the CerebroSQL.ini parameter file. The parameter provides automatic connection to the central storage at the program start

Add: the output of the program operation log is highlighted in color

Add: Data transfer (lite) - logging format reduced to a single one (highlighting lines with color, output format)

Add: Data transfer (lite) - updated module interface

Add: Data transfer (lite) - added parameter to $DATE (date format in file name yyyymmddhhmiss) for case of data export to CSV file

Add: 2 new object classes have been added to the interface language editor (Error description - error message when executing the program, TreeView node - text of nodes in trees)

Add: accelerated program loading

Fix: fixed generation of select, insert code for PostgreSQL tables displaying deleted columns

Fix: Default language pack renamed to DEFAULT

Add: local database markup scripts have been moved to a separate meta-storage.

Add: Central database markup scripts (PostgreSQL) moved to a separate meta-storage.

Add: updated dashboard of the main program window [1]

Add: new program language editor (completely revised approach, coverage of modules will be gradual) [2]

Add: code review - optimization of algorithms

Add: accelerated program loading

Add: convert program to platform (beta operation mode)

• The functionality of the "Wizard for creating forms for MDM" has been expanded - it allows you to create both separate windows for the program (call from various menus of the main window and the query editor), and "applications" - groups of combined windows

• Data for custom window elements is retrieved from SQL databases by queries

Add: Added creation of the tnsnames.ora file when clicking the "Edit tnsmanes.ora" button in the connection editor if there is no directory file indicated by the path in the TNS_ADMIN field

Add: Switching the query editor for Oracle DBMS to a unified connection manager

Add: Updated appearance of the wizard for creating links to external programs

Fix: executable file compression up to 32M

Fix: Updated components

Update from 09/14/2022

Fix: Fixed error when selecting a directory in connection manager

Add: Added MDM form setup window

• Add: Refinement of the unified connection manager

• Add: Transition to a single connection manager of the data transfer manager (Data transfer: lite)

• Add: Transition to a single connection manager of the query editor for PostgreSQL DBMS

• Add: deep update of data transfer manager (data transfer: lite)

• Add: Code fixes and improvements revealed during the operation of version 22.1

• Bug: fixed error saving output of completed queries in local database

What's new:

• AWR: comparison of 2 previously generated reports

• SQL developer: Add - view statistics on the use of database functions

• SQL developer: Add - rman backup info

• RMAN: Add - configure backup options

• The window for selecting a connection for the monitoring kernel in the form of a structured tree

• Tablespace manager: Add - added current file size column

• Viewer ControlFile/PFile: Add - viewing all ControlFile and PFile generated by the program

• Settings: Add - added a parameter that controls the choice of the method of connecting to servers using Putty (by IP or by DNS name)

• Query history: Updated functional

• Bug: fixed a bug with displaying the text of a completed request in the current_history mode in the window for viewing the history of completed requests

----------------------------------------------------------------------------------------------------------

1. Changed table for storing history

2. Added control buttons: Add SQL to Developer, save to file, Copy clipboard, Add to Project manager

Transferring data from the history of completed requests is only possible in manual mode

Instructions

• Open Query Editor

• Create sheet for working with SQLite databases

• Press the button "Attach databases"

• Set the switch opposite the base "core"

• Press the "Attach" button

• Execute a request

Query editor: search connect - connection search window. It can be opened either by the Search button or by the Ctrl + Y key combination.

----------------------------------------------------------------------------------------------------------

SQL developer for PostgreSQL

• Rebuilt object tree

• COLUMN node - added a child node with a list of system columns

• TABLE node - added DEPEND child node, list of referenced base objects

• TABLE node - added CHECK child node, list of constraints-checks

• Dragging the table name from the tree into the SQL query input field - a select query is added to the input field to the selected table