Major changes - v2026.08

Added:

  1. System-wide application installation support on Linux
  2. Windows UAC dialog requesting administrator rights to update the application
  3. Shortcuts configuration for some commands
  4. Enable the "Store Password" option for new connection by default
  5. Ability to delete multiple database objects at once in the connection tree
  6. Ability to profile queries against profiler tables
  7. Ability to enter the field type via the keyboard when creating a table
  8. Switching to the previously opened tab when closing the active tab
  9. Creation of a unique, anonymized installation identifier when checking for updates

Fixed:

  1. Automatically display autocomplete tooltips in the Query Editor
  2. Generating a DDL for table when exporting data to a SQL script
  3. "Result Set Limit Reached" dialog appears multiple times
  4. Display the query plan if the Query Editor output panel was closed during connection
  5. Displaying the process and result of executing a procedure/function in the dialog window
  6. Display large error messages in the exception dialog
  7. Scrolling to the beginning of the script when automatically generating an object's DDL while editing it
  8. Multiline string highlighting in the Query Editor

Major changes - v2026.07

Added:

  1. Ability to edit the Result Set in the Query Editor
  2. Ability to delete an object using the DELETE key in the connection tree
  3. Ability to format text via the procedure editor's context menu
  4. Creation of an autoincrement field using the IDENTITY by default
  5. Line wrapping in the feedback form

Fixed:

  1. Check for a cryptographic plugin when creating an individual connection for the Query Editor
  2. Application freeze when switching the auto-commit mode in the Query Editor during query execution
  3. Resource release before deleting a database table ("object is in use" error)
  4. Order of authentication plugin usage when establishing a database connection
  5. Navigation to a database object from the editor immediately after its creation
  6. Displaying CHECK constraints for domains in Red Database 2.6.Display of trigger check conditions on Red Database 2.6
  7. Display of unsupported database objects on the object "Privileges" tab
  8. Handling of the exception caused by attempting to execute a query in the Query Editor without an active connection
  9. Handling of the exception caused by closing a database object tab without applying changes
  10. Focusing on the selected row when changing the font size in the Query Editor
  11. Scroll bar display in some sections of the application settings
  12. Display of the connection tree when selecting more than one object
  13. Graphical defects in the database table creation interface

Major changes - v2026.06.1

Fixed:

  1. Automatic application update startup
  2. Updating built-in driver information

Major changes - v2026.06

Added:

  1. Ability to edit the SELECT query for views

Fixed:

  1. The interface locks up when attempting to perform more than one long-running operation with the database server in the same connection
  2. The interface locks up when updating the contextual suggestion dictionary for the query editor being opened
  3. Displaying table, view, or result set data if the record limit specified in the settings exceeds Integer.MAX_VALUE
  4. Unexpected connection to the database when creating a duplicate connection if an SSH tunnel is used
  5. Unexpected change of the server address and port to default values when creating a duplicate connection
  6. Collecting database statistics if options other than the default are selected
  7. Starting a profiling session in the selected connection
  8. Updating connection property information when selecting a connection in the "Database Browser"
  9. Updating indices and triggers associated with a table when it is refreshed in the connection tree
  10. Opening the "Indices" tab for the selected table if it contains computed indices
  11. Closing "Query Editor" tabs when disconnecting from a database in the "Database Browser"
  12. Closing tool tabs with the middle mouse button
  13. Errors in the application log when interacting with the toolbar

Major changes - v2026.05

Added:

  1. Ability to configure a list of authentication plugins to be used by default for new connections
  2. Ability to store user settings alongside the program
  3. Display the time spent for transaction commit / rollback in the Query Editor
  4. Ability to change the font size in the Query Editor using the mouse wheel
  5. Tool icons for the main application menu bar

Fixed:

  1. Connecting to a Firebird / RedDatabase 3 server using the "Legacy_Auth" authentication plugin
  2. Fetching table data when scrolling with the "END" or "PG_DOWN" keys
  3. Connecting to a database by double-clicking in the connection tree
  4. Interface refresh delays when selecting nodes in the connection tree
  5. Recreating the database file when using an alias instead of a real path
  6. Formatting of the original DDL text when editing database objects
  7. Columns in a result set table shifting to the right instead of jumping to the last cell when using the "CTRL+END" key combination
  8. Deleting an entire row instead of a single word when using the "CTRL+DELETE" key combination in the Query Editor
  9. Changing the cursor when hovering over the query text / result separator
  10. Creating a duplicate connection in the connections tree

Major changes - v2026.04

Added:

  1. Ability to use individual physical connections for each tool
  2. Shortcut for toggling the visibility of the connection tree
  3. Dialog box for configuring date/time templates
  4. Saving Query Editor draft ("Untitled" tab) with the CTRL+S shortcut
  5. "Use thousands separators for numeric values" option in the settings
  6. "Add an indent before the JOIN keyword" option in the settings
  7. Popup menu for the table containing the table or result set metadata
  8. New dialog box when exiting the application with unsaved changes

