Contact Us | Site Map
Firebird is used by approximately 1 million of software developers worldwide. High compatibility with industry standards on many fronts makes Firebird the obvious choice for developing interoperable applications for homogeneous and hybrid environments.
News & Events
August 26, 2016
We continue to publish announces of talks at Firebird Conference 2016, which will take place in Prague, Czech Republic, October 7-8 (only 1 week left to register to Firebird Conference 2016 with Early Bird discount!).
Today we announce the talks from Jiri Cincura, developer of Firebird .NET driver and Firebird+.NET development trainer.
How to implement the full-text search using only PSQL
Firebird at the moment does not have a native support for the full-text search. So you are either out of luck or you have to use syntax using the LIKE or CONTAINING expressions. Luckily when lowering the bar a little (what features the search has to cover) and focusing on core functionality, it is possible to create the very fast full-text search using only fairly simple PSQL and some out-of-the-box thinking. Production examples will be included.
What's new in Firebird.NET Provider
With the release of Firebird 3.0 a lot has changed in .NET provider. Some features from Firebird 3 are already supported now and also a lot of changes and improvements in other areas have been done. This session will walk you through most of these improvements and changes and will show you how to use these and show how these work in Firebird and how you can benefit from using them.
August 23, 2016
Philippe Makowski (IBPhoenix), the maintainer of Linux packages for Firebird and vice-president of Firebird Foundation, will present 2 topics at the Firebird Conference 2016:

Firebird SQL best practices
This talk will be devoted to the review of SQL features available in Firebird and that people often forget about their existence: Merge, Common Table Expression, Window Functions, etc. The special focus will be on how to emulate loose index scan using a recursive CTE. The term "loose index scan" is used in other databases for the operation of using a b-tree index to retrieve the distinct values of a column efficiently; rather than scanning all equal values of a key, as soon as a new value is found, restart the search by looking for a larger value. This is much faster when the index has many equal keys.

Managing Firebird with Ansible
This session will cover the topics listed below:
General information about configuration management and benefits of using configuration management tools Ansible overview and advantages of Ansible compared to other configuration management tools Basics of Ansible such as roles, tasks, handlers, modules, playbooks etc
Information about the Ansible Firebird module (a preview of this new module) and its usage with some examples. A playbook example using the Firebird module, covering managing Firebird Databases on AWS systems, RedHat, Debian, Mageia hosts, and Windows hosts.
 
August 20, 2016

Jaybird 3.0.0-alpha-1 has been published for testing. We would really appreciate if you could start testing your applications with this
version and provide feedback on stability and behavior, but also on the release notes.

Feedback can be sent to the Firebird-java mailinglist or on the issue tracker http://tracker.firebirdsql.org/browse/JDBC.

Jaybird 3.0 is a big change from Jaybird 2.2 and earlier. We have rewritten the entire low-level implementation to be able to support
protocol improvements in newer Firebird versions, we have made changes with a stricter interpretation of the JDBC requirements, and we have
removed some parts that were either obsolete or not functioning correctly.

We recommend that you do not consider Jaybird 3.0 a drop-in replacement
for Jaybird 2.2, and study the release notes carefully.

See:

Jaybird 3.0 Alpha 1 is available from Maven central: see instructions in the release notes.

August 07, 2016
Home About Firebird Documentation Downloads Community Support Development Case Studies Back to Top
This site and the pages contained within are Copyright © 2000-2016, Firebird Project. Firebird® is a registered trademark of Firebird Foundation Incorporated. Developed by DQ Team.