CerebroSQL: Version history

Admin · 2024-10-08T11:02:26.975Z

[EN] Version 24.4.2 • 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 Version 24.4 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 Version 24.3 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. Version 24.2 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). Version 24.1 • 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. Version 23.4 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 Version 23.3 • Fix: Исправлена ошибка в функционале перетаскивания имени объекта из дерева в поле ввода SQL. Ошибка заключается в не корректном определении позиции в случаи если произошла прокрутка листа • Fix: Изменен приоритет уровней для подсказчика кода, для случая если в БД есть схема с аналогичным названием, с БД на схему • Add: Оптимизировано использование памяти подсказчиком кода, а так же повышена производительность его работы • Add: Переписано хранилище паролей. Введено понятие пространства, поддержка работы в режиме с центральной базой • Add: Переписана система хранения "шаблонов кода" для редактора запросов. Переход на концепцию пространств. Поддержка многоуровневого дерева Version 23.2 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 Version 23.1 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 Version 22.4 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 Version 22.3 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 Version 22.2 • 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 Version 22.1 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