Fixed:

  1. Unexpected connection to the database when opening the connection properties if an SSH tunnel is configured
  2. COLLATE displaying for input/output parameters and variables of procedures and functions
  3. Launching the application and restoring settings after upgrading from old versions
  4. Application upgrade cancellation with the message "First, close other instances of RDBExpert" when no other instances are running
  5. Extracting comments for functions and procedures within a package
  6. Displaying the query results tab if it was hidden before execution
  7. Connecting to the database by pressing the ENTER key from the database browser
  8. Memory leaks when displaying the database creation dialog
  9. Check if some buttons on the query editor toolbar are enabled
  10. Expanding folders in the object tree by double-clicking
  11. Errors in the log when attempting to cancel an infinite database connection
  12. Delays when testing the database connection

Major changes - v2026.03

Added:

  1. "Silent" application installation mode on Linux (using the "--quiet" flag)
  2. Option to automatically expand the connections tree when establishing connection to the database
  3. Option to recalculate selectivity for the editing index

Fixed:

  1. Duplicating events in the "Trace Manager" panel
  2. Saving ER-diagrams with a header block to a file
  3. Parsing and formatting SQL queries with Q-quoted string literals
  4. Reloading connections tree when creating/deleting a database index
  5. Reloading connections tree when switching the display of system objects
  6. Automatic connection to the database when opening the "Trace Manager" if an SSH tunnel is used
  7. Automatic using the connection from the connections tree selection when opening any tool
  8. Various errors when changing the transaction isolation level
  9. Various errors when creating/editing database indices

Major changes - v2026.02

Added:

  1. A new SQL code formatting library
  2. An interface for viewing RDB$TRACE_MSG messages
  3. A configurable shortcut for applying hints in the Query Editor

Fixed:

  1. Changing tablespace and SQL SECURITY when editing a table
  2. UI freeze during database backup or restore
  3. Opening trace files generated by "Trace Manager" for analysis
  4. Numbering duplicate tool tabs with identical names
  5. Removing the JDBC parameter "roleName" when connecting to a database without a role
  6. Displaying the parameters "process_name" and "process_id" in extended connection properties
  7. Displaying a warning dialog about unsaved changes in the ER diagram
  8. Displaying the used collation when editing domains and table columns
  9. Changing the used collation when editing domains
  10. UI defects when configuring the tracing filter on HiDPI monitors
  11. UI defects when closing a tab on HiDPI monitors

Major changes - v2026.01

Added:

  1. A new tab system with an updated design and the tabs reordering ability
  2. Restarting the database generator from an initial value
  3. Changing the current value of the database generator
  4. Ignoring whitespace when comparing database metadata
  5. Automatic applying of saved application settings after an update
  6. Delay in confirming database deletion / recreation

Fixed:

  1. Determining the process identifier (pid) and executable file when connecting to a database
  2. Creating multiple processes when running a single application instance
  3. Error committing / rolling back a transaction in a newly opened Query Editor
  4. Error opening a user from the object tree if multiple connections are active
  5. Selecting a table to import data from a file when entering its name from the keyboard
  6. Opening parameters for a new connection created in a folder
  7. Loading a previously saved ER-diagram file
  8. Displaying the BLOB size when creating a domain
  9. Connecting to a database by double-clicking from the connections list
  10. Connection parameters were unexpectedly saved when clicking the "Test" button
  11. Clicks on the connection tree visibility button were ignored if it was initially hidden
  12. Opening the Trace Manager and DB Statistics tools if there are no configured connections
  13. Various errors occurred when creating and editing domains
  14. Descriptions of some settings in the application and documentation

Major changes - v2025.12

Added:

  1. Ability of connecting to the database using the embedded server
  2. Updated "Create Database" wizard
  3. Updated splash-screen in winter style

Fixed:

  1. Interrupting SQL script execution in the Query Editor when an error occurs if the corresponding parameter is enabled
  2. Generating DDL scripts for database objects with a default encoding other than "NONE"
  3. Validating entered values before starting the data generation process in the "Test Data Generator" tool
  4. Checking the selected driver when connecting to a database from the context menu of the connection tree
  5. Ignoring the "Maximum number of returned records" parameter on the "Data" tab for tables
  6. Releasing the connection lock if retrieving / comparing database metadata is interrupted due to an error
  7. Artifacts appear in the connection tree when executing DDL scripts in the Query Editor
  8. Table triggers counting in the connection tree when adding a new trigger
  9. Duplicate edited database package after applying changes
  10. Incorrect mapping of data source fields and calculated fields of the target table when clicking the "Correlate" button in the "Import Data" tool
  11. Unexpected restoration of the connection server and port after deleting them and applying changes
  12. Various application errors when running from a directory other than the installation directory
  13. UI freeze when adding parameters to a procedure
  14. Typo errors in the "Test Data Generator" tool panel

Major changes - v2025.11

Added:

  1. Ability to delete and recreate a database

