Category: Tools & Products releases

Announcements of new Firebird related products, or new releases.

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.

New issue of EmberWings magazine published

Leave a comment

EmberWings is a quarterly PDF magazine about Firebird published by IBPhoenix.

Beyond technical articles, instructions and tips, it contains interviews with noteworthy individuals, an overview of Firebird’s development, information from the Firebird community, evaluations of compelling products, and a touch of thematic humor. All of this presented in a streamlined format with an aesthetically pleasing print-friendly layout.

The magazine is available in IBPhoenix store for free on a pay-what-you-want basis, with half of the proceeds going to the Firebird Foundation. The remaining half is used to finance the publication of the magazine.

This issue has 70 pages.

Jaybird 5.0.5 released

Leave a comment

We are happy to announce the release of Jaybird 5.0.5.

The following has been fixed since Jaybird 5.0.4:

  • Fixed: FBResultSetMetaData.getPrecision would always estimate the precision of NUMERIC or DECIMAL columns instead of obtaining the actual precision if the column position was 71 or higher (#731)
  • Optimized the query to retrieve extended field info for ResultSetMetaData.getPrecision to only retrieve columns of type NUMERIC or DECIMAL (#732)
  • Fixed: PreparedStatement.executeBatch() of statement without parameters throws “Statement used in batch must have parameters [SQLState:07001, ISC error code:335545186]” on Firebird 4.0 or higher (#788)
  • New feature: ResultSetMetaData.isAutoIncrement(int) reports true for identity columns if Jaybird can identify the underlying table and column (#793)
  • New feature: Boolean connection property extendedMetadata (default true) to disable querying of extended metadata for getPrecision(int) and isAutoIncrement(int) of ResultSetMetaData (#795)
  • Improvement: The FILTER_CONDITION of DatabaseMetaData.getIndexInfo is populated for Firebird 5.0 partial indices (#797)
  • Fixed: ResultSet.isBeforeFirst() and ResultSet.isAfterLast() should always report false for an empty result set (#807)
  • Improvement: Statement.getResultSet no longer throws a SQLException with message “Only one result set at a time/statement” if the current result set has already been returned by executeQuery or a previous call to getResultSet (#762)
  • Improvement: Updated JNA dependency to version 5.14.0 (#810)

Jaybird 5 supports Firebird 2.5 and higher, on Java 8, 11, 17, 21, and 22 (support for Java 11 and higher using the Java 11 version of the driver).

See also:

Database Workbench 6.5.0 released

Leave a comment

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

” Database Workbench 6.5.0″

Changes in recent releases:

  • Firebird 5 support
  • MySQL 8.3 support
  • PostgreSQL 16.x support
  • SQLite module introduced for full SQLite support, read only support in Pro and Enterprise editions without this module

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

Firebird-Export

Leave a comment

Export a Firebird database to CSV, JSON or other formats is a Open Source project to export a Firebird database, show a summary of the database table names, field names, field data types, and index columns. Optionally extract and save table data to a directory, in CSV/JSON (or potentially in any other format), as well any other binary files from blobs.

A subset of the tables and fields can be specified (in python) and the number of records returned can be limited for testing purposes. Output data can be combined or into one or saved in individual files named after the tables.

Stored routine debugger Hopper, v2.3 released

Leave a comment

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

This release brings support for Firebird 5 and bugfixes.

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

HQbird 2024 is released

Leave a comment

We are glad to announce that HQbird version 2024 is released!
HQbird is advanced distribution of Firebird, with many improvements in the areas of performance, high availability, development, and more. It is intended for large enterprises and development companies with many Firebird installations, offering performance, protection from various threats, and mass maintenance.

Version 2024 introduces support of Firebird 5, and continue to support versions 4.0, 3.0, 2.5, with various improvements in the engine, high availability, tooling, and encryption.

HQbird is 100% compatible with Firebird, no need to perform backup/restore, you can install HQbird in trial mode in parallel with vanilla Firebird, and switch between instances.

The detailed list of HQbird features which improves Firebird can be found here, and below there are the biggest improvements of version HQbird 2024:

  1. Replacing queries “on the fly”
  2. Plugins for performing external connections with ODBC and MySQL
  3. Streaming/Change Data Capture with ready-to-use Kafka plugin, and plugin-building framework.
  4. Automation support to work with many databases on the server (for clients with SaaS model), with ability to create “replica server”
  5. Multi-instance support, which makes migration process from old Firebird versions much easier. HQbird 2024 is also integrated with Mass Migration Framework
  6. Automatic correction of firebird.conf configuration in case of erroneous configuration.

All features are described here.

HQbird v2024 has 2 licenses (click here to see purchasing options):

  • Per server, suitable for small and medium companies, US$899/server
  • Unlimited License, for large enterprises and software development companies, cost US$13465/year for unlimited number of installations.

Download HQbird v2024 here.

Customers with support contracts, subscriptions, or recent maintenance purchases (within the last 13 months), as well as customers who bought HQbird in the last 30 days, will get free upgrades in the next 10 days.

1 2 3 4 … 147