Year: 2025

Article: Data access methods used in Firebird

Leave a comment

From firebirdsql.org:

Don’t be fooled with the title! This is not just another article. 

“Data access methods used in Firebird” is a foundation document (88 pages!) for anyone serious about Firebird queries’ performance. Just like important books that change how we think about technology, this article will change how you work with Firebird queries.

Created by author of Firebird documentation Denis Simonov and Firebird engine developer Dmitry Yemanov, this article explains complex concepts of Firebird optimization in clear language, with numerous examples and visual execution plans.

This document provides an unprecedented look at Firebird’s query processing engine, covering:

  • Primary data access methods – How Firebird reads tables, uses indexes, and processes data
  • Filtering techniques – The various ways Firebird filters data streams
  • Joining algorithms – Detailed explanations of Nested Loop, Hash, and Merge joins
  • Advanced optimization strategies – How Firebird decides the most efficient execution plan

Who Should Read This

  • Firebird Database Administrators
  • Advanced SQL developers
  • Anyone who wants to make their Firebird databases run better

This knowledge is so important that we will use it as the basis for our Advanced Certification Exam for Firebird SQL developers. 

Read article here  (also available as PDF version).

Introducing mcpFirebird: A Model Context Protocol Project for Firebird

Leave a comment

Great news for the Firebird community! A new project, mcpFirebird, has been launched and is now available on GitHub at https://github.com/PuroDelphi/mcpFirebird. What makes this release particularly interesting is that mcpFirebird is built as a Model Context Protocol (MCP) project, bringing a structured approach to working with Firebird databases.

For those unfamiliar, the Model Context Protocol is a framework designed to streamline interactions between applications AI and databases like Firebird. With mcpFirebird, this concept is put into action, offering a tool that could simplify development tasks while staying true to the strengths of the Firebird engine.

Blob speed improvements are coming sooner than expected!

Leave a comment

Great news for the Firebird community!

Thanks to several of the participants of the 21st Firebird Developers Day (FDD), significant improvements have been made to blob traffic performance, especially in high-latency network environments. These enhancements were implemented by Vlad Khorsun in two phases.

The first phase, already released in Firebird 5.02, delivered remarkable performance gains of up to 49%!

The second phase, delivering up to 97% gains, was originally scheduled for Firebird 6, but it is coming much sooner, in the upcoming Firebird 5.03!

And you will not need to pay anything extra for this, since Firebird is 100% free!

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
1 2 3