Fixed:

  1. Errors preventing new database creation
  2. Procedure parameters disappearing after recompile
  3. Protocol version used when connecting to a database in native mode
  4. Prematurely saving connection parameters when the connection panel loses focus
  5. Navigating to a database object from the Query Editor if its name is not unique

Major changes - v2025.10

Installers for Windows and Linux have been updated.
The Jaybird 5 driver has been updated to version 5.0.27.

Added:

  1. Ability to work with DDL rights and system privileges in the Grant Manager
  2. Displaying dependencies for exceptions

Fixed:

  1. "Invalid time zone region" exception when connecting to a database using the Jaybird 5 driver
  2. Toggle the database trigger activity state via the context menu in the connections tree
  3. Saving and restoring Query Editor tabs when establishing / releasing a database connection
  4. Application shortcut updating on the desktop for different interface languages
  5. Prematurely saving connection parameters before clicking the "Save" or "Connect" button

Major changes - v2025.09

Rebranding, the application has a new name - RDBExpert.

Fixed:

  1. Escaping keywords in the column name when creating a constraint for a table
  2. Loading the client library when connecting to a database using the Jaybird 4 driver
  3. Updating the list of database generators in the object tree when executing a CREATE | DROP query with the GENERATOR keyword instead of SEQUENCE
  4. Updating toolbar buttons state when establishing / releasing a connection
  5. Unexpected opening of new query editor when calling auto-completion context menu using WIN + SPACE key combination
  6. Displaying the number of objects for empty nodes in the connection tree

Major changes - v2025.08

Jaybird drivers updated.

Added:

  1. Migration tool from InterBase DBMS to Red Database
  2. New filter system for analyzing trace sessions
  3. New profile system for configuring trace sessions
  4. Ability to execute a query with tracing in the editor
  5. Ability to create a table from a binary trace file
  6. Display of system table descriptions in the connection tree
  7. Highlighting of system functions in the Query Editor

Fixed:

  1. Authentication error when connecting to the server using a certificate
  2. Permission error when running update using embedded Java
  3. Ignoring JVM arguments from configuration file when starting application
  4. Incorrect trace log parsing due to print_hostname option enabled
  5. Multiple exceptions when creating user with additional attributes
  6. Incorrect generation of authentication plugins list when creating a user
  7. Add new connections to the end of the tree even if a target folder is selected
  8. Table columns and constraints disappear after changing table
  9. Missing of matching brackets highlight in the procedure editor
  10. Problems displaying large text from BLOB field

Major changes - v2025.07

Improved:

  1. Metadata Extract / 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

Major changes - v2025.06

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

Major changes - v2025.05

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

Major changes - v2025.04

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
  5. Documentation in English

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..."
  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

Major changes - v2025.03

Added:

  1. Query plan display in the profiler panel
  2. Saving and loading profiler sessions
  3. Saving recent hosts for connections
  4. Text search for settings
  5. Ability to copy application version in the "About" dialog window

Improved:

  1. Selecting connection to profile
  2. "Add Record" dialogue window
  3. Application icon

Fixed:

  1. Adding table constraints in Firebird and Red Database with version 3 or below
  2. Creating an auto-increment column in Red Database (Firebird) with version 3 or below
  3. Creating a database backup in Red Database (Firebird) with version 3 or below
  4. NPE on connection change when creating new table
  5. Resetting the Java path after changing settings
  6. Executing INSERT queries with RETURNING
  7. Freezing on application launch
  8. Loading tables in Red Database 2.6
  9. Application restarting after update
  10. Application restarting after changing settings
  11. Application displaying on the taskbar in Linux
  12. SQL tabs fonts updating after changing settings
  13. Generating test values for WIN1251 encoded fields
  14. Test data generator freezing when exception occurs
  15. Editing JOBs using the Jaybird 3 driver
  16. SQL query generation for views with comments in the SELECT statement
  17. Creating a database from the SQL script

Major changes - v2025.02

Added:

  1. Ability of overwriting the database backup file *

Improved:

  1. Panel for adding table columns

Fixed:

  1. Working with database with ODS 13.0 version using Firebird 5 server
  2. Duplicating Query Editor tabs
  3. Creating packages with a space in the name
  4. Creating database objects with comments
  5. Displaying the current generator value
  6. Resetting duplicated connection parameters
  7. Floating errors related to profiling results display
  8. Updating connection tree when adding/removing database objects
  9. Saving ER-diagrams with extensions to SVG and PNG files

* Overwriting the database backup file is available in the Red Database DBMS starting from version 5.0.1.
The Firebird DBMS does not support this function.

Major changes - v2025.01

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

Major changes - v2024.12

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

Major changes - v2024.11

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.

Major changes - v2024.10

Added:

  1. Support of Portuguese interface language
  2. Query execution statistics by each table
  3. Firebird options for trace manager configuration files
    (thanks to André Vivian Farias)
  4. Copy formatted date and time values
  5. Fix table name in the "Create Index" and "Create Trigger" dialogs

