Tag: redexpert

RED EXPERT 2024.11 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of Red Expert 2024.11 is available.

Added:

  1. Database backup / restore tool.

Improved:

  1. Connection parameters configuration panel.
  2. Exporting database statistics to a file.
  3. Database creation panel.
  4. Password input field.

Fixed:

  1. Executing EXECUTE BLOCK queries with parameters.
  2. Executing SQL-queries starting with a comment.
  3. Running application after upgrading from versions older than 2024.07.
  4. Errors when creating a new connection.
  5. Errors in the log when connecting to the database via SSH tunnel.
  6. Errors in the log when opening or closing Query Editor tabs.
  7. Errors in the log when displaying dependencies in the ER-diagram editor.
  8. Closing dialogs with a question.
  9. Updating application color scheme when switching from dark theme to light one.
  10. Applying line numbers properties in the Query Editor.
  11. Applying toolbar properties in the Query Editor.
  12. Applying SSH tunnel properties for connection.
  13. Applying authentication properties for connection.
  14. Generating INSERT and UPDATE scripts for tables and views.
  15. Modifying stored procedure code when creating or altering it.
  16. Adding constraints on table when connecting to the Firebird database.

Download and install the new version.

RED EXPERT 2024.09 HAS BEEN RELEASED

One comment

You can join to the Telegram chat for discussion.

New version of Red Expert 2024.09 is available.

Added:

  1. fbclient libraries for RDB 3, 4 and 5 version
  2. Notification when records count limit is enabled
  3. Check for valid exported file path before export table data
  4. Ability to delete data from the monitoring tables (MON$…)
  5. Indicators of the connected databases in the select connection fields
  6. Comment tabs for “Edit Job” and “Edit Tablespace” panels
  7. Ability to hide helper tools in the “Edit Procedure” and “Edit Function” panels
  8. Displaying Result Set table row numbers by default
  9. Tooltips for the table columns in the DB statistics panel
  10. Clearing selected tables if the “Only select tables” check disabled in the DB statistics panel

Improved:

  1. ER-diagram editor toolbar
  2. “Test Data Generator” tool
  3. “Import connections from DB” tool
  4. “Add table” dialog in the ERD Editor
  5. “Add relationship” dialog in the ERD Editor
  6. “Remove relationship” dialog in the ERD Editor
  7. Exception message formatting in the error dialog
  8. Update databases list for JDBC drivers
  9. Update Jaybird drivers to 4.0.30 and 5.0.18
  10. Update Java Native Access and Java Native Access Platform package versions
  11. Remove showing “setting applied” message when there are no preferences changed
  12. Set Monospaced font for the “Trace Manager” SQL panel
  13. Set PRIMARY tablespace as default instead of NONE when creating table

Fixed:

  1. ER-diagram generation
  2. Loading ER-diagram from the file
  3. Primary key generation for ER-diagram
  4. Editing table constraints in the ER-diagram editor
  5. Saving visible columns in the “Trace Manager” tool
  6. Editing JOB type displaying
  7. Result Set table cell rendering
  8. Enabling toolbar for table constraints
  9. Freezing when displaying the autocomplete popup
  10. Connections tree updating
  11. Popup actions for the VIEW columns into the connections tree
  12. NPE when open “Edit Function” panel
  13. Executing SQL scripts with parameters
  14. Executing SQL scripts without “SET TERM” statement
  15. OO API tools enabling in the “Test Data Generator” panel
  16. Default TRIGGER name generation when create new one
  17. Generating SQL drop query for UDFs
  18. Generating SQL script for PROCEDUREs and FUNCTIONs
  19. Generating SQL script for JOBs and TABLESPACEs with comment
  20. Generating SQL script for PACKAGEs without body
  21. Generating SQL script for TRIGGERs on the Firebird with version less than 3
  22. Generating SQL script for existing FUNCTIONs with the deterministic return type
  23. Generating SQL script for table constraints during comparing
  24. Loading information for TABLEs, INDEXes and FUNCTIONs during DB comparing
  25. Loading information for JOBs while editing them
  26. Starting DB compare with version less than 3
  27. Saving SQL script after DB comparing with the user changes
  28. Generating SQL stubs for PROCEDUREs during DB comparing
  29. Generating titles for new “System Console” tool instances
  30. Saving Query Editor instances history
  31. Data view dialog opening for the first time

Download and install the new version.

RED EXPERT 2024.07 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of Red Expert 2024.07 is available.

