Join Firebird!

Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses

Follow Us

Select your media preference

Newsletter

Subscribe to Firebird’s Newsletter to receive the latest news

News & Events
September 12, 2016
The full schedule for Firebird Conference 2016 is available! 2 full days of in-depth Firebird learning and networking with true Firebird experts and core Firebird developers! Book your attendance now - registration fee is EUR 179, and only EUR 489 for group of 3!

Featured speaker: Jason Wharton, IBObjects
Optimizing queries and transactions
This session will demonstrate how to make effective use of queries and transactions so that your application has reliable record locking as well as smooth performance. There are some potential traps developers can fall into that I will identify and help you avoid.

This session will provide a good overview of the various approaches to interacting with your database. Direct transaction control, cached updates and multi-tier approaches will be discussed. I will also address proper use of generators/sequences and show how to provide an auditable sequence that is multi-user friendly.

The full schedule for Firebird Conference 2016 is available! 2 full days of in-depth Firebird learning and networking with true Firebird experts and core Firebird developers! Book your attendance now - registration fee is EUR 179, and only EUR 489 for group of 3!

Featured speaker: Jason Wharton, IBObjects
Optimizing queries and transactions
This session will demonstrate how to make effective use of queries and transactions so that your application has reliable record locking as well as smooth performance. There are some potential traps developers can fall into that I will identify and help you avoid.

This session will provide a good overview of the various approaches to interacting with your database. Direct transaction control, cached updates and multi-tier approaches will be discussed. I will also address proper use of generators/sequences and show how to provide an auditable sequence that is multi-user friendly.

September 02, 2016
How to integrate Firebird into the corporate security infrastructure, how to make data in Firebird databases more secure - the sessions from Alex Peshkoff, Firebird Core developer, will be devoted to these (always hot) topics at Firebird Conference 2016.

Encrypting Firebird databases, by Alex Peshkoff, Firebird Core Development
The session describes the problems and solutions for database encryption inside the enterprise and for distributed applications. 
What should be protected on the plugin level, what should be protected at the operating system level (parameters to be set/tuned), where security keys should be stored, etc.

Implementing safe authorisation infrastructure for Firebird, by Alex Peshkoff, Firebird Core Development
How to use different authorization plugins, several security databases, how to define and implement data transfer between databases governed by different security databases, and how to use the TraceAPI and the Services API in such an environment.
How to integrate Firebird into the corporate security infrastructure, how to make data in Firebird databases more secure - the sessions from Alex Peshkoff, Firebird Core developer, will be devoted to these (always hot) topics at Firebird Conference 2016.

Encrypting Firebird databases, by Alex Peshkoff, Firebird Core Development
The session describes the problems and solutions for database encryption inside the enterprise and for distributed applications. 
What should be protected on the plugin level, what should be protected at the operating system level (parameters to be set/tuned), where security keys should be stored, etc.

Implementing safe authorisation infrastructure for Firebird, by Alex Peshkoff, Firebird Core Development
How to use different authorization plugins, several security databases, how to define and implement data transfer between databases governed by different security databases, and how to use the TraceAPI and the Services API in such an environment.
August 30, 2016
The year will be the strong section inside Firebird Conference devoted to Firebird performance. The talks announced below will be devoted to the most popular questions regarding Firebird performance.

Firebird and disk I/O, Dmitry Yemanov, lead Firebird developer
Disk access is the most expensive operation in any database and RDBMS vendors use a lot of tricks to get most of this area. Providing durability ("D" in ACID) is especially important as it introduces an obvious conflict between reliability and performance. This session describes various durability aspects at three different levels — Firebird, operating system and storage hardware — and explains how they interact with each other, what tuning options are effective and how to balance between them. We'll talk about forced writes, OS-level caching, journaling, filesystem barriers, etc.

Diagnosing and fixing Firebird performance problems, by Alexey Kovyazin, IBSurgeon
The question «how to find and eliminate performance problems in Firebird» is important for all database developers.  Firebird offers the number of tools and APIs to answer the question: transaction markers, MON$ tables, TraceAPI, databases and queries performance statistics, and this session will describe how to find the exact reason of slowness in the particular database. We will consider the practical examples of problems and appropriate fixes, based on real-life logs from the production Firebird databases.

Firebird performance comparisons, by Paul Reeves, IBPhoenix
This session will provide performance comparisons between Firebird 3 and Firebird 2.5 using a test harness based upon TPC-C. The data is derived from hours of testing covering different hardware and software configurations taking into consideration things like Server Architecture, Memory, Database size, HDD/SSD etc This should enable us to build a full picture of the impact of how a single configuration change can affect overall performance. Some of the questions this session will answer: does the improved multi-threading in Firebird 3 bring benefits under heavy load? Is SuperClassic still relevant? What is the penalty for using network compression and encryption? Does database encryption sacrifice speed for security?

More performance sessions will be announced in the next weeks too... But there is only 1 day left to register for Firebird Conference 2016 with the Early Bird discount. Hurry up and register today!
The year will be the strong section inside Firebird Conference devoted to Firebird performance. The talks announced below will be devoted to the most popular questions regarding Firebird performance.

Firebird and disk I/O, Dmitry Yemanov, lead Firebird developer
Disk access is the most expensive operation in any database and RDBMS vendors use a lot of tricks to get most of this area. Providing durability ("D" in ACID) is especially important as it introduces an obvious conflict between reliability and performance. This session describes various durability aspects at three different levels — Firebird, operating system and storage hardware — and explains how they interact with each other, what tuning options are effective and how to balance between them. We'll talk about forced writes, OS-level caching, journaling, filesystem barriers, etc.

Diagnosing and fixing Firebird performance problems, by Alexey Kovyazin, IBSurgeon
The question «how to find and eliminate performance problems in Firebird» is important for all database developers.  Firebird offers the number of tools and APIs to answer the question: transaction markers, MON$ tables, TraceAPI, databases and queries performance statistics, and this session will describe how to find the exact reason of slowness in the particular database. We will consider the practical examples of problems and appropriate fixes, based on real-life logs from the production Firebird databases.

Firebird performance comparisons, by Paul Reeves, IBPhoenix
This session will provide performance comparisons between Firebird 3 and Firebird 2.5 using a test harness based upon TPC-C. The data is derived from hours of testing covering different hardware and software configurations taking into consideration things like Server Architecture, Memory, Database size, HDD/SSD etc This should enable us to build a full picture of the impact of how a single configuration change can affect overall performance. Some of the questions this session will answer: does the improved multi-threading in Firebird 3 bring benefits under heavy load? Is SuperClassic still relevant? What is the penalty for using network compression and encryption? Does database encryption sacrifice speed for security?

More performance sessions will be announced in the next weeks too... But there is only 1 day left to register for Firebird Conference 2016 with the Early Bird discount. Hurry up and register today!
August 07, 2016