Improved:

  1. Edit table data
  2. Panel for creating a table constraint
  3. Check if the installed version of the application is up to date

Fixed:

  1. Executing SQL queries that contain the CASE - END clause
  2. Executing SQL queries that contain RECREATE PACKAGE clause
  3. Executing SQL queries that contain the CALL procedure_name clause
  4. Executing SQL queries that contain the DECLARE CURSOR clause
  5. Generation of "CREATE TABLE", "CREATE GLOBAL TEMPORARY TABLE", "ADD CONSTRAINT ... USING INDEX" queries
  6. Prolonged loading of compound properties
  7. Open a previously closed preference tab
  8. Open a connection with invalid JDBC parameters
  9. Open edit panels for objects with the same name from different connections
  10. Open the "Export Metadata" and "Compare Database" panels when there is no registered connection
  11. Ignore the "Ask to save open documents" setting
  12. Ignore the result of SQL query execution that terminated with an error
  13. Displaying the query execution time
  14. NPE when creating a procedure or function
  15. Handling of JVM options at application startup
  16. Logging database connection and disconnection errors
  17. Delete table data when "Use form to add/delete rows" option is enabled
  18. Display a blank shortcut
  19. Display the list of tables when importing data
  20. Resets the "Appearance" properties to the defaults
  21. Save history of query editor tabs
  22. Update connection tree nodes when creating and deleting database objects

Major changes - v2024.09

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

Major changes - v2024.07

Improved:

  1. Application interface
  2. ER-diagram tools
  3. The execute button in the query editor can now

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

Major changes - v2024.05.1

Fixed:

  1. Feedback
  2. NPE when creating procedures or functions
  3. Formatting procedure parameters with spaces in their names

Major changes - v2024.05

Added:

  1. SQL scripts execution without SET TERM
  2. Extended display of database and DBMS information in connection parameter
  3. Ability to specify the relative path to the used Java and application logs folder

Fixed:

  1. Foreign key selection dialog display
  2. Generation of SQL script for deleting objects when comparing databases even when this option is disabled
  3. SQL script execution error if variable name is the same as parameter name
  4. Displaying of DDL functions
  5. Dependencies for packages and UDFs display
  6. Double-click to expand a node in the connection tree
  7. Escaping apostrophes when creating an exception
  8. Export UDF from Firebird 3 using UTF-8 encoding
  9. Display related foreign key columns
  10. Deadlock on editing table records
  11. RedExpert hangs when opening the "Memory Usage" tool
  12. Adding variables when generating SQL script for creating procedures
  13. Adding comments to database table fields
  14. Creating a connection folder with an empty name
  15. Navigating through the tabs of the database table editing panel
  16. UI of create JOB, PROCEDURE and FUNCTION panels
  17. Improve RedExpert changelog (release notes) panel

Major changes - v2024.04.1

Fixed:

  1. Adding NULL records to a table from the "Data" tab
  2. Deleting table records from the "Data" tab
  3. Incorrect memory display in the "Memory Status" window

Major changes - v2024.04

Added:

  1. Ability to set display format for table data with types "TIME WITH TIMEZONE" and "TIMESTAMP WITH TIMEZONE"
  2. Connection to the selected database by pressing the Enter key in the connection tree
  3. Expand/collapse selected node by pressing the Enter key in the connection tree
  4. Index selectivity display when editing a table
  5. Closing ResultSet and statistics tabs by clicking on the mouse wheel
  6. Connection to database from the SQL script in the "Execute SQL script" panel

Fixed:

  1. Attempting to run an application in a minimal Java runtime environment (headless)
  2. Application updating using automatically downloaded Java
  3. Updating by proxy
  4. Updating the list of indexes when editing table
  5. Root tree node display in the profiler panel
  6. Restoring cell dimensions after editing it in the table "Data" tab
  7. Determining the size of columns in a dataset according to the width of its contents
  8. Cell editors for data with Date/Time types
  9. Action of the "Switch data display" button and similar functionality in the drop-down menu on the table "Data" tab
  10. Domains comparing
  11. Display format changing of a field with the TIMESTAMP type when editing it
  12. SQL scripts generation when extracting metadata for domains, exceptions, roles, indexes, external functions and jobs
  13. "Metadata Export" tool behavior when objects to be extracted were not detected by the program
  14. Retrieving information about objects with JOB type during metadata extraction
  15. Connection tree refresh when automatically connecting to the database from other program modules
  16. Ignoring the last query when executing SQL script if it does not have a delimiter character
  17. New Query Editor panel opening for an automatically connected database
  18. Application panels size adjusting when open new ones
  19. Database connection properties saving
  20. NPE when switching from the table "Data" tab without applying changes
  21. "Find and Replace" tool behavior
  22. Page Up/Page Down key actions when working with statistics
  23. BLOB parameters recognizing in the UDF
  24. Connection error output in the Database Statistics tool
  25. Autocomplete in the Query Editor
  26. Updating in the object tree when changes are made in the query editor
  27. Changing the cursor position when ESC is pressed

