Beside improved SMP-support, an exciting new feature in Firebird 2.5 is the new Audit and Trace Services API. This is a completely new way for Firebird administrators and developers to monitor their databases, because it gives you a server-side, configurable and continuous stream of executed trace events, without adding proprietary code into your client application.
This talk will be about various way to setup Firebird under Linux. We'll see that you can use project builds, integrated distribution packages, build from source. We'll see pro and con for each and differences. Under Linux you can make some parameters changes, about your file system, your kernel, we'll see what point can be useful to check or change for better performance.
Firebird 3.0 will have a new feature : Window functions A window function in SQL:2008 is an aggregate function applied to a partition of the result set. Those features will significantly enhance the toolkit of OLAP users with Firebird
There are many ways how application developers using Firebird could paint themselves in the corner. Beside well-known design and development errors, there are also subtle mistakes that could have dire consequences.
This talk will guide you through twisted maze of design and development decisions, pointing out the traps, hidden horrors and dead-ends, and strategies how to avoid them.
Session 2: Firebird Python Drivers: Current state and future
This talk will update you on current state of Firebird connectivity for Python (with a surprise!), and plans for future development
.NET driver for Firebird is trying to keep up with new features added to Firebird server. In last year or so I created some features specifically targeting Firebird 2.5, and also some important bug fixes and optimizations.
This talk will uncover these new items and will shouw you how to use it (with some (maybe) interesting scenarios).
After a short introduction to the world of Character Sets and Unicode, this session will show you how to bring it all to work in Firebird.
You will learn what all those character sets and collations are and how you can properly use them to get the right characters into the database and onto your screen.