IBPhoenix is pleased to announce the release of FBLoader, a new command-line utility designed for blazing-fast import of CSV data into Firebird databases.
FBLoader makes it easy to move large volumes of data efficiently, whether you’re loading files from a local or remote system, handling multiple sources and tables in a single session, or taking advantage of automatic parallel loading for optimal performance. With flexible parameter options and full control over character sets and file access, FBLoader offers both speed and precision for demanding data migration tasks.
FBLoader is available now for 64-bit Windows and 64-bit Linux systems.
The September issue of EmberWings – has landed, and it’s ablaze with a thrilling Halloween theme! Dive into the eerie and exciting world of Firebird with our latest edition, packed with insights, surprises, and a touch of spooky charm.
Prepare to be captivated by a chilling exploration of “spooks” that might haunt Firebird users in The Little Shop of Horrors (Firebird Edition), alongside a deep dive into the power of Embedded Firebird. You’ll also find an exclusive conversation with a Firebird contributor shaping the database’s future, a review of a must-have Firebird-related tool, and a curated peek at the most intriguing questions and answers from Firebird’s public lists and forums. Stay updated with the latest advancements in Firebird development over the past quarter and catch the hottest news from the Firebird community. Plus, our ongoing story about the Secrets of Firebird takes a delightfully spooky twist, just in time for Halloween!
As always, delivered in a beautifully crafted, print-friendly PDF.
The latest issue is available only to all Firebird Associates and Firebird Partners. It will be available to the general public in December 2025.
Also, the June 2025 issue is now available to all readers.
Jaybird 5 supports Firebird 2.5, Firebird 3.0, Firebird 4.0, and Firebird 5.0, 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).
A principal conferência sobre o banco de dados Firebird em português está de volta e, desta vez, no conforto da sua casa!
De 6 a 10 de outubro, junte-se a nós para uma imersão profunda no universo do Firebird. O 22º Firebird Developers Day (FDD) será realizado excepcionalmente online, reunindo os maiores especialistas e entusiastas do SGBD para compartilhar conhecimento, novidades e as melhores práticas do mercado.
Se você é desenvolvedor, DBA, analista de sistemas ou simplesmente um apaixonado por tecnologia de banco de dados, este evento é para você!
🔥 Inscrições Abertas com Preço Especial!
Garanta sua vaga agora e aproveite o valor promocional de lançamento. • Apenas R$ 150,00 para inscrições realizadas até 5 de setembro. • Após essa data, o valor será de R$ 200,00.
Não deixe para a última hora! Inscreva-se já e economize!
🎮 Desafio Gamer: Desconto para os Mestres do AsteroidesDB!
Você é bom nos jogos arcade? Mostre sua habilidade e ganhe um desconto!
Alcance mais de 1.000 pontos no clássico AsteroidesDB e garanta 10% de desconto na sua inscrição. É a sua chance de unir diversão e conhecimento!
🚀 O que esperar do FDD 2025?
Prepare-se para uma semana de conteúdo denso e relevante com palestras que abordarão os temas mais importantes para quem trabalha com Firebird. Confira a grade de palestras confirmadas:
Levando o Firebird para a nuvem, com Carlos H. Cantu.
mcpFirebird: A Ponte entre a I.A. e seus dados no Firebird, com Jhonny Suárez.
Reforma tributária – da teoria ao técnico, com Elisabete Jussara Bach.
Monitoramento e performance na prática com MON$, com José Francisco Cervi Neto.
Progresso e análise de recursos do Firebird 6.0, com Dmitry Yemanov.
This bug has existed in the code base since InterBase 6 (or earlier.) and all versions of Firebird released prior to 5th May 2025 are affected.
The vulnerability allows remote unauthenticated users to cause a denial of service via a NULL pointer dereference and subsequent crash of the server.
A malicious user can cause a DoS attack on a Firebird server by sending a specific sequence of bytes. It is not necessary to be logged in to the server. To exploit the vulnerability, it is sufficient to have access to the Firebird port.
It should be noted that the Classic server architecture is less vulnerable, inasmuch as existing connections will remain active. However if the attack is sustained no new connections will be possible for the lifetime of the attack, no matter which architecture is used.
It is not known if a proof of concept has been developed. However, once the vulnerability is published one should expect rogue users to develop an attack. With increased access to AI based code generation models the bar to exploit development has been lowered considerably.
The Firebird Project has fixed this bug in the latest releases of all branches currently supported: 5.0.3, 4.0.6 and 3.0.13
While Firebird 2.5 is no longer supported by the Firebird project, it’s still supported by IBPhoenix!
We have produced a special build of Firebird 2.5.9 with this fix. There are no other changes to the source code for this build other than the fix itself. It is intended to be dropped in to an existing setup. Users can be confident that only minimal acceptance testing will be required.
You can get both 64-bit and 32-bit builds for Windows from our store for whatever price you see fair for our effort (including for free).
Fixed: Batch execution with multiple empty strings resulted in error “Repeated blob id 0:0 in registerBlob()” (#888)
Dependency update: updated org.bouncycastle:bcprov-jdk18on from 1.80 to 1.81 (used by chacha64-plugin) (#889)
Fixed: On Java 24, Connection.abort, Connection.setNetworkTimeout, and OperationMonitor.initOperationAware always throw “java.lang.SecurityException: checking permissions is not supported” (#890)
The following was fixed or changed in Jaybird 5.0.9:
Jaybird 5 supports Firebird 2.5, Firebird 3.0, Firebird 4.0, and Firebird 5.0, 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).
A study comparing Firebird 5 and PostgreSQL 17 reveals that the best choice for database storage efficiency depends on the specific data types and usage patterns.
Key Findings:
Character Data: Firebird demonstrates superior efficiency in storing character data types, particularly for larger field sizes.
Integer Data: PostgreSQL is more efficient when it comes to storing integer data.
Updates: When 25% of the rows were updated, Firebird’s database size increased by only 8%, while PostgreSQL’s grew by 25%. After updating 50% of the data, Firebird saw an additional 12% increase, while PostgreSQL’s size increased by another 26%.
Temporal Data: Both databases are comparable in storing simple temporal data. However, for data types that include time zones, PostgreSQL uses more space for time with time zones, but less for timestamps with time zones.
In conclusion, the study suggests that Firebird may be a more space-economical choice for databases with frequent updates to character-heaving data. PostgreSQL, on the other hand, offers better storage efficiency for integer-based data and certain temporal data types. The choice between the two will ultimately depend on the specific needs and data characteristics of the application.
Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:
“Database Workbench 6.8.0”
This release introduces support for Oracle 23 Domains, Vector and Boolean datatypes, JavaScript stored routines and more.
Other changes include support for PostgreSQL 17, MariaDB 11.7 and MySQL 9.2, bugfixes and small new features.
Database Workbench supports Firebird, MySQL, MariaDB, PostgreSQL, SQLite, Oracle, MS SQL Server, SQL Azure, NexusDB and InterBase.
It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools.
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.
About Database Workbench Database Workbench is a database developer tool, over 20 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work.
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.