Major changes - v2024.03

Added:

  1. Update without authorization on reddatabase.ru
  2. Tablespaces support when working with database statistics
  3. Displaying information about "sorting memory usage" in the Trace table
  4. Minimum values columns on the "Analysis" tab in the "Trace Manager"
  5. Ability to export statistics tables data
  6. Buttons "connect to all databases" and "disconnect from all"

Fixed:

  1. Rows numbering in the Query Editor, when the "Row Transfer" option is enabled
  2. Columns and constraints data display after table reloading
  3. Graphical defects of the procedures and functions execution window
  4. Parameters input dialog displaying at repeated execution of a parameterized query
  5. SQL scripts generation for Functions, Procedures, Users, DDL-triggers, UDF, Database connection strings, Table comments, Table calculated fields
  6. User manager behavior when GostPassword_Manager plugin is enabled
  7. Rework "User Manager" module
  8. Errors of "Metadata Export" module
  9. Copying a database in the connection tree by drag’n’drop with CTRL
  10. Updating color settings for the "Query Editor" and the "Result Set" panel when switching between dark and light application themes
  11. Loading information about users with the same name but different plugins
  12. Case sensitivity of file type when importing data
  13. Errors when importing data from Excel file
  14. Displaying connection information
  15. Behavior when changing encoding in Trace Manager
  16. Duplicate Query Editor tabs
  17. Column editing errors when system object display is disabled
  18. Errors and freezing when quickly establishing/disconnecting database connection
  19. Data alignment on the "Result Set" panel
  20. Graphical defects when working with the application

Major changes - v2024.01

Added:

  1. Support of work with database statistics:
  2. Data import support from XLSX and XML files
  3. Export/import of data with BLOB type
  4. Ability to select columns when exporting data
  5. Ability to transfer data from one database to another
  6. Database metadata extracting into SQL-script
  7. SQL-queries executing to a file directly
  8. Transaction parameters support in the Query Editor
  9. Query execution in several connections simultaneously
  10. Transaction confirmation window when closing the Query Editor and the "Data" tab of tables and views
  11. Displaying connection and database properties (such as server, page size, database file size, etc.)
  12. Ability to copy column names from a Result Set
  13. "Triggers" tab for views
  14. Ability to configure database connection timeout
  15. Updated data import and export panels

Fixed:

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

Major changes - v2023.10.1

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 RedExpert 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 application icon in Windows.
  18. Functioning of such application settings as: highlighting the current line; number of saved log files; selected text color; alternative editor background; editor font color; alternative highlight color.

Major changes - v2023.08

Added:

  1. Online table validation.
  2. Ability to set different date-time templates for fields with DATE, TIME and TIMESTAMP types.
  3. Ability to enable line wrapping mode in the Query Editor.
  4. Support of the PSQL-profiler.
  5. Tree view display with a panel of differences for each object as a DB comparer result.
  6. New Foreign Key selection panel on the "Data" tab when working with DB tables.
  7. Ability to reset color to default by RMB click in the color settings.
  8. Ability to filter columns by their names in the "Result Column Visibility" window for a Result Set.
  9. Audit analysis.
  10. Auto-complete for packages (procedures and functions are suggested after a dot).
  11. Date display in the application log.
  12. Ability to write trace to file without parsing in the application.
  13. Ability to navigate tabs with a mouse wheel.
  14. Ability to enable or disable parsing of variable declarations in Procedures and Functions.
  15. Ability to recalculate index statistics from the corresponding tab of the table.

Fixed:

  1. Inability to add a comment for a table field when editing it.
  2. An error due to which the content of the "SQL" tab during table creation was not updated when changing the "Comment" tab content.
  3. Option "Show Grid" in the "Links" tab when working with a DB table.
  4. Displaying the username in the "Select Result" tab when editing a user is confirmed.
  5. Generation of the SQL scripts for packages, views, tables and jobs.
  6. "Description" tabs renamed to "Comment".
  7. Incorrect application of theme and style for the Query Editor.
  8. Wrong SQL script formatting in the Query Editor.
  9. NPE when navigating through folders in the connection tree.
  10. An error due to which the fields and constraints of the DB table disappeared when changing its comment.
  11. Defects when moving multiple connections to a folder in the connection tree.
  12. Error getting tablespaces and jobs from the Firebird connection during DB comparison.
  13. Error editing cell in the Result Set.
  14. An error due to which when installing an application with root, it was not added to the application menu.
  15. Adding a post-install application shortcut for all users that could not be removed.
  16. Errors while updating the application. Updates are now downloaded and unpacked into the temporary folder, and only one copy of the application must be open to run the update.
  17. Error opening Trace Manager, if there are non-standard drivers.
  18. Error saving ER-diagrams.
  19. Displaying scale for NUMERIC type.
  20. Sorting of visible columns of Trace Manager.
  21. Errors working with column names starting with a space.
  22. Failure to insert a password when creating a user.
  23. Search in the object tree (by string occurrence).
  24. Incorrect authentication error detection.
  25. Failure to copy name when editing an object.
  26. Generating DDL functions containing cursors.
  27. Adjusting width of the Result Set columns by content.
  28. Editing Primary Key fields by multiple fields.
  29. Disabled the ability to use ARRAY data type.
  30. Localized: Driver Selection Panel; Color Selection Panel; File Selection/Saving Panel; labels, hints and context menus in the Query Editor; Password View Panel; Connection Details Panel; Notepad Panel; ER-diagram Editor.