Improved:

  1. Application interface
    • Default themes (light and dark)
    • Application toolbar
    • Application menu
    • Query Editor toolbar
    • Query Editor popup menu
    • Connections tree
    • Settings menu
    • About panel
    • Procedures, Functions and Jobs editing panel
    • Changelog panel (release notes panel)
    • Drivers panel
    • Feedback panel
  2. ER-diagram tools
    • Color differentiation of tables in the ERD editor
    • Reverse engineering
    • Text blocks with ability to set background color
    • Undo/Redo operation
    • Added display of unique fields status (UQ)
    • Display table and field comments
    • Deleting tables can now be done with DELETE key 
    • Ability to stretch the size of tables with the mouse
    • Ability to switch between color and B&W lines 
    • Ability to select several tables and move them at the same time
    • Fixed scrolling by mouse wheel (SHIFT + wheel scrolling = horizontal scrolling)
    • Sorting by tables relationships
    • Ability to select the type of lines
  3. The execute button in the query editor can now:
    • Execute only the selected script
    • Execute everything if nothing is selected

Added:

  1. Ability to display column folders, constraints, indexes and triggers for tables in the connections tree
  2. Panel with basic information about connections
  3. Ability to create a bug report when an error occurs
  4. Ability to customize the Query Editor toolbar

Fixed:

  1. Switching between “Database Statistics” tabs
  2. Component layout on the column type selection panel
  3. Displaying domain fields

Removed:

  1. “Scratch pad” tool
  2. “Compare Data Types” tool
  3. “Execute Stored Objects” tool
  4. Ability to add custom SQL keywords

Download and install the new version.

REDEXPERT 2024.01 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of RedExpert 2024.01 is available.

Added:

  • Support of work with database statistics:
    • Obtaining database statistics via services
    • Parsing DB statistics from a file
    • DB statistics comparing
  • Data import support from XLSX and XML files
  • Export/import of data with BLOB type
  • Ability to select columns when exporting data
  • Ability to transfer data from one database to another
  • Database metadata extracting into SQL-script
  • SQL-queries executing to a file directly
  • Transaction parameters support in the Query Editor
  • Query execution in several connections simultaneously
  • Transaction confirmation window when closing the Query Editor and the “Data” tab of tables and views
  • Displaying connection and database properties (such as server, page size, database file size, etc.)
  • Ability to copy column names from a Result Set
  • “Triggers” tab for views
  • Ability to configure database connection timeout
  • Updated data import and export panels

Fixed:

  • Display tables with “NONE” encoding
  • Recognizing VARCHAR and CHAR types other than undefined subtype and with fixed binary data
  • Reloading of views after making changes
  • Auto-completion: by occurrence, not by string start
  • UDF opening errors
  • Editing foreign keys
  • Copying connection with encoding
  • Editing data in columns with names containing spaces
  • Disappearance of the edited procedure text on the “DDL” tab when switching tabs
  • Searching for database objects in the connection tree with names containing ‘$’
  • GUI defects when double-clicking on a table name in the Query Editor
  • Limitations on the number of characters and maximum value when editing field value with INT128 type
  • SQL code generation for external UDR functions, indexes and constraints
  • Table Validation with a large number of fields and indexes
  • Profiler buttons availability when switching between application tabs
  • Display PUBLIC role in the “Users” group in the Grant Manager
  • Focus shift when changing a filter field in the Grant Manager
  • Updating the list of triggers for tables and views when adding a new trigger
  • Updating the list of table fields when they are changed

Download and install the new version.

RedExpert 2023.10.1 has been released

Leave a comment

You can join to the Telegram chat for discussion.

New version of RedExpert 2023.10.1 is available.

Added:

  1. “Properties” tab on the database table editing panel.
  2. Configuring SQL templates from the Menu -> Tools.
  3. Checkbox “Automatic text wrapping” in the text browser of data with the BLOB type.
  4. Ability to specify a relative path to the log file in the settings.
  5. View blobs of PDF type.
  6. Autocomplete when editing table triggers for <new.> and <old.>.
  7. Ability to change column position.
  8. Ability to (not)check changes in column positions during DB comparison.
  9. Changing a cursor in the Query Editor while holding down the CTRL button when hovering over an object that can be opened.
  10. Restart the application only after saving several settings
  11. Target and source database exchange button on the comparison panel.

