21st FDD – for Portuguese speakers outside Brazil

Se você fala português, não está no Brasil, e gostaria de participar do 21º Firebird Developers Day, que será realizado on-line de 7 a 11 de outubro, temos um link exclusivo para você se inscrever!

Será uma palestra por noite, iniciando às 20h (GMT -3), mas não se preocupe, se esse horário é muito tarde para você, as palestras ficarão gravadas e poderão ser assistidas a partir de 21/outubro, mas somente para quem estiver inscrito no evento.

Vale lembrar também que somente os participantes poderão comprar o IBExpert e o uniGUI com os menores preços do ano (confira os valores no FAQ do site do evento). Só o que se economiza com os descontos já faz valer a inscrição 😉

Veja os temas das palestras:

  • Entendendo os PLANos do otimizador (Dmitry Yemanov)
  • I.A. + Firebird – Estratégias e Ferramentas Inovadoras (Carlos E. Paulino)
  • Atualizando a metadata do BD com sua aplicação (Carlos H. Cantu)
  • O que você está perdendo por não migrar para o Firebird 5 (Carlos H. Cantu)
  • Validando o servidor através de benchmarks (Marcelo Daibert)

Para se inscrever, clique aqui , mas atenção: o link funcionará somente até o dia 01/outubro, então inscreva-se agora mesmo! É importante que informe durante a compra o mesmo email com o qual está cadastrado na firebase.com.br , para que possamos identificá-lo na nossa base de dados e efetuar sua inscrição.

New Issue of EmberWings Magazine on Firebird Released

EmberWings is a quarterly, free PDF magazine about Firebird.

In addition to technical articles, guides, and tips, it features interviews with noteworthy individuals, updates on Firebird’s development, community news, reviews of interesting products, and a touch of thematic humor. All of this presented in a streamlined format with an aesthetically pleasing print-friendly layout.

You can access all three issues directly on the IBPhoenix website.

Firebird ODBC driver v3.0

Firebird Project is glad to announce the general availability of Firebird ODBC driver version 3.0. New driver is build on top the new Firebird client API, and can work with Firebird clients from versions 3.0, 4.0, and 5.0.

Download new driver binaries and sources from Firebird ODBC Github (and don’t forget to give a star to the project)!

This version is a rework of v2 to implement modern Firebird Object-Oriented API inside an ODBC driver. In addition it contains a fixpack for many known issues, see ChangeLog_v3.0 for details.

Please note that v3.0 driver is intended to work only with Firebird clients from version 3.0 and later (i.e., 3.0, 4.0, 5.0 at the moment). If you have fbclient.dll from 2.5 or some older version, it is incompatible.

You can see more details here: https://github.com/FirebirdSQL/firebird-odbc-driver/wiki

Please report all issues to https://github.com/FirebirdSQL/firebird-odbc-driver/issues

Source: https://html-preview.github.io/?url=https://github.com/FirebirdSQL/firebird-odbc-driver/blob/master/Install/ReleaseNotes_v3.0.html

Esquenta FDD (FDD Warm-up)

Sorry, this is only for Portuguese speakers…

No dia 26/setembro (quinta-feira) às 10h (GMT-3 – horário de Brasília) estaremos realizando o Esquenta FDD, com a apresentação de 2 estudos de caso de sucesso envolvendo o Firebird.

O Esquenta é gratuito e aberto a todos que quiserem participar, bastando se cadastrar usando esse link e entrar na data e hora programadas.

Aproveite e se inscreva também no 21º Firebird Developers Day, que será realizado on-line, de 7 a 11 de outubro. As inscrições se encerram dia 27/setembro.

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

IBX 2.7.0 for Lazarus is now available for download

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

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

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.

1 2