Month: September 2024

PHP 8.4 Improvements when working with modern Firebird versions

Leave a comment

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

IBX 2.7.0 for Lazarus is now available for download

Leave a comment

MWA Software is pleased to announce the release of version 2.7.0 of IBX for Lazarus. This is primarily a maintenance release but does contain some important future proofing. All users are recommended to upgrade to this version.

In this release:

  • Firebird 5 compatibility checked
  • Lazarus 3.4 compatibility checked
  • Internal changes necessary to correctly function with FPC 3.3.1 (development version) and later.
  • Dynamic Database Controls Direct Dependency on IBX  removed and replaced with corba interfaces.
  • Various bug fixes – see changelogs of IBX and the Firebird Pascal Interface for details.

The changes to the Dynamic Database Controls are intended to enable their use with database drivers other than IBX. Other developers are encourage to support the corba interfaces defined in their support so that their full functionality is available generally. See the new document “DynamicDatabaseControls.pdf” for further information.

https://www.mwasoftware.co.uk/ibx

21st Firebird Developers Day

Leave a comment

The official website for the 21st FDD, the largest Firebird event in the world, is now live! The Firebird Developers Day has been held annually in Brazil for 21 consecutive years.

This year, the conference will exceptionally take place online, from October 7th to 11th.

Registrations are now open!

PS: This is a Brazilian conference, so the sessions are in Portuguese.

RED EXPERT 2024.09 HAS BEEN RELEASED

Leave a 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.