Author: roman

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.07 is available.

What’s new?

Improved:

1. Metadata Export / Compare tool

Fixed:

1. High CPU and RAM load when CTRL is held down in the Query Editor
2. Infinite reconnecting to DB using certificate
3. Editing table columns with encoding and dimensions
4. Editing database users
5. Loading table triggers in Firebird 2.5
6. Loading procedure parameters
7. Loading table constraints
8. Creating a database backup by overwriting an existing file
9. Restoring Query Editor tabs after restarting the application
10. Loading drivers for connections containing spaces in the path
11. Application hangs when working with unsupported DBMS
12. Displaying hints for password input field
13. Displaying the database statistics

Download and install the new version.

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.06 is available.

What’s new?

Required Java version has been updated to 21 LTS.
Java is supplied with the application now.

Added:

1. Support for partial indexes
2. Specifying JVM parameters in the configuration file
3. Script for creating triggers and indexes for table metadata
4. Connection tree visibility button

Fixed:

1. Display settings after updating from the old versions (2024.07 and older)
2. Generate SQL script for computed indices
3. Generate SQL script based on ER diagram
4. Displaying a query plan containing tables with “PLAN” in the name
5. Working with the user context (AUTHID and SQL SECURITY)
6. Handling errors that occur when connecting to a database
7. Saving and loading ER diagram files
8. Inserting and deleting table data using a dialog box
9. Applying settings using the “OK” button
10. Changing the colour properties for the table “Data” tab
11. Displaying GUI components on some panels
12. Displaying the date editor in a dark theme
13. Displaying the application shortcut on Windows OS

Download and install the new version.

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.05 is available.

What’s new?

Added:

1. OCTETS character set support
2. Display UUID in hexadecimal
3. Warning about incompatible ODS server and DB versions
4. JetBrains Mono font for query editor

Fixed:

1. Editing the scale of columns with NUMERIC and DECIMAL types
2. Working with different file encodings in the query editor
3. Saving the size and location on the screen
4. Changing editor fonts in settings
5. TABs to spaces converting
6. Restarting application if there is unsaved data
7. Editing tablespaces with comments
8. Creating table with domain columns
9. English documentation opening
10. Copying a result set with NULL values to the clipboard
11. Password field displaying in classic theme
12. Displaying angle brackets in the SQL script difference pane
13. Query editor tabs behavior on establishing/releasing DB connection
14. SQL header generation when retrieving database metadata
15. Deleting table records with the using of dialog window

Download and install the new version.

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.04 is available.

What’s new?

Added:

1. Displaying the execution time of each query in the editor
2. A dialog informing about new version of the application
3. Ability to select driver when executing SQL script from a file
4. Ability to open the file location from the editor

Fixed:

1. Memory leaks when using the application for long time
2. Scaling the application window on HiDPI monitors
3. Adding drivers for connection
4. Creating constraints using TABLESPACE
5. Creating constraints using “USING <index>”
6. Editing tablespaces
7. Using negative values in fields with DOUBLE PRECISION type
8. Activity of editor toolbar buttons after changing it in the settings
9. Switching between executed requests in the editor
10. Search for nodes by name in the connection tree

Download and install the new version.

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.01 is available.

What’s new?

• Updated the list of available application themes based on the survey results.
• Stopped support of 32-bit Windows (x86) operating systems.

Improved:

1. Display application fonts in new themes
2. Copying field names with data types from a Result Set
3. Data view panel interface for BLOBs that not available for editing

Fixed:

1. Trace parsing
2. Interacting with Red Database 2.6 and Firebird 2 connections
3. Processing of connection parameters when changing the interface language
4. Readability of selected lines on the “Analyze” tab in the Trace Manager
5. Applying old settings, which require restarting the application, during upgrade
6. Customizing date and time patterns
7. Adding a comment to JOB
8. Behavior of the “Wrap lines” checkbox on the BLOB data view panel
9. Confirmation dialog disappearing when altering the database object
10. Dialog closing after creating database objects
11. Applying and restoring settings
12. Various exceptions occurred by the data export
13. Displayed data type size in the results of the SELECT query

In previous versions, Portuguese language support was added. We want to make the app better, so we welcome comments from native speakers.

Download and install the new version.

You can join to the Telegram chat for discussion.

New version of Red Expert 2024.12 is available.

What’s new?

Added:

1. Formatting numbers for table statistics
2. Copying formatted column names

Improved:

1. The amount of memory required for audit analysis has been reduced
2. Exporting data with BLOB SUB_TYPE TEXT type now does not require mandatory file specification for exported blobs

Fixed:

1. Recalculation of index selectivity
2. Parsing of the nested procedures
3. Parsing of the procedure cursors
4. Parsing of the procedure variables with NCHAR, REAL, INT, LONG FLOAT and other types
5. Generating SQL statements for variables with COLLATE
6. Display SQL queries containing special characters on the “Analyze” tab in the Trace Manager
7. Increased CPU load after repeated opening of the search window in the Query Editor
8. Mismatch between the versions of the client library and driver used for native connection

Download and install the new version.

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.