Database Workbench 6.6.0 released

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

” Database Workbench 6.6.0″

We recently added SQLite support, this release adds support for Windows on ARM64 and full support for MySQL 9, MariaDB 11.3 & 11.4, as well as other new features, improvements and bugfixes.

Mind you: there’s a 50% discount on all Upscene products this month, visit the website for more information.

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

    RED EXPERT 2024.11 HAS BEEN RELEASED

    You can join to the Telegram chat for discussion.

    New version of Red Expert 2024.11 is available.

    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.

    Download and install the new version.

    Jaybird 6.0.0-beta-1 available for testing

    Jaybird 6.0.0-beta-1 is now available for testing. You can download the distribution zip from Jaybird 6.0.0-beta-1 (GitHub).

    IMPORTANT

    This version is provided for testing purposes only. We’d appreciate your feedback, but we’d like to emphasize that this version is not intended for production.

    What’s new

    The major changes and new features in Jaybird 6 are:

    Upgrading from Jaybird 5 should be straightforward, but please make sure to read Compatibility changes before using Jaybird 6. If you’re using Jaybird with the native or embedded connections, you will need to make some additional changes. See also Upgrading from Jaybird 5 to Jaybird 6.

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

    See also the full Jaybird 6.0.0-beta-1 release notes.

    Maven

    The release is also available on Maven:

    groupId: org.firebirdsql.jdbc
    artifactId: jaybird
    version: 6.0.0-beta-1

    If you use the native or embedded protocol, you need to add the jaybird-native dependency:

    groupId: org.firebirdsql.jdbc
    artifactId: jaybird-native
    version: 6.0.0-beta-1

    For ChaCha64 wire encryption support, add the chacha64-plugin dependency:

    groupId: org.firebirdsql.jdbc
    artifactId: chacha64-plugin
    version: 6.0.0-beta-1

    Jaybird 5.0.6 released

    We are happy to announce the release of Jaybird 5.0.6.

    The following has been fixed since Jaybird 5.0.5:

    • Fixed: Exceptions during statement execution did not always complete the statement, which could delay transaction commit in auto-commit mode (#806)
    • Fixed: Closing a connection when the database was shutdown, or the connection was otherwise broken, could result in a NullPointerException (#812)
    • Fixed: Error “Column unknown; IND.RDB$CONDITION_SOURCE” when calling DatabaseMetaData.getIndexInfo on Firebird 5.0 with a Firebird 4.0 (ODS 13.0) database (#813)
    • Fixed: Calling ResultSet.wasNull() when on the insert-row throws a SQLException instead of reporting the null-state of the last retrieved column (#816)
    • Fixed: Inserting a row into a result set backed by a server-side scrollable cursor could include the inserted row twice (#819)
    • Improvement: Updated JNA dependency to version 5.15.0 (#823)

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

    See also:

    PHP 8.4 Improvements when working with modern Firebird versions

    From firebirdsql.org:

    PHP 8.4 beta 5 has been released, marking a significant milestone for PHP developers, particularly those working with Firebird databases. This update brings crucial enhancements to the built-in PDO-Firebird driver. Now supporting modern data types, including DECFLOAT, the driver offers substantial benefits for PHP applications using Firebird 4 and 5.

    This improved Firebird support in standard PHP will streamline development of Firebird-based PHP applications, making the process more straightforward and transparent. For an in-depth look at these enhancements, check out the new article “PHP 8.4 Improvements when working with modern Firebird versions“.

    RED EXPERT 2024.09 HAS BEEN RELEASED

    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

    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

    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.

    1 2 3 147