NEW VERSION OF RED EXPERT 2021.10 HAS BEEN RELEASED

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

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 Firebird Encryption Plugin Framework

IBSurgeon releases a new version of Firebird Encryption Plugin Framework: the set of source files and ready-to-use compiled binaries to implement database encryption for Firebird databases.

Main features of Firebird Encryption Plugin Framework (version 2021):

1. Support of Firebird 4.0 and Firebird 3.0 out of the box, on Windows 32bit/64bit and Linux 32bit/64bit. The new version is ready to use with Firebird 4.0 without recompilation (but databases must be migrated, of course)

2. Client-side KeyHolder support. Now, fbclient.dll can load keys from KeyHolder.conf on the client-side, it allows the transparent and safe connection of developer tools, Firebird command-line tools. and other applications without key exchange support.

3. Included low-level tool for decryption of databases in case of corruption and (new in v2021) license of FirstAID recovery tool for 10 databases.

4. Gbak.exe supports encrypted backup and restore.

5. Client application examples are available for Delphi, Lazarus, PHP, .Net, Java, etc.

6. Now 2 licenses are available:
a) Unlimited license with sources, it includes upgrades for all minor releases of Firebird 4.0.x – USD$1999 (EUR 1655)
b) Unlimited license with sources and implementation consulting for 1 application, includes upgrades for all minor releases of Firebird 4.0.x – USD$2499(EUR 2055)

All existing customers of Firebird Encryption Framework Unlimited License will receive this major upgrade for free!

Download the demo version of Firebird Encryption to try it with your application!

Load testing of IBProvider v5.21.1 and Firebird v3.0.7

Hello All.

We have good news for everyone who uses IBProvider in critical and complex systems.

A «large», multithreaded, load testing of the latest release of IBProvider v5.21.1 and Firebird v3.0.7 (SS, Win, x64) has been carried out.

This is more than 7 million tests that were performed on a 10-core processor.

The main point of this testing was that the global cache of the SQL query parser was used (sql_cache__scope=db).

As usual, the built-in client for Firebird (dbclient_type=fb.direct) was used.

Testing completed with no visible problems.

See additional info at our web site: https://www.ibprovider.com/eng/news/n_201225.html

Best regards, IBProvider Team.

New version of RedExpert 2020.10 has been released

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

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.

RedExpert: free open source tool for Firebird administration from RedSoft

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.

Stored routine debugger Hopper, v2.1 released

Upscene Productions is proud to announce version 2.1 of “Hopper”, a stored
routine debugger for InterBase, Firebird or MySQL.

This release brings new features for the MySQL Edition and bugfixes to the InterBase or Firebird Edition.

Version 2 includes support for Firebird 3 packages and stored functions, MySQL diagnostic-statements, binary data in variables and much more.

For more information, check the Hopper page at our website.

About Hopper
Hopper is a stored routine debugging tool for MySQL, Firebird and InterBase. If you use
stored procedures on these database systems, Hopper will be a great tool for debugging
these routines.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been providing
database developers with useful tools for over 18 years. Slowly expanding the product portfolio
and gaining recognition amongst InterBase and Firebird database developers, they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL Server.

Upscene releases Database Workbench 5.7.0

Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:

” Database Workbench 5.7.0″

This new release brings you PostgreSQL 12 support and fixes to the Firebird and MySQL modules.

Database Workbench 5 comes in multiple editions with different pricing models, there’s always a version that suits you!

1 2 3 4 5 18