Fixed:

  1. ODBC driver support has been terminated.
  2. Recreation a role when adding a comment  for it.
  3. Errors of editing table foreign keys.
  4. Inability to add a comment to the index through the editing window.
  5. Adding extra versions of Red Expert to the list of Windows applications when installing a new version of the application over the old one.
  6. Action taken when clicking the Select Displayed Dataset Columns button when the Results Pane is closed.
  7. Selecting  table rows to be deleted after closing the “Data” tab and canceling the deletion.
  8. An error when the “Close all tabs” button did not close all tabs.
  9. Incorrect error handling during update.
  10. Syntax highlighting for multi-line identifiers.
  11. Application crash if user settings are broken.
  12. DDL generation for ARRAY, NUMERIC and DECIMAL columns.
  13. Improved autocomplete support for Firebird aliases and keywords.
  14. Working with tables with name length more than31
  15. Updated links for automatic Java downloads.
  16. Unreasonable memory consumption.
  17. Incorrect display of the red_expert.ico file.
  18. Functioning of such application settings as:
    1. highlighting the current line;
    2. number of saved log files;
    3. selected text color;
    4. alternative editor background;
    5. editor font color;
    6. alternative highlight color.

Download and install the new version.

New version of RedExpert 2022.05 is available

Leave a comment

Added:

  1. Support for Firebird/RedDatabase 4 type
  2. Tablespaces support
  3. Explained plan support for Firebird/RedDatabase 3.0 and higher
  4. Table related triggers tab and navigation
  5. Editing objects in the database browser
  6. Execution of procedures and functions when viewing and editing them
  7. Ability to place the editor vertically or horizontally
  8. Search by text in any SQL-field

Fixed:

  1. Calculating trigger type using bitwise operations
  2. Reloading of system objects after creating a table via GUI
  3. Continue data generation when data mismatch error occurs
  4. Generating SQL for a procedure without parameters
  5. Reloading the object tree during CREATE OR ALTER and RECREATE operations
  6. Autocomplete freeze
  7. Commenting/uncommenting using “CTRL + /”
  8. Generate name for new connection
  9. Display in the center of the primary monitor when there are two monitors in Linux systems
  10. Show connection page without scrollbar
  11. Generate INSERT queries for DEFAULT fields

Download and install the new version

New version of RedExpert 2022.02 is available

Leave a comment

Added:

  1. Edit object button
  2. Password request dialog if password is empty
  3. Ability to work with cursors in a procedure
  4. Downloading updates in the background

Fixed:

  1. Request for saving data when closing a dialog box
  2. Displaying tables on Firebird with version less than 2.5
  3. Generating a function creation request with EXTERNAL NAME
  4. Inability to set the order of the index fields
  5. Incorrect display of dependencies
  6. Wrong generated column edit query when using a domain
  7. Syntax highlighting in views
  8. Recognition of object names in queries if they are at the beginning of a string
  9. Error adding a record with IDENTITY field
  10. Autocomplete errors in queries with aliases
  11. Tab-indexing order on connection page
  12. Wrong error “TABLE is in use” on attempt to remove table
  13. Error opening browser in Linux
  14. Index is active by default when created
  15. Modified the update dialogs
  16. High CPU load after connect
  17. DDL command generation error due to case-sensitive identifiers
  18. Connecting to a database immediately after it is created
  19. Commit transactions after they have been used
  20. Re-executing an SQL script without mandatory commit/rollback after a previous run
  21. Option to set null for string parameters in the parameter dialogue

Download and install the new version.

New version of RedExpert 2020.10 has been released

Leave a comment

New version of RedExpert 2020.10 has been released.

Fixes:

  • A value of a variable is not lost when editing a procedure.
  • Object names are quoted only when necessary.
  • Removed redundancy in variable declarations.
  • Generation of a random date (There was an error that the minimum is greater than the maximum).
  • Comments to variables are not lost when editing a procedure.
  • Roles which were not created by a user have been moved under the system roles branch.
  • Few first characters in the cell are displayed instead of ‘CLOB DATA’.
  • Removed the unreasonable occurrence of the error about the loss of connection with the server.
  • Fixed generation of table DDL statement.
  • Fixed generation of procedure DDL statement.
  • Fixed generation of trigger DDL statement.
  • Fixed display of table constraints.
  • Fixed display of release notes in the application.

Improvements:

  • Added the ability to use autoddl when executing a script.
  • Added the ability to manage update rule and delete rule for foreign keys.
  • Added the ability to use autocomplete without hotkeys.
  • Added the ability to delete user settings when uninstalling the application.
  • Added the ability to work with collates of character sets in datatypes.

Download and install the new version.

1 2