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
October 07, 2014
Today's guest is Carlos Cantu (Firebase.com.br), speaker at Firebird Conference 2014.

— Carlos, why do you think people will be interested most of all in your talk?

My talk about Data Auditing logs is based in a solution that I have been using in the last 6 years, in my own ERP. It was created because from time to time I got contacted by customers saying that some information simply disappeared from the database, or got modified without nobody editing it, suggesting that the software had some bug <g>. With auditing logs, it became really easy to show/prove to customer what really happened, allowing you to keep a history of everything that was done inside the DB. The other talk is about Numerics in Firebird. Due to the several different datatypes available for storing numbers in Firebird, each one with different characteristics/behaviors, it is not rare that developers get lost about its differences and what would be the best type for a specific requirement. This talk will try to answer those questions, as well show some tips, tricks and side-effects that sometimes are unknown by the developer, showing also the actual rules used in the math involving numeric/decimal types.

— What do you like most of all in Firebird? and What is your most favourite feature/improvement in Firebird 3?

I use Firebird since its first release, and what I really enjoy about it is the fact that it is small, easy to install and configure, very stable, has low maintenance and, of course, it is totally free! Firebird 3 is long awaited for its improvements related to extracting all the potential of SMP machines, even when shared cache is being used. Of course, this feature is a must in the currently world where SMP machines became the standard configuration for servers. But FB 3 also brings very nice features, and I really enjoy the fact that now we can encrypt the database file and the wired communication, and the wire protocol was improved allowing better performance in high latency networks (internet).
Today's guest is Carlos Cantu (Firebase.com.br), speaker at Firebird Conference 2014.

— Carlos, why do you think people will be interested most of all in your talk?

My talk about Data Auditing logs is based in a solution that I have been using in the last 6 years, in my own ERP. It was created because from time to time I got contacted by customers saying that some information simply disappeared from the database, or got modified without nobody editing it, suggesting that the software had some bug <g>. With auditing logs, it became really easy to show/prove to customer what really happened, allowing you to keep a history of everything that was done inside the DB. The other talk is about Numerics in Firebird. Due to the several different datatypes available for storing numbers in Firebird, each one with different characteristics/behaviors, it is not rare that developers get lost about its differences and what would be the best type for a specific requirement. This talk will try to answer those questions, as well show some tips, tricks and side-effects that sometimes are unknown by the developer, showing also the actual rules used in the math involving numeric/decimal types.

— What do you like most of all in Firebird? and What is your most favourite feature/improvement in Firebird 3?

I use Firebird since its first release, and what I really enjoy about it is the fact that it is small, easy to install and configure, very stable, has low maintenance and, of course, it is totally free! Firebird 3 is long awaited for its improvements related to extracting all the potential of SMP machines, even when shared cache is being used. Of course, this feature is a must in the currently world where SMP machines became the standard configuration for servers. But FB 3 also brings very nice features, and I really enjoy the fact that now we can encrypt the database file and the wired communication, and the wire protocol was improved allowing better performance in high latency networks (internet).
October 03, 2014
Today's guest is Mark Rotteveel, developer of JayBird, Firebird JDBC driver, and speaker at Firebird Conference 2014.

— Mark, why do you think people will be interested most of all in your presentation/talk?
 
— I have two talks scheduled. My first talk is about the current state of development of Jaybird, and the changes implemented (and to be implemented) for Jaybird 3.0. I think this is interesting for people who use Jaybird and want to know more about the upcoming changes. My second talk is about using Hibernate and jOOQ to query a Firebird database from Java without having to deal with the low-level JDBC operations. Hibernate is a ORM mapper, while jOOQ is — besides a (light-weight) ORM mapper — a Domain Specific Language (DSL) library for building queries with compile time checks. Both are also useful to bridge dialect differences between various databases.
Although introductory, I think this is interesting for application developers, even when their target platform isn't Java.
 
— What do you like most of all in Firebird? And what is your most  favourite feature/improvement in Firebird 3?
 
I think the key thing about Firebird is its simplicity and small footprint, install it and you are — basically — good to go. I think my favorite new feature in Firebird 3 are the window functions. They provide much needed extensions for analytical queries.
Today's guest is Mark Rotteveel, developer of JayBird, Firebird JDBC driver, and speaker at Firebird Conference 2014.

— Mark, why do you think people will be interested most of all in your presentation/talk?
 
— I have two talks scheduled. My first talk is about the current state of development of Jaybird, and the changes implemented (and to be implemented) for Jaybird 3.0. I think this is interesting for people who use Jaybird and want to know more about the upcoming changes. My second talk is about using Hibernate and jOOQ to query a Firebird database from Java without having to deal with the low-level JDBC operations. Hibernate is a ORM mapper, while jOOQ is — besides a (light-weight) ORM mapper — a Domain Specific Language (DSL) library for building queries with compile time checks. Both are also useful to bridge dialect differences between various databases.
Although introductory, I think this is interesting for application developers, even when their target platform isn't Java.
 
— What do you like most of all in Firebird? And what is your most  favourite feature/improvement in Firebird 3?
 
I think the key thing about Firebird is its simplicity and small footprint, install it and you are — basically — good to go. I think my favorite new feature in Firebird 3 are the window functions. They provide much needed extensions for analytical queries.
September 28, 2014
 The next guest is Paul Reeves (IBPhoenix).
 
— Paul, why do you think people will be interested most of all in your presentations?
 
— Well, I've always been fascinated by trying to measure firebird performance. This year I've spent quite a bit of time working on a test harness that produces consistent output, and above all, a database to store and analyse the data produced by the tests. The results are quite surprising and to me at least, very interesting. I'm certainly enjoying putting the presentation together and hopefully it will be enjoyable for people to sit through.
 
— What do you like most of all in Firebird?
 
— The pace of development. I know we seem to be behind schedule on v3 but I'm barely up to speed with the new features that have been added in v2.n. A lot of the things that used to be difficult back in the day (I've been using Firebird since IB4) are so easy now. The way text blobs can be converted to and from strings, the way sql statements can be constructed on the fly in stored procedures, the fact that domains can now be used consistently in SPs — these are just a few of the things that make database development easier. And of course there are monitoring tables, db and txn triggers. And loads more stuff besides. 
 
—  What is your most favourite feature/improvement in Firebird 3?
 
— It is too early to say. There is so much new stuff in v3 that it will take me a while to get on top of it all. Probably best to ask me in about two years time :) 

Register to Firebird 2014 Conference!
 The next guest is Paul Reeves (IBPhoenix).
 
— Paul, why do you think people will be interested most of all in your presentations?
 
— Well, I've always been fascinated by trying to measure firebird performance. This year I've spent quite a bit of time working on a test harness that produces consistent output, and above all, a database to store and analyse the data produced by the tests. The results are quite surprising and to me at least, very interesting. I'm certainly enjoying putting the presentation together and hopefully it will be enjoyable for people to sit through.
 
— What do you like most of all in Firebird?
 
— The pace of development. I know we seem to be behind schedule on v3 but I'm barely up to speed with the new features that have been added in v2.n. A lot of the things that used to be difficult back in the day (I've been using Firebird since IB4) are so easy now. The way text blobs can be converted to and from strings, the way sql statements can be constructed on the fly in stored procedures, the fact that domains can now be used consistently in SPs — these are just a few of the things that make database development easier. And of course there are monitoring tables, db and txn triggers. And loads more stuff besides. 
 
—  What is your most favourite feature/improvement in Firebird 3?
 
— It is too early to say. There is so much new stuff in v3 that it will take me a while to get on top of it all. Probably best to ask me in about two years time :) 

Register to Firebird 2014 Conference!