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 05, 2019
Jiri Cincura announces the 7.1.1.0 Release of ADO.NET provider for Firebird. This a small bug-fix release related to wire encryption on Linux.

Overview of all the changes can be found in tracker.

You can download them in the ".NET Provider" section of Downloads. Enjoy!
Jiri Cincura announces the 7.1.1.0 Release of ADO.NET provider for Firebird. This a small bug-fix release related to wire encryption on Linux.

Overview of all the changes can be found in tracker.

You can download them in the ".NET Provider" section of Downloads. Enjoy!
August 29, 2019
The workshop "All About Firebird Transactions" will take place on the 2nd day of the Firebird Conference 2019, the duration of the workshop will be 3 hours.
Workshop speakers
Vlad Khorsun Vlad Khorsun - Firebird core developer.
Dmitry Kuzmenko Dmitry Kuzmenko - lead developer and trainer at IBSurgeon.

Understanding transactions is crucial for every experienced Firebird developer to be able to create fast, scalable multi-user applications.

In this workshop, we will go through the basics of transactions and in-depth details of their implementation, and we will also consider the impact that transactions have on database performance.

The practical part of the workshop will include the demonstration of the debugging methods, investigation of deadlock reasons, and best practices for the various tasks.
 

Attention! Before the workshop: it is recommended to attend the presentation "New transactions' features in Firebird 4" at the Day 1, and read these introductory articles (1st, 2nd), as well as take a look on this presentation.

The detailed topics for the workshop "All About Firebird Transactions" are here.
The workshop "All About Firebird Transactions" will take place on the 2nd day of the Firebird Conference 2019, the duration of the workshop will be 3 hours.
Workshop speakers
Vlad Khorsun Vlad Khorsun - Firebird core developer.
Dmitry Kuzmenko Dmitry Kuzmenko - lead developer and trainer at IBSurgeon.

Understanding transactions is crucial for every experienced Firebird developer to be able to create fast, scalable multi-user applications.

In this workshop, we will go through the basics of transactions and in-depth details of their implementation, and we will also consider the impact that transactions have on database performance.

The practical part of the workshop will include the demonstration of the debugging methods, investigation of deadlock reasons, and best practices for the various tasks.
 

Attention! Before the workshop: it is recommended to attend the presentation "New transactions' features in Firebird 4" at the Day 1, and read these introductory articles (1st, 2nd), as well as take a look on this presentation.

The detailed topics for the workshop "All About Firebird Transactions" are here.
August 26, 2019
Firebird Conference 2019 will take place very soon: October 17-19! Today we start to publish announces of the interesting sessions, and the first announcement will be about sessions devoted to the big databases: 
 


Holger Klemt, IBExpert
Behind the scenes of a very big project
  • 180 replicated database server nodes, 1.1 billion records, 2.5 million new daily records, 350GB database size
  • Technologies we use: FB25, FB30, Windows, Linux, virtual machines
  • Hybrid Cloud Architecture, best of both worlds ...
  • Why not run everything in the cloud?
  • Hardware and Software we like to use
  • Synchronizing metadata and data for all these databases
  • How to process async multi-master replication requirements
  • Basics for database design

Roman Simakov, RedSoft
RedDatabase in the Enterprise: 3Tb database with 2000 connections with 99,9% availability

RedDatabase is an enterprise-ready database system. It is included in the list of software permitted to be used in Russian government systems and has a security certificate. There are a lot of installations in different types of information systems. This session will talk about several ones.
The flagship project of Red Soft which uses RedDatabase is the information system of the Federal Bailiff Service (FBS). One of the important tasks for the FBS system is the exchange of documents with other services such as banks. Availability of the database must be at least 99.9%. In this talk, we will describe the design of the applications and databases. You will see the solutions for real-world problems on real-world examples:

  • database size is 3 TB
  • the database has tables with 12 columns and contains up to 1.5 billion records.
  • every day about 3 million new records are inserted or updated
  • each table has a foreign key with BIGINT data type. A query with search by this key takes less than 100 ms.
  • about 2000 clients concurrently use the database.
We will also describe several other solutions as well.

Alexey Kovyazin, IBSurgeon
Tuning Linux and Firebird for 660Gb database and 1500 connections

The session will be devoted to the practical steps which were taken to optimize several real-world high-load systems, with databases size up to 660Gb and 1500 users in peak, running on Linux.

We will also discuss the hardware choice and problems, related to Virtual Machines, popular mistakes in the setup of the high-performance system, reasons for various Firebird mistakes, and the logic behind the OS and firebird.conf settings.
As a final step, we will present the check-list for building the high-performance system with Linux and Firebird.

Don't miss Firebird Conference 2019 in Berlin (Oct 17-19)!

 

Firebird Conference 2019 will take place very soon: October 17-19! Today we start to publish announces of the interesting sessions, and the first announcement will be about sessions devoted to the big databases: 
 


Holger Klemt, IBExpert
Behind the scenes of a very big project
  • 180 replicated database server nodes, 1.1 billion records, 2.5 million new daily records, 350GB database size
  • Technologies we use: FB25, FB30, Windows, Linux, virtual machines
  • Hybrid Cloud Architecture, best of both worlds ...
  • Why not run everything in the cloud?
  • Hardware and Software we like to use
  • Synchronizing metadata and data for all these databases
  • How to process async multi-master replication requirements
  • Basics for database design

Roman Simakov, RedSoft
RedDatabase in the Enterprise: 3Tb database with 2000 connections with 99,9% availability

RedDatabase is an enterprise-ready database system. It is included in the list of software permitted to be used in Russian government systems and has a security certificate. There are a lot of installations in different types of information systems. This session will talk about several ones.
The flagship project of Red Soft which uses RedDatabase is the information system of the Federal Bailiff Service (FBS). One of the important tasks for the FBS system is the exchange of documents with other services such as banks. Availability of the database must be at least 99.9%. In this talk, we will describe the design of the applications and databases. You will see the solutions for real-world problems on real-world examples:

  • database size is 3 TB
  • the database has tables with 12 columns and contains up to 1.5 billion records.
  • every day about 3 million new records are inserted or updated
  • each table has a foreign key with BIGINT data type. A query with search by this key takes less than 100 ms.
  • about 2000 clients concurrently use the database.
We will also describe several other solutions as well.

Alexey Kovyazin, IBSurgeon
Tuning Linux and Firebird for 660Gb database and 1500 connections

The session will be devoted to the practical steps which were taken to optimize several real-world high-load systems, with databases size up to 660Gb and 1500 users in peak, running on Linux.

We will also discuss the hardware choice and problems, related to Virtual Machines, popular mistakes in the setup of the high-performance system, reasons for various Firebird mistakes, and the logic behind the OS and firebird.conf settings.
As a final step, we will present the check-list for building the high-performance system with Linux and Firebird.

Don't miss Firebird Conference 2019 in Berlin (Oct 17-19)!

 

May 25, 2019