Major changes - v2023.05

Added:

  1. Scheduler support
  2. Database metadata comparison
  3. Jaybird 5 support
  4. Ability to recompile all views
  5. Autocomplete for variables and parameters when working with procedures and functions
  6. Highlighting paired brackets
  7. Line number and cursor position in each SQL field
  8. Ability to set font size greater than 16 pt. in the Query Editor
  9. DDL tab for exceptions

Fixed:

  1. The arrangement of elements on the panels for creating and editing objects has been redesigned
  2. Reduced connection time to the database
  3. Reduced metadata loading time for object recompilation
  4. Generation CREATE and ALTER SQL-scripts for some objects
  5. Error opening triggers, procedures and functions in Firebird
  6. Memory leaks after closing objects
  7. Trace parsing
  8. Parameters were case-sensitive in the Query Editor
  9. Working with object privileges
  10. Problem with restarting RedExpert after installing an update on Linux systems
  11. Incorrect display (spelling) of the keyword "TIME ZONE"
  12. Behavior of the "Execute" button in the Query Editor (Now when you click on it, the script is executed as a whole block and isn't divided into several queries in accordance with the delimiters. To execute an SQL-script from several queries, you need to use the "Execute SQL-script" button)
  13. Buttons tooltips in the Query Editor and in the creation (editing) table panel
  14. Error while editing tables foreign keys (the reference table name and its fields were not substituted into SQL-query)

Major changes - v2023.02

Fixed:

  1. Bug in developer feedback module (request for new features, bug reports, comments)
  2. Clearing a list of triggers on a "Triggers" tab in a table after opening one of them
  3. Restoring to default settings for query editor colors

Major changes - v2023.01

Added:

  1. Recompilation all triggers, procedures, functions and packages
  2. Association of *.fdb files with RedExpert
  3. Recalculation of index selectivity
  4. Support for external triggers
  5. SQL SECURITY support for procedures, functions and triggers
  6. "Switch data display" button and key combination [ALT + NUM_ADD] in data tab
  7. Exit confirmation dialog
  8. Specifies explicitly how a table field is sorted (COLLATE) when creating a table
  9. "DDL to create" tab in "Edit constraint" panel
  10. Ability to view password during user creation and authorization at reddatabase.ru
  11. Ability to replace "\n" with another symbol when exporting to file with separators
  12. Ability to work with functions and packages in privilege manager
  13. Support for triggers on views

Fixed:

  1. Trace recognition
  2. Parsing SQL script with queries that have complex nested constructions
  3. Incorrect default value generation for procedures and functions
  4. Impossibility to create a new connection through the menu in the Russian localization
  5. Generating of primary keys when creating a table, if their names must be escaped
  6. Quotation mark when exporting into CSV
  7. Error when interacting with table constraints that have invalid default names
  8. Error when generating SQL script for adding table constraints when only one constraint was inserted into script instead of multiple ones
  9. RedExpert hangs after a data access error in the "Data" tab of the "Table" menu.
  10. Adding comments to database elements like "User" or "Domain" while editing them
  11. Generating SQL script when adding a new column to a table
  12. Export to a spreadsheet. Now export to Excel 2007 is possible
  13. Automatic generation of table name on creation
  14. Updating auto-complete cache after metadata changes
  15. Incorrect displaying of procedure parameter sizes
  16. Script execution error output if there is no connection
  17. Executing non-selective procedures in the query editor
  18. Wrong message about authentication error
  19. Invalid connection status in the toolbar
  20. Loading data in a table when moving the cursor to the last table row
  21. Updated keyword list for syntax highlighting
  22. Creating a database with default charset
  23. Flickering interface in privilege manager
  24. Invalid representation of "DATE" type when exporting to SQL
  25. Undo/redo (Ctrl+Z/Ctrl+Y) in the query editor
  26. Nonoptimal space usage by result set in query editor
  27. Application hangs when opening objects

Major changes - v2022.09

Added:

  1. Ability to save columns order and width in trace manager
  2. Field with performance counters in Trace Manager
  3. Export tables of Trace Manager
  4. Import data from a text file with separator
  5. Export data to SQL script
  6. Ability to change activity for several triggers and indexes in the object tree
  7. External tables support
  8. Support for external procedures and functions
  9. Support for comments on tables, procedures, functions and views
  10. English version of the release notes

Fixed:

  1. Quoting of table names when generating INSERT, UPDATE, DELETE queries
  2. Slow loading of tables
  3. Incorrect recognition of default value for procedure parameters if '=' is used
  4. Table column comment formatting in DDL query
  5. Rollback transaction on closing request dialog
  6. Error in generating date and time values in the test data generator
  7. Wrong message about successful creation of external procedures and functions in request editor
  8. Incorrect generation of "create generator" query
  9. Errors of trace parsing
  10. Autocomplete columns to alias escaped table

Major changes - v2022.05

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

Major changes - v2022.02

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

Major changes - v2021.10

Added:

  1. Display foreign key data while editing a table
  2. Context menu in "Set NULL" table
  3. A tab with object privileges
  4. System generators in the object tree
  5. Updating objects when they are changed in the query editor

Fixed:

  1. Autocomplete in query editor (not all tables were displayed in the list)
  2. Syntax highlighting
  3. Wrong table name after editing the trigger
  4. Hiding system packages for version prior to 3
  5. Connection cancellation
  6. Displaying an error while fetching ResultSet
  7. Parsing errors in the trace manager
  8. Slow work of the grant manager
  9. Inability to undo domain selection
  10. Inability to add a column to a table if cursor is outside the fields area (while table creating).
  11. Reloading objects in the tree after changing
  12. Jump to an object from the dependency tree
  13. Formatting of generated SELECT, INSERT, UPDATE queries
  14. Changed name of constrained is generated immediately when the form is opened

Major changes - v2021.07

Added:

  1. When selecting a database in the tree, the information about the database is not displayed; it is displayed by selecting the appropriate context menu
  2. Reworked the syntax highlighting, used ANTLR (reduced load time).
  3. Autocomplete added to all textbars that use SQL.
  4. Jump to database objects added to all text panels that use SQL.
  5. Added the "Users" node to the objects tree
  6. Added Jaybird4 driver

Fixed:

  1. Data type selection is done through a drop-down list
  2. When deleting a record in the table, the records marked for deletion are highlighted at once.
  3. The message about unsuccessful DDL operations is corrected
  4. In text blobs it's allowed to display unreadable characters
  5. The editing of the function is fixed
  6. Fixed SSH tunnel connection
  7. Stopped using template when creating tables
  8. Fixed column editing (when clicking on a column a new one was created).
  9. Fixed errors on the SQL tab of a domain
  10. Non-empty nodes in the tab with dependencies are highlighted in bold
  11. Fixed parsing variables in procedures (invalid parsing generated an incorrect SQL request for procedure creation).
  12. Packages that were not created by users were moved to a branch of system packages.
  13. Fixed connection to RedDatabase and Firebird versions > 4

Major changes - v2021.03

  1. Added driver manager
  2. Fixed creation of the database
  3. Fixed bugs when editing procedures
  4. Fixed reading of text blobs in the ResultSet
  5. Fixed the title of the table with the description of the columns

Major changes - v2021.02

Added:

  1. Improved application interface
  2. Added support of DDL triggers

Fixed:

  1. Fixed generation of a query to create a column with collate.
  2. Fixed bugs with auto-completion in the query editor.
  3. Closing the Query Editor does not throw an exception.
  4. Fixed display of domain size.
  5. Fixed opening of the query editor on an empty database.
  6. Executing the script: the script is taken from the text field if no file is selected.
  7. Ability to specify a port when database if created using a script.
  8. Displaying information about tables from external files.
  9. Optimized loading of metadata.
  10. Fixed opening packages in firebird database.
  11. When generating a query, comments to columns are displayed each on a new line

Major changes - v2020.10

Added:

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

Fixed:

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

Major changes - v2020.8

  1. The launch of the program and the search for java are completely redesigned. Now if java was not found, it is suggested to select the path manually or download automatically.
  2. Fixed display of system objects (Generators, domains and functions that are not defined by the user are not displayed in the main nodes)
  3. Fixed execution of a script containing "execute block"
  4. Fixed editing procedure with declare variables block
  5. Removed the type of object when copying the name
  6. Fixed display of tables if "RDB$RELATION_TYPE IS NULL"
  7. Fixed bugs with autoincrement that occurred when creating and editing tables.
  8. Other minor fixes

Major changes - v2020.04.1

  1. Added ability to see and navigate object dependencies
  2. Added test data generator
  3. Fixed updating from reddatabase.ru
  4. Some minor bugs fixed

Major changes - v1.0.7

  1. Fixed execution of large scripts
  2. Added autoincrement with identity
  3. Fixed bug with java search in folders with brackets in their names

Major changes - v1.0.6

  1. Fixed incorrect formatting of procedure body during editing
  2. Fixed error of launching from shortcuts in linux systems when searching for a driver
  3. Fixed bug of launching in Windows systems and added explanation in the log if there is java on the computer, but not supported architecture
  4. Fixed bug with feedback and updates
  5. Fixed blob reading bug

Major changes - v1.0.5

  1. Added license for installer in linux
  2. Added selection of active/inactive indexes and triggers in the object tree
  3. Added opening an object with the ENTER key

Major changes - v1.0.4

  1. Native executable files for Linux and Windows are improved. In Linux, Java is searched for in potential installation locations (Oracle JDK and Open JDK), in Windows, Java is searched for in the registry. In the absence of Java in potential installation sites and in the registry, the search is performed using the JAVA_HOME environment variable and the PATH environment variable.
  2. RedExpert got the opportunity to install using the installer. After installation, shortcuts for quick launch of the program are created.
  3. Libraries from the Visual C ++ package for Visual Studio 2013 are linked statically, which eliminates the need to install the package on Windows systems
  4. Added the ability to connect to the database by double-clicking and using the button on the connections panel
  5. In the object tree, the display of the symbol for further disclosure of a node that has no descendants is removed. Also for the database displays the number of objects (for example, TABLES (6451))
  6. Added option in settings to hide system objects in the object tree
  7. Improved table metadata editor
  8. Fixed and improved script artist
  9. Removed items for creating, editing and deleting in system branches
  10. Improved interface for performing procedures and functions with the ability to enter parameters and request parameters if the user has not specified them
  11. Changes made via the user interface are displayed in the object tree. Tree nodes are updated automatically upon successful completion of add, edit, delete operations.
  12. Added differentiation of roles and users in the user manager (separate icons)
  13. Changed display of connection windows in the user manager (removed unnecessary windows when there are no connections)
  14. On the Membership tab, the option "User → Role" is enabled by default. The remaining options are deactivated.
  15. Before sorting the data in the table, a full fetch is done.
  16. Added the distinction between the display of the total and the loaded (recorded) number of records in the table. Automatic counting of the number of entries is disabled by default, is enabled in the settings. Added button to immediately get the number of records.
  17. When pressing the ESC key in the mode of creating and editing objects, an exit confirmation is requested.
  18. Added feature of feedback without authorization on reddatabase.ru
  19. Fixed display of menu items for nodes in the object tree (removed inaccessible actions that were never available, for example, reboot to connect)
  20. Fixed error saving connection settings
  21. Fixed display of the window title when connecting to the server through the user manager
  22. Fixed creation of objects whose names match server's reserved words (escaped by double quotes)
  23. Fixed a double click on the object in the object tree (the tree does not expand when it is)
  24. Fixed table editing mode. When you click "Apply" did not exit the edit mode, as a result, changes in the editable field were not displayed.
  25. Fixed procedure call using "execute procedure" in query editor
  26. Fixed reconnection (Recycle) to the database (not performed at all)
  27. Fixed closing cursors when closing a table
  28. Fixed deletion of objects (if the object is open, it cannot be deleted)
  29. Fixed the location of menu objects (removed inaccessible and under development)
  30. Fixed display of the "Database Tools" menu (hiding, although it was active)
  31. Hidden schemes (in the "Firebird" and "Red Database" they are missing)
  32. Fixed display of errors in dialog boxes (structured output)
  33. Fixed working with tables if OpenJDK is used as Java (NPE when clicking on a table cell)
  34. Fixed bug where after adding a role it is impossible to create (change and delete) a user
  35. Fixed error output when editing connections
  36. Fixed opening procedure when using Firebird 2.1.5
  37. Fixed bug when assigning a role in the "Membership" tab
  38. Fixed grant roles if there were users with identical names.
  39. Fixed error when assigning a role to a role.
  40. Fixed closing the connection if there were open objects
  41. Fixed display of errors when connecting to an inaccessible database, if the connection is performed by clicking on the connection button
  42. Fixed display of the search window when you press ALT in Windows (when clicked, the window disappeared)
  43. Fixed bug with double-clicking on "Favorite" connections
  44. Fixed definition of hot keys in the application settings
  45. Fixed display of columns in the table when fetching data
  46. Optimized loading of the Membership tab in the user manager
  47. Fixed display of the body VIEW. The body is displayed as it is stored in the database, a separate button has been added for formatting.

Major changes - v1.0.3

First public release of database manager RedExpert!
RedExpert based on Execute Query and use Java technologies under hood.
It features:

  1. Simultaneous work with multiple databases
  2. Development and execution of any SQL commands supported by the DBMS using the query editor view query - results (including Result Set datasets)
  3. Formatting SQL code
  4. Code autocompletion mechanism
  5. Designing the database structure in the visual designer of ER-diagrams with Reverse Engineering functions and exporting diagrams to various formats.

Also, RedExpert exclusively provide next features:

  1. Support for any versions of the RedDatabase and Firebird from out of the box
  2. Creating and editing database objects using the visual editor
  3. Tracking of any operations with the database in real time using the trace manager
  4. User management through a user interface graphical interface
  5. Visual privilege management with rights manager
  6. Support all types of authentication