Category: Tools & Products releases

Announcements of new Firebird related products, or new releases.

Free Database Workbench Lite 6.7.0 now available

Leave a comment

Upscene Productions is proud to announce the availability of a free feature limited version of Database Workbench 6.7.0 Lite Edition, for personal non-commercial use. Download it here. There’s a version for Firebird and a version for MySQL.

For details on the feature differences between editions, see this feature matrix.

“Database Workbench is used by thousands of developers around the world, we’re making it available to hobbyists too”, says Martijn Tonies, founder of Upscene Productions. “Everyone can now use the free Lite Edition for personal non-commercial use.”

Database Workbench Basic and up support MySQL, MariaDB, Firebird, Oracle, SQL Server, PostgreSQL, NexusDB, SQLite and InterBase, comes in multiple editions and is licensed based on selectable modules.

It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools.

RED EXPERT 2025.06 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.06 is available.

What’s new?

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

Added:

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

Fixed:

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

Download and install the new version.

RED EXPERT 2025.05 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.05 is available.

What’s new?

Added:

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

Fixed:

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

Download and install the new version.

Jaybird 6.0.2 and Jaybird 5.0.8 released

Leave a comment

We are happy to announce the release of Jaybird 6.0.2 and Jaybird 5.0.8. Both releases provide support for upcoming Firebird 5.0.3 inline blobs, and some other improvements.

For more information on inline blobs, for Firebird 5.0.3 and higher, see also New Article: Data access methods used in Firebird.

Changes

The following was fixed or changed since Jaybird 6.0.1 / Jaybird 5.0.7:

  • Improvement: added authPlugins property on FBManager (#866 / #865)
  • Improvement: increased default and maximum SQL info sizes used for retrieving statement information like columns, parameters and plan information (#869 / #868)
  • Improvement: backported inline blob support (Firebird 5.0.3 and higher) from Jaybird 7 (#870 / #871)
  • Improvement: The time zone mapping was updated (#874 / #875)

Bug reports about undocumented changes in behavior are appreciated. Feedback can be sent to Firebird-java or reported on the issue tracker https://github.com/FirebirdSQL/jaybird/issues.

Jaybird 6.0.2

Jaybird 6 supports Firebird 3.0 and higher, on Java 17, Java 21, and Java 24.

See also:

Jaybird 5.0.8

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

See also:

RED EXPERT 2025.04 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.04 is available.

What’s new?

Added:

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

Fixed:

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

Download and install the new version.

Database Workbench 6.7.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.7.0″

We recently added SQLite support, this release adds support for viewing vector embeddings in PostgreSQL, adds new functionality to create foreign key constraints even faster and fixes bugs in the Firebird, SQLite and InterBase modules.

    Database Workbench 6 comes in 3 different editions with different pricing models, there’s always a version that suits you! There’s also free Lite Editions available for Firebird and MySQL.

    Jaybird 6.0.1 and Jaybird 5.0.7 released

    Leave a comment

    We are happy to announce the release of Jaybird 6.0.1 and Jaybird 5.0.7. Both releases provide a number of performance improvements to blob handling, and some bug fixes.

    We plan to offer more blob performance improvements in upcoming releases of Jaybird 5 and 6, for Firebird 5.0.3 and higher (see also New Article: Data access methods used in Firebird).

    Jaybird 6.0.1

    The following was fixed or changed since Jaybird 6.0.0:

    • Improvement: backported deferred blob open optimization from Jaybird 7 (#842)
    • Fixed: NullPointerException in getGeneratedKeys() with blob columns after (auto)commit (#846)
    • Fixed: Fetch response with status=0 (FETCH_OK) and count=0 was logged on DEBUG as an unexpected response (#848)
    • Improvement: backported fetching all known blob info items on open from Jaybird 7 (#852)
    • Dependency update: updated net.java.dev.jna:jna-jpms from 5.16.0 to 5.17.0 (used by jaybird-native) (#854)
    • Dependency update: updated org.bouncycastle:bcprov-jdk18on from 1.79 to 1.80 (used by chacha64-plugin) (#856)

    Jaybird 6 supports Firebird 3.0 and higher, on Java 17, Java 21, and Java 24.

    Bug reports about undocumented changes in behavior are appreciated. Feedback can be sent to Firebird-java or reported on the issue tracker https://github.com/FirebirdSQL/jaybird/issues.

    See also:

    Jaybird 5.0.7

    The following has been changed or fixed since Jaybird 5.0.6:

    • Improvement: backported deferred blob open optimization from Jaybird 7 (#841)
    • Fixed: NullPointerException in getGeneratedKeys() with blob columns after (auto)commit (#846)
    • Fixed: Fetch response with status=0 (FETCH_OK) and count=0 was logged on DEBUG as an unexpected response (#848)
    • Improvement: backported performance improvements for blob reading and writing from Jaybird 6 (#850)
    • Improvement: backported fetching all known blob info items on open from Jaybird 7 (#852)
    • Dependency update: updated net.java.dev.jna:jna-jpms from 5.15.0 to 5.17.0 (used by native and embedded protocols) (#855)

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

    Bug reports about undocumented changes in behavior are appreciated. Feedback can be sent to Firebird-java or reported on the issue tracker https://github.com/FirebirdSQL/jaybird/issues.

    See also:

    New release of Advanced Data Generator

    Leave a comment

    Upscene Productions is happy to announce the next version of their test data generator tool:

    “Advanced Data Generator 4.2.0”

    A fast test-data generator tool that comes with a library of real-life data, can generate data to your database,
    script or data files, many filling options, templates and much more.

    Data settings
    Generate JSON data files
    Sample generated data

    Free Database Workbench Lite edition available!

    Leave a comment

    Upscene Productions is proud to announce the availability of a free feature limited version of Database Workbench, the Lite Edition, for personal non-commercial use. Download it here. There’s a version for Firebird and a version for MySQL.

    For details on the feature differences between editions, see this feature matrix.

    “Database Workbench is used by thousands of developers around the world, we’re making it available to hobbyists too”, says Martijn Tonies, founder of Upscene Productions. “Everyone can now use the free Lite Edition for personal non-commercial use.”

    Database Workbench Basic and up support MySQL, MariaDB, Firebird, Oracle, SQL Server, PostgreSQL, NexusDB, SQLite and InterBase, comes in multiple editions and is licensed based on selectable modules.

    It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools.

    RED EXPERT 2025.01 HAS BEEN RELEASED

    Leave a comment

    You can join to the Telegram chat for discussion.

    New version of Red Expert 2025.01 is available.

    What’s new?

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

    Improved:

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

    Fixed:

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

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

    Download and install the new version.

    1 2 3 4 … 149