Author: roman

I'm a developer of RedDatabase

RedDatabase 3.0.9 release

Leave a comment

New version of RedDatabase 3.0.9 has been released.

The most significant changes are:

Improvements:

  • A “verbose” option has been added to the replication configuration to log detailed information about asynchronous replication operation. RS-70819.
  • LDAP error diagnostics have been improved.
  • The stability of gfix is improved. RS-71591.

Changes:

  • DefaultDbCachePages default value increased to 1024 for Classic/SuperClassic and to 32768 for Super RS-69307
  • Now you do not have to specify option -B O[VERWRITE] in gbak when backing up to FIFO RS-43334
  • Temporary tables file is now deleted immediately after closing connections which used temporary tables RS-67781
  • Maximum length of ISQL error text increased to 8192 characters. RS-71232.
  • Default length of context variables is increased to 8192 characters. RS-71426.

Added:

  • Ability to connect to ActiveDirectory with an “as is” user name (bind method) without using a service account (LDAPUserDn). RS-71303.
  • New LDAPDomain parameter in firebird.conf that allows setting the domain for user authentication in ActiveDirectory and the base for user lookups. RS-71303.
  • GSTAT outputs the transaction difference, which determines whether garbage collection is needed RS-56624
  • “rotate_log” parameter in trace to rotate log when it reaches “max_log_size” RS-66090
  • Support for locking users in Legacy Authentication RS-67826 Note: security database update from previous versions 3.0 with security_database_3.0.9.sql script
  • Ability to change COLLATE for “ALTER TABLE <table> ALTER <column> COLLATE <collate>” field RS-67405
  • Different connections can now use different temporary table files to reduce their sprawl (SeparateTempTableFiles parameter in firebird.conf) RS-67781

FBJava has been updated to 1.1.18:

  • ASM library required for indexing files stored in BLOBs has been added to the distribution. RS-82611.
  • Jaybird driver updated to version 3.0.31. RS-74811.
  • Unused jna-platform-4.5.0.jar and xml-apis-1.0.b2.jar libraries were removed from the distribution. RS-74811.
  • Fixed passing an exception to the client when initializing the JVM
  • Debug symbols for FBJava have been added to the distribution. RS-71111.
  • Blank lines are not printed to stdout and stderr when it’s disabled by “disable_output” option RS-66433
  • The existence of configuration file is checked before reading options RS-67445
  • Remove libraries not used by plugin RS-68297

See full list of changes on the download pages:

Open edition: RedDatabase 3.0.9

Standard edition: RedDatabase 3.0.9

Enterprise edition: RedDatabase 3.0.9

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 RED EXPERT 2021.10 HAS BEEN RELEASED

Leave a comment

New version of RedExpert 2021.10 is available

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

Changed:

  1. A name of constrained is generated immediately when the form is opened

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
  6. An update button for system tables

Download and install the new version.

New version of red expert 2021.07 has been released

Leave a comment

New version of RedExpert 2021.07 is available.

Corrections:

  1. Data type selection is implemented as a drop-down list
  2. While deleting the records marked for deletion are highlighted immediately
  3. Fixed the message about unsuccessful DDL operations
  4. Now it’s allowed to display unreadable characters in text blobs
  5. Fixed editing of the function
  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 not created by users were moved to the system packages branch
  13. Fixed connection to RedDatabase and Firebird versions 4+

Improvements:

  1. Now the database information is displayed by clicking the appropriate context menu item (not by selecting a database in the list)
  2. Significantly reduced time of loading scripts by reworking the syntax highlighting using ANTLR
  3. Autocompletion added to all textbars that use SQL
  4. Jump to database objects added to all text panels that use SQL
  5. Added “Users” node to the objects tree
  6. Added Jaybird4 driver

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.

New version of RedExpert 2020.08 has been released

Leave a comment

New version of RedExpert 2020.08 has been released.

The main changes:

  • the launch of the program and the search for Java have been completely redesigned. Now if Java is not found, it is suggested to specify the path manually or download Java automatically;
  • fixed display of system objects (generators, domains and functions that are not defined by the user are not displayed in the main nodes);
  • fixed execution of the script containing “execute block”;
  • fixed editing procedure with declare variables block;
  • removed the type of object while copying the name;
  • fixed display of tables if “RDB $ RELATION_TYPE IS NULL”;
  • fixed bugs with autoincrement while creating and editing tables;
  • other minor fixes.

Download and install the new version.

Django 2.2 driver for Firebird 3

Leave a comment

RED SOFT has added support of Firebird 3 into the Django 2.2 framework.

RED SOFT developer Vasily Yashkov made a pull request which recently has been accepted. Find details and main changes here.

The new version of the driver was successfully tested with Django 2.2.10/2.2.11 and Firebird 3/RedDatabase 3.

If you use Django with Firebird 2.5 or less please try to migrate your database to Firebird 3.0 and test new version of the driver. Now you can install it manually as described in the instruction but follow the news and wait the next release soon.

RedExpert: free open source tool for Firebird administration from RedSoft

Leave a comment

RedSoft, Platinum Sponsor of Firebird Foundation and contributor of Firebird Project development, has introduced the new major version of the free open-source multi-platform tool for administration and development of Firebird databases: RedExpert v2020.04.1.

The new version introduces:a test data generator, database object dependencies, and many other improvements and bug fixes.
Download here RedExpert installation and binaries.

Join RedExpert development
If you like RedExpert as a tool and as an idea of a free multi-platform high-quality tool for Firebird, and if you have experience as a Java developer or tester, or simply as advanced Firebird user, please join the development effort: RedExpert sources are available in GitHub, please submit your pull-requests there, and send your feedback, bug reports, suggestions, etc to Issues section on GitHub.

1 2