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.
August 23, 2016
More News
Firebird Conference 2016, Announce #2: Firebird SQL Best Practices and Firebird
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.
Join Firebird!
RSS Newsletter
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.