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.
You are here: Home Newsletter
Join Firebird!
Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses
Follow Us
Select your media preference
Google+ Twitter Facebook RSS
Newsletter
Subscribe to Firebird’s Newsletter to receive the latest news
Newsletter
October 31, 2014
Firebird Project is pleased to announce that «Firebird 2.5 Language Reference» in Russian language is released. It is available on Firebird SQL Documentation page.

Why it is only in Russian and how to get it in English? The answer is the following: Moscow Exchange, one of the biggest Firebird users in the world, and IBSurgeon (tools and service for Firebird) have sponsored documentation development in Russian. Several Russian-speaking core developers of Firebird Project participated in documentation creation to ensure its quality.

The next step is extending this documentation to cover Firebird 3 new features: authors and editors are already working on it. However, the resulted documentation for Firebird 3 will be also in Russian.

In order to translate Firebird documentation into English, Firebird Project needs additional funds.

We need US$7000 to translate almost 500 pages of Firebird documentation into English using professional translation service, which will ensure the quality of translation.

So, if you would like to have Firebird 2.5 and 3.0 Language Reference in English in the first quarter of 2015, please help Firebird Project now with your donations (please use PayPal option): http://www.firebirdsql.org/en/donate/

Please don't think that somebody else will pay for Firebird documentation!

Collected money will go to translation of Firebird documentation and, if USD$ 7000 threshold will be exceeded, for further development of next volumes: «Firebird Operations Guide» and others.
October 22, 2014
Firebird 3 is on its track to release: the first Beta version of source code was tagged, and now Firebird core developers work on Beta 2, with intention to release final Firebird 3 in the beginning of 2015.

How to ensure that Firebird 3 will be stable and reliable? How to make it happen earlier? The answer for these questions is: intensive beta-testing with wide community support.

To start effective beta-testing earlier and to supply Firebird developers with convinient path to Firebird 3 we started Firebird 3 Launch Campaign (www.firebird3.com).  It has 3 parts:

1) Firebird 3 distributives, materials and documentation, with focus on Firebird 3 new features, configuration tips and tricks, performance testing, and, of course, beta-testing. 

2) Banners for Firebird 3. To support Firebird 3 Launch Campaign, simply put Firebird 3 banner  to your blog/web-site, and point them to www.firebird3.com

3) Social activity: starting with simple posts and «likes», then we will continue with contests and special prizes. Join Firebird in Facebook  (https://www.facebook.com/FirebirdSQL ) and LinkedIn (https://www.linkedin.com/groups?gid=2078215) to be part of the action!

We believe that Firebird 3 will become the best version of Firebird ever, and to encourage you and all Firebird developers we prepared a lot of very interesting materials for Firebird Launch Campaign.

Stay tuned for Firebird 3 news!
September 23, 2014
 We'd like to invite you to the Firebird event of the year - The Firebird International Conference 2014.

It will last for 2 days, and takes place on October 24-25th, in Prague. The Conference will be devoted to 2 main topics: Firebird 3 features and Firebird performance.
 
With Firebird 3 Beta 1 (due to be announced next week) you will be in a position to start testing, doing development or considering migration to Firebird 3.0, and, since Firebird 3.0's SuperServer configuration shows three times better performance than Firebird 2.5 SuperClassic, it is probably not a bad idea!
 
(Note: There will be special sessions devoted to performance testing and comparison of Firebird 3,9 v's Firebird 2.5.)
Dmitry Yemanov and Vlad Khorsun (core developers of Firebird) will present detailed explanations of the new features in Firebird 3.0, with focus on its architectural changes and advantages which this new technology will give to Firebird users.
 
There will be two very special speakers at Firebird Conference: Ann Harrison and Jim Starkey (the original creator of InterBase), presenting interesting topics about multi-threading and orphan database pages.
 
There will be sessions devoted to the new abilities of performance monitoring with Firebird 3.0 enhancements, and a session about Firebird database recovery and how to avoid possible database corruption.
 
The developers responsible for the Firebird JDBC/.NET drivers will also be at the conference, so this is a good chance to ask questions about optimal performance and future development.
And, as usual, Firebird Conference is also is good place to meet with existing friends and make new friends, to find like-minded people and get invaluable experience and conversation.
 
For more details please take a look at the list of presentations.
 
The conference page with more details about the location and how to register is here:
 
Don't miss your chance to participate in the main Firebird event of the year!

Regards,
Alexey Kovyazin
Firebird Project
July 30, 2014
The Firebird Project is pleased to announce Firebird Conference 2014: The most important international event devoted to Firebird. The Firebird Conference 2014 will be a meeting point for all Firebird users and developers of Firebird. It's the best place to share and receive Firebird knowledge!

The Firebird Conference 2014 will take place on October 24-25, 2014, in Prague, Czech Republic, at the Clarion Congress Hotel. Early Bird registration is available till August 15 only, so register now: http://www.firebirdsql.org/en/firebird-conference-2014/

Here is the list of the most interesting topics at Firebird conference. It will be updated when new descriptions from speakers will arrive.
  1. Firebird release strategy and roadmap for 2015/2016, Dmitry Yemanov
  2. Firebird performance counters in details, Dmitry Yemanov
  3. Threading through InterBase, Firebird, and beyond, Ann Harrison and Jim Starkey
  4. Orphans, Corruption, Careful Write, and Logging, Ann Harrison and Jim Starkey
  5. Using Firebird trace & audit as tool for system analysis, Pavel Cizar
  6. Using Firebird monitoring tables as tool for system monitoring and analysis, Pavel Cizar
  7. Firebird database recovery: tools and techniques, Alexey Kovyazin
  8. Transactions: how they work inside Firebird, Dmitry Kuzmenko
  9. Firebird Performance tests: open-source framework to simulate real-world Firebird applications with heavy load, Pavel Zotov
  10. A year in the life of .NET provider, Jiri Cincura
  11. Using Azure cloud and Firebird to develop applications easily, Jiri Cincura
  12. Firebird and Node.js, Marius Popa
  13. Creating logs for data auditing, Carlos Cantu
  14. Understanding numbers in Firebird, Carlos Cantu
  15. Tips for using system tables, Ivan Prenosil
  16. Benchmarking Firebird with TPC-C, Paul Reeves
  17. Jaybird Status Update, Mark Rotteveel
  18. Using Firebird from Java (using Jaybird) with the help of jOOQ&Hibernate, Mark Rotteveel
  19. Overview of Red Database 2.5, Roman Simakov
  20. Firebird replication with CopyCat, Jonathan Neve

Dmitry Yemanov,
Firebird lead architect
Firebird release strategy and roadmap for 2015/2016

This session will be dedicated to post V3 development. It will outline the new release strategy to be established for the coming years, it will show what is being plabben will describes the primary goals for the future Firebird versions. An updated roadmap will be presented.

Firebird performance counters in details

The Firebird database engine internally maintains a number of performance counters that are exposed as runtime statistics via both monitoring tables and the trace facility. Firebird 3.0 improves on this by introducing lots of other performance counters. This session will provide an in-depth review of both existing and newly added counters with examples how to use them in both query profiling and bottleneck investigations.

Ann Harrison


Jim Starkey
Threading through InterBase, Firebird, and beyond 

From its original conception as Rdb/ELN, the design that became Firebird targeted the use of multiple processors to improve database performance. Computer architectures have changed radically over time and the process architectures of Firebird changed with them. What remains constant, is that database applications need all the power available to them, and the best way to get it is to increase the parallelism. Early versions of InterBase and Firebird in its classic mode used process-based parallel execution. That design suited environments before most operating systems supported threads. On VAX clusters, processes could run on different computers in the cluster. On multi-processor systems, the operating systems schedule Firebird processes on different processors on the same machine. One anomaly in the parallelism story is the SuperServer architecture of InterBase and Firebird prior to V3. SuperServer is threaded, but has only a single control stream and cannot run on multiple processors.

Having multiple threads in a single process has many advantages over a multi-process architecture on current multi-processor machines. Sharing the page cache means fewer copies of each page in memory, many fewer I/O operations, and of course, eliminates the need for interprocess communication.

Multi-threading is not simple. Introducing multi-threading into existing software is particularly challenging. Firebird has made major progress in Version3. Other database management systems have implemented more complex mechanisms to provide parallelism. This talk and paper will consider threading and parallelism and the challenges they present starting in the early eighties and continuing to consider a new model, created by Jim Starkey, that provides elastic scalability and distributed query processing.

Orphans, Corruption, Careful Write, and Logging

A frequent question on the Firebird Support list is "Gfix thinks my database is corrupt. How can I fix it?" The best answer may be to fix gfix itself so it reports benign errors differently from actual corruption. The most common errors reported by gfix can simply be ignored. From the beginning of InterBase to now, gfix is the least interesting of the utilities, so it's had little attention. However it requires a great deal of knowledge of database internals, so it's not easily replaced by a separately developed tool. So, from 1984 until now, gfix has reported major corruption and benign errors as if they were all the same.

What's a benign error? Usually, it's an artifact from the sudden death of a Firebird server that leaves obsolete record versions or even whole empty pages orphaned — neither released nor in use. Orphans represent lost space, but have no other damaging effect on the database. Orphaned record versions and pages occur because Firebird carefully orders its page writes to avoid the need for before or after logs. Database management systems that rely on logging for durability and recovery write each piece of data twice — once to a log and later to the database. Careful write requires discipline in programming. In 1984, careful write had performance advantages that more than made up for the need for careful programming.

This talk and paper explore the cause of "orphan" pages and record versions, Firebird's careful write I/O architecture, and the trade-offs between careful write and logging today.

Pavel Cizar,
IBPhoenix
Using Firebird trace & audit as tool for system analysis

Firebird trace and audit services were introduced in Firebird version 2.5. They provide extensive logging of various events that occur performed inside the database engine, such as statement execution, connections, disconnections, etc., that can be used to identify problematic spots in your system. However, these audit trails can be huge and very hard to analyse.

This session will present some challenges and solutions based on experience and usage of the trace and audit services at IBPhoenix.

Using Firebird monitoring tables as tool for system monitoring and analysis

Firebird monitoring tables are a less intrusive tool for system monitoring and analysis than the trace and audit services, because they provide snapshots of internal states rather than a continuous trail of events. However, using them effectively has it's own set of challenges.

This session will present some approaches and solutions based on experience with monitoring tables at IBPhoenix.

Alexey Kovyazin,
IBSurgeon
Firebird database recovery: tools and techniques

Why do Firebird databases become corrupted? How to avoid corruptions? These are popular questions from Firebird administrators and developers of Firebird applications.

This Session will be devoted to key corruptions and issues that can sometimes happen to Firebird databases, the session will detail the methods needed to fix them.

Dmitry Kuzmenko,
IBSurgeon
Transactions: how they work inside Firebird

This session is devoted to an explanation of how the internal transaction mechanism works in Firebird, in order to give developers practical recommendations on how to correctly handle transaction management.

Pavel Zotov,
Firebird Project QA
Firebird Performance tests: open-source framework to simulate real-world Firebird applications with heavy load

This Session is all about Firebird performance testing, and about an open-source framework created to simulate the heavy load of real-world Firebird applications using complex business-logic. The framework supports both Firebird 2.5 and Firebird 3.0, and utilises many Firebird 3 features. Comparison test results and tuning recommendations for Firebird 2.5 and Firebird 3.0 will also be presented.

Jiri Cincura,
Firebird Project, .NET driver developer
A year in the life of .NET provider

What's new and what's planned, an overview of changes made to the .NET provider, as well as new features and the expected direction of development for the coming year.

Using Azure cloud and Firebird to develop applications easily

A session to introduce developers in using Firebird on the Azure cloud and what it offers for a .NET developer. Focused on loosely coupled scenarios where part of the application can be run on-premise, or even written in different language, whilst other part(s) run on Azure and have the benefit of the .NET world and its scalability.

Marius Popa
Firebird and Node.js

An overview of Node.js and Firebird drivers with a examples (Express/Angular) and performance comparison : A native c++ driver vs a pure java script driver.

Carlos Cantu
Creating logs for data auditing

Sometimes you can have situations where users say that information has disappeared from the system or it has been modified without any intervention. In these cases, typically no user will take the responsibility for what has happened blaming the developer, the application or even the database. That's when audit logs become an extremely useful tool. Using logs, we can check everything that happens to our data (inserts,updates, deletes) as well as who and when it took place.

This talk will cover a real example of how to implement logs for data auditing in Firebird databases, using only the native features of Firebird 2.1 and 2.5. The information will be stored in log tables and can be accessed by standard sql (select), allowing the user to know who inserted, modified or removed any data, when the operation took place, the IP address of the system involved and what information has been affected. It will also show an example of keeping the log data both in production database as well as in an external log database as well.

Understanding numbers in Firebird

Firebird offers several datatypes to store numbers: integer, numeric, decimal, double precision, etc. Developers sometime have doubts about what is the best type to use for a specific purpose, e.g. storing monetary values, etc. The behaviour of some of those datatypes also depends on the dialect being used, and can affect even the precision of the retrieved values.

This talk will explore the different datatypes supported by Firebird to store numerical values, the differences among them, what care needs to be taken regarding limits and precision, and some "quirks" that can generate strange results like truncated values, retrieved values that are different from what was originally stored, etc.

Ivan Prenosil
Tips for using system tables 

To ensure your database is in good shape, you do not always need to use specialised tools. A quick look into the Firebird system tables can reveal lot of interesting things or warn about problematic or suspicious places in your database structure.

Paul Reeves,
IBPhoenix
Benchmarking Firebird with TPC-C

The tpc-c spec is designed to imitate an OLTP database application — which is very much the zone that many firebird databases occupy. This makes it an ideal candidate for benchmarking different firebird configurations.

In this session we start with a brief look at the tpc-c specification and how it needs to be modified to work as a benchmark for Firebird. We then look at what else is required to set up the test harness.

With the test harness in place we can then use it to examine the results of running the benchmark under various configurations. We will run tests that aim to provide answers to these sorts of questions:
  • Windows or Linux — which performs better?
  • Comparing Super Server and Classic Server performance.
  • Analysing performance degradation as concurrent user numbers increase.
  • What is the impact of the build up of back record versions on performance?
  • Finding the right balance of database cache and filesystem cache
  • Does intensive use of SSD RAID degrade compared to HDD RAID?
One thing is certain — once the data has been collected the resulting graphs always give us new insights into the behaviour of Firebird under load.

Mark Rotteveel,
Firebird Project, Jaybird developer
Jaybird Status Update

Current state of Jaybird development, new features in Jaybird 2.2 and 3.0, JDBC 4.2 (Java 8).

Using Firebird from Java (using Jaybird) with the help of jOOQ&Hibernate

JDBC is a relatively low-level API that requires a lot of boilerplate code. This is usually hidden with higher level APIs that make developer life simpler.

This session shows two different styles of querying database in Java: Hibernate is an Object Relational Mapper to map between Java objects and database tables, while jOOQ is a fluent API that gives you the flexibility and power of SQL in a typesafe manner

Roman Simakov,
Red Soft Corporation
Overview of Red Database 2.5

This session describes what Red Database is and how it's correlated with Firebird project. We'll talk about development process and main features which Red Database added to Firebird: a lot of security improvements, database file and network traffic encription, built-in engine record level replication, etc. Also roadmap and some interesting case studies will be presented.

Jonathan Neve,
CopyCat
Firebird replication with CopyCat

This talk is devoted to the Firebird replication with CopyCat components and CopyCat LiveMirror.

May 16, 2014
International Firebird Conference 2014

The Firebird Project is pleased to announce Firebird Conference 2014: The most important international event devoted to Firebird. The Firebird Conference 2014 will be a meeting point for all Firebird users and developers of Firebird. It's the best place to share and receive Firebird knowledge!

The main sponsors of the Firebird Conference are IBPhoenix and IBSurgeon.

The Firebird Conference 2014 will take place on October 24-25, 2014, in Prague, Czech Republic.

Firebird Tour Seminar in Moscow, June 2, 2014

Firebird Project invites to the next "All About Transactions" seminar in the frames of Firebird Tour: next stop in Moscow, June 4, 2014.

More details are here (in Russian).

Community News Index (www.firebirdnews.org)

The news below was collected from FirebirdNews site. You can periodically visit the site or subscribe to its RSS feed to keep up to date in almost real-time with all the news coming from the Firebird community.

Community News

[May 15, 2014] Firebird International Conference is officialy announced

Firebird Project is glad to announce Firebird Conference 2014: the most important international event devoted to FirebirdSQL. Firebird Conference 2014 will be a meeting point for all Firebird users and core developers of Firebird. It's the best place to share and receive FirebirdSQL knowledge!

Firebird Conference 2014 will be October 24-25, 2014, in Prague, Czech Republic, in Clarion Congress Hotel (see details about its location).

There will be 2 simultaneous flows in the conference, during 2 full days.

More details about the Conference can be found in http://firebirdsql.org/en/firebird-conference-2014/.


[May 15, 2014] #Node Firebird driver: node-firebird-libfbclient can be build and used on MacOS X

Latest version for Node C++ Module for Firebird from git can be build on MacOSX fixing Linking flags (against regular Firebird installation)

[May 12, 2014] Active Record Firebird Adapter for #Rails updated to version 0.8.8

Active Record Firebird Adapter 0.8.8 is updated with a few cleanups and fixes: Merge pull request from Ray Zane: Use @config instead of @connection_params. Fix sequence name limit.

[May 07, 2014] Ruby Firebird Extension Library — Fb bumped to version 0.7.1 with a few fixes

Version 0.7.1 is on RubyGems now. With following changes and bug fixes: Fix naive rounding logic affecting negative scaled values. Update for current rubygems, add license MIT like ar adapter, add rakefile. Fixes error: ‘isc_info_db_SQL_dialect’ undeclared (first use in this function) replaced in Firebird 3.0 and marked as deprecated from firebird 1.5.

[May 07, 2014] Sparx Systems — Enterprise Architect 11 uses Firebird

Sparx Systems now has a fully intergrated Firebird backend Database for its Enterprise Architect application

[May 02, 2014] Database .NET 11.2 released

Database .NET is an innovative, powerful and intuitive multiple database management tool, With it you can Browse objects, Design tables, Edit rows, Export data and Run queries with a consistent interface.

What's New (2014/05/02)
You're welcome to download the Database .NET right now at: http://fishcodelib.com/Database.htm

Free, All-In-One, Portable, Standalone (No Installation) and Multlanguage. Supported Platforms: Windows All (x86/x64)

[April 29, 2014] Database Workbench 4.4.6 released

Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: "Database Workbench 4.4.6 Pro". For more information, see here.
The Free Lite Editions will be released at a later stage. Database Workbench supports:
  • Borland InterBase (6.x - XE )
  • Firebird ( 1.x, 2.x )
  • MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express )
  • MySQL 4.x, 5.x
  • Oracle Database ( 8i, 9i, 10g, 11g )
  • Sybase SQL Anywhere ( 9, 10, 11 and 12 )
  • NexusDB ( 3.0 and up ) You like this news?
Twitter it! Share it! Check out the PromoProgram!

[April 29, 2014] Firebird for Android may arrive soon

Alex Peshkov commented in the fb-devel list that he plans to start working in a port of Firebird 3 for Android right after FB 3 Beta 1 is released. Beta 1 is supposed to be out in this quarter.

[April 28, 2014] Firebird Classic 2.5.x with xinetd on Ubuntu/Debian systems

By default Firebird Classic package uses openbsd-inetd You can inspect the config cat /etc/inetd.conf the max number of connections per minute is 255 after nowait you can suffix this field with a period, followed by the maximum number of connections authorized per minute for example nowait.10000 localhost:gds_db stream tcp nowait.10000 firebird /usr/sbin/tcpd /usr/sbin/fb_inet_server

To switch to xinetd an easier to use and popular alternative sudo apt-get install xinetd

This will stop openbsd-inetd and will start xinetd alternative You can inspect it with cat /etc/xinetd.d/firebird25

There are a few issues with default config and it will be cleaned in the next firebird-classic package versions. A good config should look like this where i configured an unlimited numer of instances per source (also you can tweak the cps)

[April 27, 2014] Jaybird 2.2.5 is released

Download links and information on Jaybird wiki page

[April 24, 2014] Planning the Firebird v4.0 development

Dmitry Yemanov wrote on Firebird-Devel mailing list:

We're getting closer to the v3.0 feature freeze which is going to happen this summer. Everything roadmapped for v3 but not implemented before the deadline will be postponed. The next-after-v3 release is likely to incorporate most of the postponed features, but there may be new features as well. So it makes sense to start discussing what could and should be done in the next version(s). We have a few months to collect the proposals, discuss technical details and make estimates about the required efforts.

This message is the invitation to both project members and users who closely follow the development. If you want to discuss something for potentially including into the new version(s), feel free to do that in separate threads. Please be prepared to protect your opinion and discuss the details, simple votes "I like feature X" don't count. A tracker ticket for the feature request is appreciated, please add its URL to your post.

Just for the reference, the top-voted tickets can be found here in jira

The ongoing results of the planning stage will be published on our website and scheduled for the next version(s) by the project admins.

[April 23, 2014] Firebird Tour: seminar in Moscow, June 4, 2014

Firebird Project invites you to the next "All About Transactions" seminar in the frames of Firebird Tour: next stop in Moscow, June 4, 2014. More details are here (in Russian).

[April 23, 2014] Mezzanine 3.1.1 released and is stable with firebird driver for Django 1.6.x

Mezzanine 3.1.1 is released and is considered stable with firebird driver for Django 1.6.x Updated instruction for Firebird are here.

[April 23, 2014] Firebird backend for Django 1.6.x stable version released

Firebird backend for Django 1.6.x stable version (final) is released on pypi (now with wheel support)

[April 22, 2014] New Database Mirroring Product: CopyCat LiveMirror

Microtec is pleased to annonce a new product for Firebird database mirroring, called CopyCat LiveMirror. Based on our CopyCat replication engine, LiveMirror is a simple to use tool geared specifically towards setting up a mirror of your production database for failover / backup purposes. LiveMirror is easy to setup, reliable, and affordably priced at 49 EUR per licence.

For more information about LiveMirror, please have a look at our product page here.

[April 22, 2014] TurboBird 1.0.2 stable version is released

TurboBird 1.0.2 is released as a stable version Changes: Adding Auto commit option. Minor bug fixes

[April 17, 2014] Current status of the Firebird bugfixing : Tracker Roadmap

Here in Tracker is the current status of the Firebird bugfixing for the next releases Firebird 2.5.3 and Firebird 3.0 Beta 1

[April 16, 2014] Firebird Language basic Reference ready This Year

Paul Vinkenoog wrote on firebird docs list

This is just to let you know that I'm making time available for the Language Reference this year. I'm working on the DML chapter now, and I'm somewhere in the middle of the SELECT statement. All the others are finished (the other DML statements, that is — not the other chapters!)

I will do my utmost to have a "basic" Language Reference ready this year, i.e. possibly without all the details on Dialect 1 and other things that people can hopefully live without for a while (or grab the IB6 LangRef if they can't).

Once finished, updating it to Firebird 3 shouldn't be a hell of a job.

But it ain't finished yet.

[April 15, 2014] pyfirebirdsql Version 0.9.3 is released with alternate crypt support for Windows

pyfirebirdsql Version 0.9.3 is released with alternate crypt support for Windows and a few refactorings pyfirebirdsql is included now in FreeBSD ports collection

[April 15, 2014] ADO.NET provider for Firebird 4.1.5.0 is ready

ADO.NET provider for Firebird 4.1.5.0 is ready

[April 14, 2014] FirebirdSQL driver for Go (golang) with support for Firebird 3.0 Auth protocol (SRP)

Hajime Nakagami created a Firebird SQL driver for Go with support for Firebird 3.0 Auth protocol (SRP) in pure golang

[April 11, 2014] Redsoft Database (based on Firebird) used in GosLinux systems for FSSP

Management of Information Technology of the Federal Bailiff Service (FSSP) Russia announced a new phase of implementation of the free software and "import information technology" — the appearance of their own GNU / Linux distribution called GosLinux.

GosLinux distribution is based on CentOS 6.4 and created by "Soft Red" in 2013 after a win of the Russian company in the competition for revision, implementation and maintenance of automated information systems for FSSP Russia. In the server infrastructure of the territorial distribution of the FSSP Russia CentOS was used since 2012, and now all units bailiff service can use a specialized system, which received a FSTEC certificate at the end of March.

Among the major software components of the distribution used in the FSSP Russia, referred to the: Apache Tomcat application server and "Red Soft" database based on relational open source database Firebird. And another article here

ps: Sorry for google translation

[April 10, 2014] FB TraceManager V3.5.1 has been released

FBTM_V3_48x48 Upscene Productions is excited to officially release FB TraceManager V3.5.1!

This release adds support for pre-defined purge options of stored trace data. Minor issues have been fixed as well. More information is available here

Or also directly in the V3.5 what's new section of the online product documentation: 

More information on the product is available in the FB TraceManager section on our website, including an edition comparison sheet, webcasts etc. Thanks for your continued support.


[April 08, 2014] How to patch, build and debug PHP extension: PDO Firebird

Vjacheslav V. Borisov wrote a tutorial on how to build and debug PDO Firebird driver:

I noticed that there is too many bugs open and too few developers who can do the work. And even this list is almost dead. Don't know what is the cause of that, but may be it is just hard to start ? I recently written some patches for php — work, which I never done before. And i can say, this really not so hard, if you know C/C++ (or at least php?) and linux. Most troublesome work is to setup build environment, so i decided to write instruction how to patch, build and debug PHP extension, so may be more web developers can contribute to php.

[April 04, 2014] Advanced Solutions How to : Coordinating transactions for multiple connections in single call

Leyne, Sean asked on Firebird-devel (You can read in that thread the details about problem requirements and proposed solutions)

Consider a large database (200GB, large tables with 450 Million rows) which is running on a kick-a** server with pool of enterprise SSDs for storage (more IOPS then Firebird could ever use), which I need to extract data from on a regular basis throughout the day for use by an external BI system. During the business day, the database is Live with over 300 connections active with 1 million+ DB transactions. I need to extract the BI data as a true "snapshot" of data (ensuring FKs are valid), in as short a timeframe as possible. Because runtime is critical, I want to break the extract process into logical pieces and run each piece is a separate process/thread (with its own connection) (aka run in parallel).

[April 03, 2014] Firebird in Calligra Office Suite discussion on calligra devel list

Discussion was on kde.devel.calligra there is a need for Firebird driver implementation in Kexi in the future. Any contributors for the new kexi driver?

[April 03, 2014] Java needed to run LibreOffice Base Database? No with Firebird SQL

You can try to use the Firebird Database within LibreOffice which doesn't need Java. This feature is still marked as experimental. Firebird Databases are available since LibreOffice 4.2. (see the release notes for further information To turn the experimental features on, you have to go to the Settings --> LibreOffice --> Advanced --> "Enable experimental features" (see screenshot bellow) Then you can uncheck the Java from the same Dialog.

Java_Disabled

There are few components written in Java if you use them: The Wizards, Report Builder, and Report Designer sub-components are written in Java. Full list of Java dependencies here. Original question and source is on ask.libreoffice.org To make Firebird Embedded default database in the new database dialog open Expert Configuration and change this key org.openoffice.Office.DataAccess/EmbeddedDatabases/DefaultEmbeddedDatabase/Value to sdbc:embedded:firebird

[April 01, 2014] Hopper v1.5.0 — stored routine debugger — now available!

Upscene Productions announces a new release of: "Hopper — a Stored Code Debugger"
Hopper is a Stored Routine and Trigger Debugger, available for Firebird, InterBase and MySQL.



For more information and a trial download, see the news @ Upscene Productions, pricing information is available.

Bugfixes include CHAR issues with InterBase and Firebird and a CAST error in MySQL.

You like this news? Twitter it! Share it! Check out the PromoProgram!


October 11, 2013
Firebird Tour is a series of seminars around the world in 2013 and 2014, devoted to Firebird, with members of Firebird Project as speakers.
 
The first seminar will be in Siegburg (Germany), November 22, 2013 (early bird registration is over, few places at regular price still available).
The second stop of Firebird Tour will be in Prague (Czech Republic), November 25, 2013.
 
Firebird 2013 Tour will be devoted to all aspects of transactions, from the basic idea, to the internal implementation, best practices and guidance how to effectively use transactions in the applications, and, of course, performance analysis of transactions and related areas.
 
List of topics to be covered:
  • -   Transactions from the beginning: isolation levels and specific Firebird parameters (no_rec_version, table locking, read/write, wait/nowait), examples of their usage
  • -   How to use effectively isolation levels and parameters in multi-user applications, typical errors in transactions management
  • -   Internal implementation of transactions in Firebird, including versioning, locking and multi-generation mechanism
  • -   Garbage, sweep, auto-sweep: what are they and how to make them work for you and not against you
  • -   Effective management of transactions in various development tools (Delphi, Java, .NET, etc)
  • -   Transactions monitoring: transaction markers, MON$ tables, Trace API, third-party tools, how to find bottlenecks in transaction management and optimize database performance with monitoring
  • -   Best practices of transaction management, special approaches to optimize transaction in closed sourced applications.
  • -   Overview of Firebird 3.0 features
The detailed schedule of talks will be published later.
 
Languages at seminar will English and Czech. Organizers of Firebird Tour are IBSurgeon Ltd (www.ib-aid.com) and IBPhoenix (www.ibphoenix.com).
 
Details
 
Firebird seminar in Prague will take place in Hotel Extol Inn (http://www.extolinn.cz/index.php/en/contacts), November 25, 2013, from 09-00 to 18-00.
 
Attendee’s fees
 
Attendee’s fee includes seminar attendance, coffee-breaks, lunch and beverages. Room is not included.
Early bird registration is available till November 1, 20, 2013. 
Early bird registration is EUR 25 
(http://www.shareit.com/product.html?cart=1&productid=300604678), for group of 3+ attendees - EUR 19/person 
 
Regular price registration (after November 1, 2013) is EUR 35, for groups  3+ - 29 eur/person.
 
There are limited seats, so please take your chance and register as soon as possible.
Please feel free to ask any questions to organizer’s email firebird2013@ib-aid.com
 
August 29, 2013
Firebird Project is glad to announce Firebird 2013 Tour – series of seminars around the world, devoted to Firebird, with members of Firebird Project as speakers.
 
The first seminar will be in Siegburg (North Rhine-Westphalia, Germany), November 22, 2013.
 
Firebird 2013 Tour will be devoted to all aspects of transactions, from the basic idea, to the internal implementation, best practices and guidance how to effectively use transactions in the applications, and, of course, performance analysis of transactions and related areas.
 
List of topics to be covered:
-              Transactions from the beginning: isolation levels and specific Firebird parameters (no_rec_version, table locking, read/write, wait/nowait), examples of their usage
-              How to use effectively isolation levels and parameters in multi-user applications, typical errors in transactions management
-              Internal implementation of transactions in Firebird, including versioning, locking and multi-generation mechanism
-              Garbage, sweep, auto-sweep: what are they and how to make them work for you and not against you
-              Effective management of transactions in various development tools (Delphi, Java, .NET, etc)
-              Transactions monitoring: transaction markers, MON$ tables, Trace API, third-party tools, how to find bottlenecks in transaction management and optimize database performance with monitoring
-              Best practices of transaction management, special approaches to optimize transaction in closed sourced applications.
-              Overview of Firebird 3.0 features
 
The detailed schedule of talks will be published later.
 
Organizer and general sponsor of Firebird 2013 Tour is IBSurgeon Ltd (www.ib-aid.com).
 
Details
Seminar will take place in http://www.kranzparkhotel.de/, Siegburg, Germany, November 22, 2013, from 09-00 to 18-00. It’s ~1hour from Cologne and 1h15min from Frankfurt (by train).
 
Attendee’s fees
Attendee’s fee includes seminar attendance, coffee-breaks, lunch and beverages. Room is not included.
 
Early bird registration is available till September 20, 2013.
Early bird registration EUR 89, for group of 3+ attendees - EUR 79/person.
 
Regular price registration (after September 20, 2013) is EUR 109, for groups  3+ 99 eur/person.
 
There are limited seats, so please take your chance and register as soon as possible.
 
Please feel free to ask any questions to organizer’s email firebird2013@ib-aid.com
May 27, 2012
Editorial

Firebird Developers Day 9th Firebird Developers Day in Brazil 

The subscriptions for the Firebird Developers Day (FDD) are now open. The 9th edition of the conference will happen in 21/July, at Piracicaba-SP, Brazil. The number of expected attendees is between 450-600 people.

The conference has a huge importance for the Brazilian Firebird community, as a place where Firebird users have the chance of getting in touch with each other, exchange knowledge and experiences, and watch some great talks. Some of the topics covered by the conference this year are Mobile development accessing Firebird, Window functions, Performance tuning, Understanding and avoiding database corruption, New features of FB 3, cases studies, etc.

Brazil has the biggest Firebird user community in the world. It is listed as Top Country in the Firebird download statistics at SourceForge, with 26% of the 11.5 millions of counted downloads.

Attendees also have the chance to donate money for the project. The collected money can be used for sponsoring the development of a new feature, or donated to the Firebird Foundation. People also can buy several components and tools with huge discounts.

If you live in Brazil or are a Portuguese speaker, don't miss the chance to participate. Subscribe now!

Community News Index (www.firebirdnews.org)

The news below was collected from FirebirdNews site. You can periodically visit the site or subscribe to its RSS feed to keep up to date in almost real-time with all the news coming from the Firebird community. Community News

[May 26, 2012] Firebird driver for node.js in pure java script

From Henri Gourvest wrote on google plus:
I am working on a firebird driver for node.js, this driver don't need firebird client library and works on all platforms. Anyone interested ?

[May 24, 2012] Firebird 2.1.5 RC is uploaded to Debian testing and Ubuntu Quantal Quetzal

As you might now Firebird 2.1.5 RC is released, now the Debian packages are uploaded to testing repository and on the next Ubuntu Quantal Quetzal's repository.

[May 24, 2012] ADO.NET provider for Firebird 2.7.7 released

The 2.7.7 version of ADO.NET provider for Firebird is ready for download. This version contains some bug fixes as well as new functionality. More info...

[May 23, 2012] Firebird 2.1.5 Release Candidate is ready for testing

Firebird 2.1.5 will be the maintenance (point) release for Firebird 2.1. The most recent version is 2.5.1.

Please read its Release Notes and list of Bug Fixes for details.

[May 23, 2012] Disabling database triggers in FirebirdClient (.Net)

Via Jirí {x2} Cincura blog:
Database triggers are a nice new feature added to Firebird in version 2.1. And as you can do a lot of stuff with them, sometimes you also might wanna to connect without firing these, especially if you made a mistake there and it’s forcibly closing your connection. :) To disable these, standard Firebird utilities have a new switches. But it boils down to the API itself, nothing magical.

And if it’s in API, it could be FirebirdClient, right? In last few days among working on other bugs and my daily responsibilities I had a time to dig into this. And now also from .NET world we can use this feature.

[May 21, 2012] 9th Firebird Developers Day

People interested in participating in the Brazilian Firebird Developers Day can subscribe on-line for the conference, starting from today. Site with all the details is available at www.FirebirdDevelopersDay.com.br

[May 21, 2012] TurboBird Version 0.9.2 is released with permissions bugfix

You can check the homepage for download links for all platforms also there is github page where you can contribute.

Also for changelog please scroll down to the bottom of the project’s home page: Delete permission copy bug fix. Changing creating new table, generator and it's trigger.

[May 16, 2012] Ruby Firebird Extension Library Fb bumped to version 0.7.0

подаръциWith following changes:
Make fb compatibile with Rubinius.
Add encoding attribute and force strings from database to that encoding under Ruby 1.9.x.
Revert to old object allocation method to prevent stack overflow.
Satisfy ISO C90.
Update: The Rubinius change had to be reverted to make MRI work.

[May 16, 2012] Firebird 2.5.2 uploaded in repository for the next Ubuntu release 12.10

I have uploaded firebird2.5 2.5.2~svn+54476.ds4-1 in the Quantal Firebird ppa for testers. It is the same package from Debian Sid.

[May 16, 2012] Upscene Production, one of the best Firebird tools vendors, celebrates 10 year anniversary and gives 70% discount

News Via Mindthebird tweet Upscene Production, one of the best Firebird tools vendors, celebrates 10 year anniversary and gives 70% discount: http://www.upscene.com

[May 15, 2012] Firebird 2.5.2 package is updated in Debian sid (unstable)

New snapshot firebird2.5 (2.5.2~svn+54476) is uploaded to Debian sid repository. Here is the Full changelog.

[May 12, 2012] An ALPHA Firebird adapter for Rails 3.2+ is up

Firebird ActiveRecord adapter for Rails 3.2+ is up on Github, this is Alpha quality and is intended only for testers.

[May 10, 2012] AnySQL Maestro 12.5 released

AnySQL Maestro SQL Maestro Group announces the release of AnySQL Maestro 12.5, a powerful tool to manage any database engine accessible via ODBC driver or OLE DB provider (MS Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL, etc).

AnySQL Maestro comes in both Freeware and Professional editions (more information). New version features a powerful and easy to use data reporting tool, recognizing of auto increment columns, improved SQL editors and viewers and a lot of other useful things (full press release). 
AnySQL Maestro 12.5 has been successfully tested with the latest Firebird ODBC drivers and all the latest Firebird database server versions up to 2.5.1.

[May 10, 2012] Database Workbench 4.2.4 released

Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: "Database Workbench 4.2.4 Pro". For more information, see here.
Click here for the full list of changes in v4.2.4

We are celebrating our Ten Year anniversary, spread the word: 70% discount on all our products until the end of May!


The free Lite Editions will be released later this month.

Database Workbench supports:
  • Borland InterBase (6.x-XE)
  • Firebird (1.x, 2.x)
  • MS SQL Server/MSDE (7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express)
  • MySQL 4.x, 5.x
  • Oracle Database (8i, 9i, 10g, 11g)
  • Sybase SQL Anywhere (9, 10, 11 and 12)
  • NexusDB (3.0 and up)
You like this news? Twitter it! Share it! Blog about it!

[May 09, 2012] Firebird 2.0.x branch with four months changes in review

Alex Peshkoff backported fix for CORE-3736: WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table.

Dimitr backported CORE-3730: isc_dsql_exec_immed2() loses input parameter value with RETURNING clause. And then he updated the docs for 2.0.7 release.

Horsun Vlad backported fix for bug CORE-2977 that was in Firebird 2.1.x incorrectly works with indexed fields of type DATE in OLD ODS (9.1).

Paul Beach made modifications in 2.0.7 so it can be compiled and build on OSX.

Paul Reeves synced 2.0.7 branch with B2_0_Release.

In the end Paul Beach made in the conf. parameter DummyPacketInterval more accurate.

[May 09, 2012] "Hopper for Firebird", version 1 released

Upscene Productions announces the first release of: "Hopper — a Stored Code Debugger".

Hopper is a Stored Routine and Trigger Debugger, currently available for Firebird only, an InterBase and MySQL version will follow soon.

For more information and a trial download, see the news @ Upscene Productions, pricing information is available.

You like this news? Twitter it! Share it! If you'd like to blog about it, contact us!

[May 06, 2012] Libgda 5.1.0 released with Firebird support and many improvements

As we announced Libgda is now improves Firebird support in the latest version: 5.1.0

[May 05, 2012] Database .NET 6.4.4508 released

 Hi! I am happy to announce the new major release of Database .NET 6.4.4508 Database .NET is an innovative, powerful and intuitive multiple database management tool, you can Browse objects, Design tables, Edit rows, Export data and run Queries with a consistent interface. A standalone tool that does not require installation.

You're welcome to download the Database .NET v4 right now at: http://fishcodelib.com/Database.htm

What's New (2012/05/05)


Features: Supports:
  • Firebird Super/Classic/Embedded Server (*.gdb;*.fdb;*.*)
  • SQL Server 2000/2005/2008/2008R2/2012
  • SQL Server CE 3.1/3.5/4.0 (*.sdf;*.*)
  • SQL Server Express and LocalDB
  • SQL Azure
  • SQLite (*.db;*.db3;*.sqlite;*.*)
  • MySQL
  • PostgreSQL
  • Oracle
  • IBM DB2
  • IBM Informix
  • Sybase ASE
  • MS Access 97-2003 (*.mdb;*.*)
  • MS Access 2007-2010 (*.accdb;*.*)
  • MS Excel 97-2003 (*.xls;*.*)
  • MS Excel 2007-2010 (*.xlsx;*.xlsm;*.xlsb;*.*)
  • dBase IV (*.dbf)
  • FoxPro (*.dbc)
  • Data Sources (OLE DB) (*.udl;*.*)
  • ODBC DSN (Data Source Name) (*.dsn;*.*)
  • OData (Open Data Protocol)
All-In-One, Free, Simple and Standalone (no install).
 Supported Platforms: Windows All (x86/x64)
 Requires: .NET Framework 4.0 or higher
Direct Download: DatabaseNet4.zip (7.08MB)

[May 04, 2012] Firebird database that does not burn your data

Firebird database that does not burn your data  — a short lecture to display some key features of Firebird SQL.

[May 02, 2012] Libgda 4.2.13 released with Firebird support (work is in progress)

Libgda is a (relatively small) database access library: it is a wrapper like ODBC but with more features to access several database engines * features a meta data extractor (to know all about database objects in a common way) comes with an SQL console application.

Work is in progress for Firebird (Check the git tree). There is also a special feature which allows one to connect to a database hidden behing a web server (through specific PHP scripts) * LGPL licensed for the libraries and GPL licensed for the tools.

See http://www.gnome-db.org for more information. GdaBrowser-diagram
ps: I like the Gda Browser Relation Diagram tool

[May 01, 2012] Firebird Hosting on Windows & Linux

Having offered Firebird hosting on our Linux servers for over two years, InspiroHost is happy to announce that we now also offer Windows web hosting with full support for Firebird, PHP, MySQL, ASP and all the tools you need to get your website up and running. Cpanel/Plesk control panels are included, as is 24/7 technical support and server monitoring.

Please visit us at http://www.inspirohost.com/firebird-sql-hosting/

[April 30, 2012] Doxygenated source code for Firebird 2.5.x

It might be useful for people browsing and studying  firebird 2.5.x source code
http://fossies.org/dox/Firebird-2.5.1.26351-0/dir_88a51956a2144fcc1c2646c7da10c1f4.html

[April 27, 2012] DSQL/BLR compilers internals

Posted In:  by Adriano dos Santos Fernandes:
 
 
This post is some raw notes and is not very understandable by people who never worked with this code. In fact, the old implementation was so ugly that it was not simple even for me (who is constantly working in this area) to achieve this result. It needed many tries and reverts, but IMNSHO ended very well. Also, this was a large work that took many time, and I'm just writing some records here.

[April 26, 2012] #ubuntu 12.04 LTS released with Firebird 2.5.1

Ubuntu LTS is released and includes the latest firebird stable release 2.5.1

[April 26, 2012] Massive code changes: Getting rid of legacy code dsql_nod

Adriano Fernandes finished a massive code drop and rewrite: Getting rid of dsql_nod

[April 24, 2012] Firebird in AppWave store

Embarcadero just released the AppWave Store, with plenty of free apps available. And our loved bird is listed in the mainpage, in the "popular apps" listing.

http://www.appwavestore.com/firebird.html  

[April 21, 2012] Testing Codeigniter with Firebird

This was written on albringas.com:
I’ve been using Codeigniter as my development platform and framework of choice since last year. Being a ten year PHP developer, Codeigner was a refreshing way of coding web apps with PHP.

The first ones developments I did with Codeigniter were using MySQL, a very used database. But since I’ve also been using Firebird SQL Database from ten or more years ago, I decided to give a try to the Codeigniter-Firebird duo.

Read the rest of the adventure

[April 20, 2012] "Hopper for Firebird", beta 4 released

Upscene Productions announces the 4th public beta of: "Hopper a Stored Code Debugger". This release fixes several issues as reported by you, our users, and adds a Help file.

For more information and a trial download, see the news @ Upscene Productions, pricing information is available.

You like this news? Twitter it! Share it! If you'd like to blog about it, contact us!

[April 20, 2012] #AnyDAC Spring 2012 v 5.0.7 — #Delphi Components for Firebird, Interbase and more

DA-SOFT Technologies announces the availability of AnyDAC for Delphi Spring 2012 release v 5.0.7.2333 — high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, Advantage, dbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications.
AnyDAC for Delphi can be immediately downloaded from the download page.

What is new in v5.0.7 and what is AnyDAC?

AnyDAC v 5.0.7 Highlights
  • Delphi XE2 and Mac OS X support;
  • FPC 2.6.0 / Lazarus 0.9.30.4 and Windows x86/x64, Linux x86/x64 and Mac OS X support;
  • UpdateOptions.UpdateJoinedFields and TADMapRule.NameMask added;
  • Auto-inc fields improvements;
  • SQLite v 3.7.11 support;
  • SQLite native Array DML support;
  • SQL Server 2012 support;
  • Advantage DB TADADSUtility service component;
  • Advantage DB support for aliases;
  • ReportBuilder DADE;
  • Nany driver and addon improvements;
  • Multiple enahncements to the help system.
And more.

AnyDAC for Delphi

AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage and more. For complete list of features and availability, please check: AnyDAC Core Features
  • Native access to Firebird, MySQL, SQL Server, Oracle, PostgreSQL, SQLite, DB2, InterBase, SQL Anywhere, Informix, Advantage Database and more. Including latest DBMS versions.
  • Generic access to any database supported through dbExpress or ODBC data sources.
  • Optimized for best possible performance. 2 times faster than dbGo, 25% faster than dbExpress.
  • Reach API with 50 Delphi VCL components, including TADConnection, TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable.
  • Unified API for cross-database access, including unified data type mapping, SQL dialect abstraction, connection aliases.
  • First-class support for many database-specific features, including backup, restore, validation, SQL scripting.
  • Advanced Data Access Options, including Array DML, Live Data Window mode, full Unicode support.
  • Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus / Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X.
  • Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.
AnyDAC Natively Supported Databases
  • Enterprise  — Oracle, SQL Server, IBM DB2, Informix.
  • Workgroup  — Firebird, Interbase, MySQL, PostgreSQL, SQL Anywhere, Advantage DB.
  • Database in clouds  — Microsoft SQL Azure.
  • Desktop  — SQLite, MS Access, BlackFish SQL, MS SQL CE, Advantage DB.
  • Embedded  — SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
  • Bridges  — dbExpress, ODBC.
With best regards,
DA-SOFT Technologies Team

[April 19, 2012] ANN: FB TraceManager V2.5.2 available

Upscene Productions is proud to announce FB TraceManager V2.5.2, a professional environment to monitor, profile, trace and optimize Firebird databases.

More information on the new release is available here: http://www.upscene.com/displaynews.php?item=20120416

This release fixes a critical stability issue and includes various minor bugfixes and adds experimental Firebird 3 trace support. There are also the following new screencasts available:

More information on the product is available in the FB TraceManager section on our website, including an edition comparison sheet, webcasts etc.: http://www.upscene.com/go/?go=fbtm


[April 18, 2012] Searching for Firebird programmer

I got this in my email box, maybe some of you would be interested:
Dear Carlos,
 
I came across your name asking developers to send details of large companies who use firebird databases. I am actually an end-user who has the open mind to want a firebird database but cannot find anyone who does this programming. I am based in the UK and am told to 'steer away' from firebird as it is not proven, etc. etc.
 
It really is quite disappointing and seems that there are many others like myself who would like to have an alternative but cannot find a developer. So I am the horse looking for water to drink — but there is no water...not like you describe leading the client to the water but not getting them to drink.
 
Any suggestions?
 
JT <tse.tse@ntlworld.com>
PS: It is weird that in the actual days, with so many great case studies published, there are still people who thinks FB is a "toy".

[April 18, 2012] MVC 4 / Firebird / EF 4.1 and Database First

Recently viewed a great presentation by of Steve Sanderson (blog.stevensanderson.com) on using SPA with MVC4. I tired with FB 2.5 and it works great. I've written my first blog This shows how to change the default behavior from Code First to Database First with these new technologies. I just wanted to contribute the list.

Thanks,
John R. Tomaselli

[April 13, 2012] Firebird V2.0.7 has been released likely to be the last for the 2.0-series

Firebird V2.0.7 has been released.

This sub-release 2.0.7, likely to be the last for the 2.0-series, does not add any new functionality to the database engine. It incorporates a number of bug fixes that did not make it into the v.2.0.6 sub-release in June 2010 or have been backported from subsequent 2.1.x and 2.5.x releases.

This release 2.0.x contains a large number of new features compared with 1.5.x, including derived tables, support for Execute Block, increased table sizes, new improved index code (the 252-byte index length limit is no longer applicable), expression indices, numerous optimiser improvements, enhanced security features, support for on-line incremental backups along with numerous other improvements and bug fixes.

[April 12, 2012] Firebird Download stats for April

Here are the Sourceforge stats from the beginning of the poject until now (The number of downloads passed 11,3 Millions).

I excluded the year 2000 (there were no file releases on sf then).

Also the sf logo impressions look interesting (Maybe it should be put back on the front page).

[April 08, 2012] Beta version of Jaybird 2.2 released with support for jdbc 4.1

The Firebird JDBC team is happy to announce the release of Jaybird 2.2.0 beta-1.

This release contains the following changes:
  • Enhanced support for JDBC 4.0 (Java 6),
  • Support for JDBC 4.1 (Java 7) — including try-with-resources support,
  • Implementation of getGeneratedKeys(),
  • Enhanced support for the services API,
  • Support for 64 bit native libraries for Type 2 / Embedded,
  • A number of bug fixes.
The beta release is also available on Maven (*):
<groupId>org.firebirdsql.jdbc</groupId>
<artifactId>jaybird-jdkXX</artifactId>
<version>2.2.0-beta-1</version>


The artifactId depends on your target Java version: jaybird-jdk15, jaybird-jdk16 or jaybird-jdk17.

*) As this is the first release to Maven and we need manual authorization from Sonatype, it can take several days before the artifacts are really available on Maven.

Mark Rotteveel

[April 07, 2012] Jaybird 2.2 beta hopefully will be released this weekend with jdbc 3.0 and open/libre office support

News via Mark Rotteveel on twitter:
Finishing touches to Jaybird 2.2 beta releasenotes, hopefully I will be able to finally release it this weekend
ps: Jaybird 2.2 is the next Firebird jdbc driver release with many fixes which will include improved support of the JTA specification (XADataSource and XAResource interfaces). Additionally it already has improved support for OpenOffice.org/LibreOffice Base component, which deviates in some places from the JDBC 3.0 specification.

[April 06, 2012] TurboBird for 0.9.1 is released with minor bugfix (64 bit build)

You can check the homepage for download links for all platforms also there is github page where you can contribute.

Also for changelog please scroll down to the bottom of the project's home page: Minor bug fix, producing 64 bit version, because 32 bit cann't start in Linux Mint DE 64 bit.

[April 06, 2012] Differences between recreate procedure and create or alter procedure

I was recently in a talk related to Firebird and I found, that people are not aware of these two constructs. Either they don’t know both or don’t know they differ. These statements are doing similar stuff, but the evil is in details.

[April 04, 2012] Perl driver DBD-Firebird 1.00 is released

Here is the full Changelog and you can use your Cpan mirror near you

You can contact the developers on dbd-firebird-devel mailing list.

[April 02, 2012] RAD Studio survey

There is a new RAD Studio (Delphi,etc) survey on-line, from Embarcadero. Firebird is mentioned so, go ahead and participate if you use Delphi, CBuilder, etc.

[April 02, 2012] Firebird 2.5.2 package updated in Debian testing and sid (svn snapshot)

New Debian package is uploaded to debian testing and unstable releases, and here is the list of changes.

About the Newsletter

You can unsubscribe from the newsletter at any time.
March 21, 2012
Editorial

In the editorial for the 3d issue of Firebird SQL newsletter we'd like to draw your attention to the upcoming Firebird 3. Firebird Project needs more testers for Firebird 3, and even if you are short in time, you can help Firebird with very simple quick test - download Firebird 3, make backup backup/restore of your current Firebird database and try to work with it.

Firebird 3 snapshots (as well as current development snapshots for 2.5.2 and older releases) are available here:
http://www.firebirdsql.org/en/snapshot-builds/

To report your findings, please use Firebird Tracker: http://tracker.firebirdsql.org (don’t forget to search it for the similar problem).

Community News Index (www.firebirdnews.org)

The news below was collected from FirebirdNews site. You can periodically visit the site or subscribe to its RSS feed to keep up to date in almost real-time with all the news coming from the Firebird community.

Community News

[March 20, 2012] Node.js Firebird driver 0.0.9 is released (tagged)

Here is the download page and you can check the Commit History for interesting changes (new features)and fixes (memory leaks , utf-8 char fields encoding handling).
  • Fix for slda improper init
  • Fixed memory leak for situation when single connection was used several times for several async queries, it also was making server to eat memory
  • Fix to stream for char fields in UTF encoding
  • Added async transaction start
  • One fix to allow run execute procedure (and tests were added)

[March 20, 2012] Firebird ODBC driver 2.0.1 released

I have built Firebird ODBC driver 2.0.1 release today. I have uploaded all files into sourceforge area.

All changes you can look in the file — changes-v20.log.

Regards,
Alexander Potapchenko

[March 17, 2012] Firebird roadmap has been updated

From Dmitry Yemanov:
The project roadmap has been updated a bit. The change is to boost the v2.1.5 and v2.5.2 releases at the cost of slightly delaying the v3.0 Alpha release.

Firebird 2.1.4 was released exactly one year ago, so now it's a promised time for v2.1.5. It has 53 bugs fixed and no critical issues remaining unresolved. Firebird 2.5.1 was released more than 5 months ago and the expected release date for v2.5.2 is approaching the next month. It has 45 issues resolved up-to-date and a few more are in the pipeline. So it makes a lot of sense to release them sooner rather than later.

The v3.0 Alpha release will be going through the preparation stage while all three release candidates (v2.0.7, v2.1.5, v2.5.2) are being field tested, so it's likely to appear shortly after the aforementioned releases, in the second quarter.

Thanks for your understanding.

[March 17, 2012] Generic thoughts about the Firebird network performance

Dmitry Yemanov wrote a series of articles related to Firebird network performance:
  • First article is: Generic thoughts about the network performance
  • Second article is: Protocol packets and buffers
  • And the last one is: Records batching.

[March 16, 2012] Lazarus 0.9.30.4 released and is now based on Free Pascal Compiler 2.6.0

The Lazarus team is glad to announce the 0.9.30.4 release. This release is based on fpc 2.6.0.

[March 16, 2012] Database Workbench 4.2.2 released

Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: "Database Workbench 4.2.2 Pro". For more information, see here.

Click here for the full list of changes in v4.2.2
Click here for the full list of changes in v4.2.1

Click here for the full list of changes in v4.2.0
Don't forget to take advantage of our 20% St.Patrick's Day Weekend Discount!

The free Lite Editions will be released next week.

Database Workbench supports:
  • Borland InterBase (6.x-XE)
  • Firebird (1.x, 2.x)
  • MS SQL Server/MSDE (7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express)
  • MySQL 4.x, 5.x
  • Oracle Database (8i, 9i, 10g, 11g)
  • Sybase SQL Anywhere (9, 10, 11 and 12)
  • NexusDB (3.0 and up)
You like this news? Twitter it! Share it! Blog about it!

[March 15, 2012] Free Pascal full text index/searcher classes committed in Lazarus svn

ХудожникMichael Van Canneyt announced his full text indexer project:
I've committed a file/database indexing and search engine, fpindexer, to SVN.

It was developed by Darius Blaszijk, with help from me. One of the planned uses is to create searchable documentation. I've also (in a private project) used it to implement full-text search on a database that doesn't support that natively.

[March 15, 2012] Django south fork with support for firebird was merged into main trunk (original project)

News via Maximiliano Robaina and here is the patch. To check more about the project you can check it's homepage.

[March 14, 2012] Time Track is a program written in Lazarus and tiopf to allow people to track projects (with Firebird backend)

See the lazarus full thread and you can clone the git repository.

It's a small app that sits in the tray, and can be used to manage project time. If there is interest, I can donate it to the Lazarus community. It also serves as a nice example of how to program Lazarus and tiOPF.

It also keeps a todo list and a list of interruptions. (the helpdesk walks in and out of my office, which I started tracking to prove that this practice costs me 1.5 hours a day.)

I posted the project at http://www.freepascal.org/~michael/timetrack.zip

You'll need tiOPF and a database server. I use (and recommend) Firebird, but changing it to something else takes about 2 lines of code.

The included time.sql file creates the database.

[March 13, 2012] ANN: FB TraceManager V2.5.1 + New Screencasts available

Upscene Productions is proud to announce V2.5.1 of FB TraceManager, a professional environment to monitor, profile, trace and optimize Firebird databases.

More information on the new release is available here: http://www.upscene.com/displaynews.php?item=20120313

This release extends the per-database monitoring capabilities with database statistics (data/index pages and record version information) monitoring. Adds support for ODS 11.1 (Firebird 2.1) monitoring tables and several other improvements and fixes. In combination with the Trace API, this is a powerful and integrated toolset to optimize and tune your Firebird server, database and client application even further.

There are also the following new screencasts available:

More information on the product is available in the FB TraceManager section on our website, including an edition comparison sheet, webcasts etc.: http://www.upscene.com/go/?go=fbtm


[March 12, 2012] "Hopper for Firebird", beta 2 released

Upscene Productions announces the 2nd public beta of: "Hopper a Stored Code Debugger".

This release fixes several issues as reported by you, our users, and introduces Firebird 3 Stored Functions support.
For more information and a trial download, see the news @ Upscene Productions, pricing information is available.

You like this news? Twitter it! Share it! If you'd like to blog about it, contact us!

[March 09, 2012] Firebird 2.07 RC

The Firebird Project team is happy to announce that the v2.0.7 release candidate kits for Linux, Windows and Mac OS X platforms are ready for testing.

The download page: http://www.firebirdsql.org/en/firebird-2-0-7-rc1/

Enjoy the testing and please don't hesitate to report the found regressions (if any) in the Firebird-Devel list or in the bug tracker.

Regards,
Dmitry

[March 02, 2012] The Firebird Book: a Reference for Database Developers Edition II (Beta) is now available

The Firebird Book: a Reference for Database Developers Edition II (Beta) is now availble directly from IBPhoenix in electronic format on the March 2012 Edition of the Developer DVD. It covers Firebird up to Firebird V2.5.
 
If you buy a copy of the early version, you will have automatic accessto updated versions as they are released.If you have a subscription to the IBPhoenix Developer DVD you will automatically recieve your copy via post shortly.

www.ibphoenix.com

[February 29, 2012] Philippe Makowski finished the port of FDB (Firebird Driver) to Python 3

Philippe Makowski wrote on google plus:
I finished the port of FDB to Python 3 all tests seems ok next step: merge into FDB upstream
You can grab it there: https://github.com/pmakowski/fdb/tags (tag is v0.1) git repo: https://github.com/pmakowski/fdb

[February 28, 2012] Timeout records Feature request

For several years now, I'm yearning for a feature that I think that all SQL based databases that I know are missing, and throw it back to the program side.

The feature I wish to have is a way to set a specific record to be valid for only a known period of time, and when the time is up, I'll be able to do something.

In this post I'll try to create some sort of general specification for such feature, and I hope that there will be many comments on this that will benefit everyone, and I hopeful, that they will make the idea better.

[February 28, 2012] Upscene Productions announces "Hopper", a stored code debugger for Firebird

Upscene Productions is proud to announce the first beta of a new tool: "Hopper a Stored Code Debugger".

This beta is available for Firebird, after it's version 1 release, an InterBase Edition will be made available soon, a MySQL Edition will follow later this year.
For more information and a trial download, see the news @ Upscene Productions, pricing information is available.

March 1 Update! New installer uploaded to fix a problem with missing syntax highlighting files.

You like this news? Twitter it! Share it! If you'd like to blog about it, contact us!

[February 27, 2012] FDB python driver implements services (Python 3 only for the moment)

Philippe Makowski announced that he just committed new files in github fdb repository.

He implemented firebird services api for Python 3 driver, this driver version doesn't work yet for Python 2, and it is only the first step.

Certainly some improvements would be welcome.You can see diff here.

The hope is that he will start working on fbcore soon  

[February 26, 2012] Firebird: choosing an owner for database deployment

Like most users when I started using Firebird I connected using the SYSDBA username. That is the default username for server administration: every server has it.

It looked like a good idea because I did not have to care with users management, but I have now realized that using SYSDBA for database development can cause problems when the database is deployed to the customer's computer.

Read the rest on Accounting++ blog.

[February 23, 2012] Database .NET 6.0 released

 Hi! I am happy to announce the new major release of Database .NET 6.0 Database .NET is an innovative, powerful and intuitive multiple database management tool, you can Browse objects, Design tables, Edit rows, Export data and run Queries with a consistent interface. A standalone tool that does not require installation.

Click here for the full list of changes in Ver 6.0 (2012/02/23)

Features:
Supports:
  • Firebird Super/Classic/Embedded Server (*.gdb;*.fdb;*.*)
  • SQL Server 2000/2005/2008/2008R2/2012
  • SQL Server CE 3.1/3.5/4.0 (*.sdf;*.*)
  • SQL Server Express and LocalDB
  • SQL Azure
  • SQLite (*.db;*.db3;*.sqlite;*.*)
  • MySQL
  • PostgreSQL
  • Oracle
  • IBM DB2
  • IBM Informix
  • Sybase ASE
  • MS Access 97-2003 (*.mdb;*.*)
  • MS Access 2007-2010 (*.accdb;*.*)
  • MS Excel 97-2003 (*.xls;*.*)
  • MS Excel 2007-2010 (*.xlsx;*.*)
  • dBase IV (*.dbf)
  • FoxPro (*.dbc)
  • Data Sources(OLE DB) (*.udl;*.*)
  • ODBC DSN(Data Source Name) (*.dsn;*.*)
  • OData
All-In-One, Free, Simple and Standalone (no install).
 Supported Platforms: Windows All (x86/x64)
 Requires: .NET Framework 4.0 or higher
You're welcome to download the Database .NET v4 right now at: Download: DatabaseNet4.zip (7.03MB)

[February 23, 2012] New IBExpert Version 2012.02.21 available

News from ibexpert page New Data import, Extract metadata and Search metadata features, new IBEBlock functions, and more New features include:
  1. Data import: now you can convert Boolean values to smallint values when importing data into a new table. You can also now automatically generate simple column names for the target table.
  2. To-Do list: now you can duplicate To-Do items.
  3. Extract metadata: New Always include COLLATE option.
  4. Search metadata: New Do not search in comments option.
  5. New IBEBlock functions and features.
  6. Many small bug fixes and minor improvements.
Since version 2011.12.01 IBExpert now uses the Firebird database and Firebird Embedded 2.5 to store all IBExpert data (registered databases, query histories etc.) by default. In previous versions by default IBExpert stored this data in the IBExpert.stg file and the user was able to change this manually in Options / Environment Options / User Database. Working with IBExpert.stg is still possible (for example, if you disable the User Database manually), but you will get a warning every time you start IBExpert, and we will not support this method in the future.
  • The Customer version (setup_customer.exe) can be downloaded here (for customers with valid license keys). You can also download the customer version in theIBExpert KG Download Center. If you can not see it there, you might have used a different e-mail in the customer registration process or your account has already expired.
  • The Trial version (setup_trial.exe) can be downloaded here (45 day test version) or from the IBExpert KG Download Center.
  • The free Personal version (setup_personal.exe) can be downloaded here (version with limited features free of charge).

[February 22, 2012] We are currently preparing to release Firebird 2.0.7

From Paul Beach's Blog:
We are currently preparing to release Firebird 2.0.7, since I take responsinility for the Mac builds, I did a 2.0.7 build on MacOSX 10.7 using the development tools installed by XCode 4.1 (gcc 4.2.1 etc). I set up the relevant environment variables for this older 32bit only build CFLAGS, CXXFLAGS, LD_FLAGS and also set the MACOSX_DEPLOYMENT_TARGET=10.4. The builds completed without any problems, some simple tests on MacOSX 10.7 showed no problems.

Now — Imagine my surprise when Philippe told me that when he tried to QA the builds on MacOSX 10.5 we got this error on SuperServer startup.

[February 22, 2012] The bleak future of SSD drives

The technology trends we have described put SSDs in an unusual position for a cutting-edge technology: SSDs will continue to improve by some metrics (notably density and cost per bit), but everything else about them is poised to get worse.

This makes the future of SSDs cloudy: While the growing capacity of SSDs and high IOP rates will make them attractive in many applications, the reduction in performance that is necessary to increase capacity while keeping costs in check may make it difficult for SSDs to scale as a viable technology for some applications.

Not good news, specially for those thinking about using the for critical work, like database servers.

Read full research here (in English). Short article in portuguse here.

[February 16, 2012] ANN: FB TraceManager V2.5.0 with per-database monitoring released!

Upscene Productions is proud to announce V2.5.0 of FB TraceManager, a specialized tool to continuously monitor your Firebird database via the Firebird 2.5 Trace API.

More information on the new release is available here: http://www.upscene.com/displaynews.php?item=20120215
Beside the Trace API stuff, V2.5.0 now adds per-database monitoring including:
  • Database header page monitoring
  • Full Firebird monitoring (MON$) tables integration
In combination with the Trace API, this is a powerful and integrated toolset to optimize and tune your Firebird server, database and client application even further.

Read more about per-database monitoring here: http://www.upscene.com/documentation/fbtm2/database_monitoring.htm

More information on the product is available in the FB TraceManager section on our website, including an edition comparison sheet, webcasts etc.: http://www.upscene.com/go/?go=fbtm

The full product documentation is also available online: http://www.upscene.com/documentation/fbtm2/index.html

[February 16, 2012] Database Workbench 4.2.1 released

Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: "Database Workbench 4.2.1 Pro". This release includes the FREE Lite versions for InterBase, Firebird and MySQL. For more information, see here.
For a video explaining how to debug a Firebird Stored Procedure, click here.

Click here for the full list of changes in v4.2.1
Click here for the full list of changes in v4.2.0

Database Workbench supports:
  • Borland InterBase (4.x-XE) 
  • Firebird (1.x, 2.x)
  • MS SQL Server/MSDE (7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express)
  • MySQL 4.x, 5.x
  • Oracle Database (8i, 9i, 10g, 11g)
  • Sybase SQL Anywhere (9, 10, 11 and 12)
  • NexusDB (3.0 and up)

[February 15, 2012] Kitto A framework for creating data-driven web applications with Delphi and ExtJS

Kitto allows to create Rich Internet Applications based on a data model that can be mapped onto any database. The client-side part uses ExtJS (through the ExtPascal library) to create a fully AJAX application, allowing you to build standard and advanced data-manipulating forms in a fraction of the time.

Kitto is aimed at Delphi developers that need to create web application without delving into the intricacies of HTML, CSS, Javascript or learning to use a particular library such as ExtJS, yet it allows access to the bare metal if required.

Kitto includes a database-agnostic data-access layer, allowing to create applications that work on any database engine and port applications between database engines.

A Kitto application is described in a set of easily maintained YAML files, keeping definitions abstract and declarative and allowing for future extensions. Business rules are enforced either declaratively or through small javascript fragments on the client, or in Delphi code on the server.

Kitto was designed by Nando Dessena and its development is sponsored by Ethea, which uses Kitto for internal development projects and client work and provides Kitto-related tools, support and development services.

Start here for further information.



The getting started guide can be tested with Firebird and Delphi

 

[February 14, 2012] Piwik port for Firebird

Lester created a port for piwik 1.6, that can be downloaded at following url: http://lsces.co.uk/hg/piwik/archive/FBPort.tar.gz

His progress can be tracked on firebird-php list (you can give the feedback on the same thread.

[February 14, 2012] ANN: Firebird Data Sync 12.2 released

Firebird Data Sync
SQL Maestro Group announces the release of Firebird Data Sync 12.2, a powerful and easy-to-use tool for Firebird database contents comparison and synchronization.

Major features of the new version include comparison of database views and subsets of data, automatic checking of mappings, and exporting the comparison results to 18 file formats including Excel and HTML. There are also versions for other DBMS (MySQL, PostgreSQL, SQLite, Oracle, etc). Read full press-release.

[February 14, 2012] The Document Foundation Announces LibreOffice 3.5: The Best Free and Libre Office Suite Ever

The Document Foundation announces LibreOffice 3.5, the third major release of “the best free office suite ever”, which shows to end users the improvements derived from the development strategy adopted since September 2010.

LibreOffice 3.5 derives from the combined effort of full time hackers the largest group of experienced OOo code developers and volunteer hackers, coordinated by the Engineering Steering Committee.

Related to Firebird there is the ODBC linux 64 bug killed.

Also the db with no bool support (Firebird 2.5) issue is done.

[February 14, 2012] Firebird Embedded and LibreOffice is the killer combination to scale from a single file application to a client/server approach

Quote of the day is via this thread on Firebird Java Group:
It would be good if Jaybird 2.3 could be used with embedded and OpenOffice / LibreOffice because the feature set in Firebird is obviously much, much greater than HSQL or the proposed SQLite replacement.

The ability to create a zeroconf, transportable data file is of interest to me (along with using iReport to generate printouts from that file).
 
OT: Personally I think that Jaybird / Firebird / Firebird embedded is the way to go for LibreOffice instead of the very limited SQLite. The ability to upscale from a single file application to a client/server one is a killer.

[February 11, 2012] New FlameRobin 0.9.3.2216 builds for Ubuntu 11.10 (Oneiric) and Debian Sid

Flamerobin 0.9.3 revision 2216 binary snapshots for Debian Sid and Ubuntu Oneiric are ready to install and test. Enjoy, and please be sure to report any bugs, regressions or suggestions on flamerobin-devel list.

[February 11, 2012] Firebird on large big iron servers: 512G-2TB of ram 100.000 concurrent users

We run Firebird to power larger systems (for 12 government agencies and 3 banks). It has approximately 100000 end users multiplexed through 2500 (max) pooled connections. Here is the snapshot of nearly idle system at night:
top - 03:20:39 up 10 days, 8:39, 7 users, load average: 2.08, 1.87, 2.15
Tasks: 1732 total, 1 running, 1730 sleeping, 1 stopped, 0 zombie
Cpu(s): 11.9%us, 4.0%sy, 0.0%ni, 83.5%id, 0.0%wa, 0.0%hi, 0.6%si, 0.0%st
Mem: 529177288k total, 378587600k used, 150589688k free, 761532k buffers
Swap: 1073741816k total, 130612k used, 1073611204k free, 333281232k cached

[root mvv bin]# ps aux | grep -c rdb_inet_server
719

Database is on a small FusionIO drive:
mount: /dev/fiob on /mnt/db type ext2 (rw,noatime)
df -h:
/dev/fiob 587G 423G 135G 76% /mnt/db

Also later he mentions that he uses 2TB of RAM machines
Chipsets that can handle 2 TB of RAM and 8 CPU sockets (<=80 cores, <=160 threads) are the largest "commodity" type hardware available now. These are the largest systems we worked on. 8 GB of lock manager space per database should be just enough for them. With the allocation error check in place we'll have this problem solved for the next year or two until larger systems become common.

[February 11, 2012] Tpda3 (Tiny Perl Database Application 3) is released

For those who like classic desktop Firebird database applications and wxPerl, the first public release of Tpda3 is out.
 

[February 10, 2012] Phacil is seeking a Project Manager that has experience with Firebird in Arlington, VA for an important US Government customer

Shirin Lee posted a job: Phacil is seeking a Project Manager that has experience with Firebird in Arlington, VA. To learn more and check this job post.

I almost wanted to say that this is spam on the group but at a second look saw the list of
interesting customers for The Company also with a little help from google i found the job post
Phacil has an anticipated need for a Project Manager (Senior) for an important government customer in Sterling or Arlington, VA.

Clearance Requirements
Must have at least a Secret clearance

Scope
Experience project managing large IT projects including cost, schedule and performance management is required. Experience managing the execution of project tasks, Risk Management, Quality Control (QCP) and communication management are required.

Qualifications

Must have previous Task Manager/Project Manager experience of at least 5 years
Bachelor’s Degree with Masters Preferred in Computer Science or Information Technology
PMP highly preferred
Experience managing the system administration, training and support for the Firebird database management system is required. Conducted trainings on FIREBIRD system with users.
Experience with PMP PMBOK/PDCA, ITIL v3 foundations service delivery a plus Firebird database software and tools technology experience required

[February 02, 2012] Firebird .Net Provider Improved "weekly" builds

I've improved the http://netprovider.cincura.net/. It's now returning version build from latest SVN sources (so it's actually snapshot builds now). Again could be unstable, not a good idea to put it to production.

PS: It's reading the build from my internal CI server, that is really old and really not very powerful. Please try not to push it to the limit.

Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com

[February 02, 2012] Ruby driver and RoR adapter Rubyfb v0.6.2 released

Ruby driver and RoR adapter Rubyfb v0.6.2 released.

[February 02, 2012] New Book On Qt And Firebird Database Available In EPUB Format

Logikal Solutions is proud to announce “The Minimum You Need to Know About Qt and Databases” has been released in EPUB format as part of “The Minimum You Need to Know” book series. Currently it is available at Barnes & Nobel as well as Kobo. It should also be available
shortly at the Sony eBook store.



Barnes & Nobel


Kobo

This book shows the nitty-gritty of developing with Qt using PostgreSQL, Firebird, and SQLite databases. It also shows the developer how to create BOTH console and GUI Qt applications. Readers are shown how to do development with Qt Designer, Qt Creator, QDevelop, Monkey Studio, and Eclipse under KUbuntu. Like most of the titles in this series this book attempts to teach by repeatedly developing the same application with each new tool set so developers who understand one or only "some" of a given tool set can quickly come up to speed by looking at the differences each tool forces on the application.

Qt is an amazing application framework currently owned and supported by Nokia. While there are many books available discussing various aspects of the GUI, most give at most a single chapter to database access. This book is designed to cover that topic in depth. The vast majority of applications written today will need to communicate with a database in some fashion, even if it is just to store user entered data locally. Currently there are no books on the market providing any significant quantity of information about how to do it are more importantly just how different your application will be for each database engine.

"The Minimum You Need to Know" is an award winning technical book series written by Roland Hughes and published by Logikal Solutions. Please visit The Minimum You Need to Know for information about other titles in this technical book series.

[February 01, 2012] FBDataGuard 2.7: major update of Firebird moniotring and database protection tool

FBDataGuard was just updated to the version 2.7. Download it from your IBSurgeon Deploy Center account or get trial version from the product page.

Please schedule upgrade of your production system (please do upgrade carefully and plan all your actions).

Changes in version 2.7 include support for modern browsers in FBDataGuard web-console, fixed bugs and improved performance.

FBDataGuard is intended to be automatic maintainer and administrator assistant for important Firebird databases, especially at remote locations and being bundled with Firebird-based software.

FBDataGuard

FBDataGuard is designed to provide stability and confidence in business-critical Firebird databases:
  • prevent outages and corruptions,
  • reduce downtime and performance problems,
  • monitor database health and automate maintenance,
  • provide alerts and recommendations.
Also it can be used for advanced database recovery of protected database in case of heavy corruption (e.g., caused by hardware failure).

[February 01, 2012] Firebird case study from Wobe-systems GmbH

New Firebird case study from wobe-systems GmbH, German software development house for the graphics industry.

"...A production database of 100 GB and more containing BLOBs is nothing unusual at our customers sites..."

".. Firebird SQL server is at the core of our system helping our customers swift and safely through their daily work. Equipped with near zero administration and ample possibilities of scalability Firebird SQL database offers an operational reliability that does meet the requirements of industrial and time critical applications."

Read full article here.


FDB release 0.7.1 is out:
This is mostly bugfix release. The main notable difference is that now FDB works on Windows (0.7.0 wasn't) and is operational "enough" to power the Firebird QA tools. So the forthcoming Firebird 2.0.7 release (scheduled for February) will be tested using FDB.
 
News via Pavel Cisar Google+ Page

[January 31, 2012] InfoQ: Q&A with Jiri Cincura of the Firebird Database Project about the ADO.NET provider , ORM ,EF ...

Jiri Cincura was recently interviewed for InfoQ article Q&A with Jiri Cincura of the Firebird Database Project. We touched Firebird, ADO.NET, O/RMs, Entity Framework etc. If you have any questions, feel free to ask.

Update
: The article seems to be retracted for the moment. Don't panic we asked why and investigate the cause (see the comments section).

Here
is the full text from Google cache

We recently spoke with Jiri Cincura of the Firebird database project.

InfoQ: Can you tell us briefly about yourself and your role in creating the ADO.NET provider for Firebird?


Jiri: Currently I'm project lead for the ADO.NET provider for Firebird project. And actually only one active right now. I'm doing majority of development (although there are some worth contributions) and all the stuff around, like testing, releases, issue tracker watching, replying in mailing list etc.

InfoQ: And for the benefit of our readers who are unfamiliar with it, who would you describe Firebird?

Jiri: Firebird is a fully featured RDBMS, with small footprint and zero maintenance. It supports all standard features you'd expect - stored procedures, triggers, views, UDFs, monitoring, online (remote) backup/restore etc. There's also so called Embedded version, that just one main DLL and few supporting it, without install or need to copy something somewhere. You'll just reference this DLL and you have all the features of standalone (network) Firebird in your application. And of course, whole Firebird is completely free (and open source).

InfoQ: In the SQL Server world we have to deal with a serious trade-off. If you choose to use the embedded version, SQL Server Compact, then you lose the ability to use a lot of features. Is there any sort of tradeoff like that for Firebird or do you really get access to the whole feature set either way?

Jiri: Absolutely not. Firebird Embedded is fully featured as "big" server. It's even built from same sources, only with different output (DLL file). You can use everything Firebird offers. And not only that. Migration is super easy. You'll just take the database file and put it to some place where server can access it and you're done.

InfoQ: So what's involved in writing a ADO.NET provider?

Jiri: It's actually pretty simple. You're fixing bug, moving with features as Firebird server moves further and improving stability and code itself. Cleanup, refactoring. With all that you're trying to keep backward compatibility and not introduce some breaking changes. And on the other hand you're moving along with .NET and ADO.NET (i.e. Entity Framework) world and other data access providers and components.

InfoQ: DId you also work on the Entity Framework provider? If so, what's your opinion of the ORM?


Jiri: Yes I did. I worker on provider since early versions around 2007. I believe Firebird was first 3rd party ADO.NET provider to have working Entity Framework support (and it's open source). I think Entity Framework is good ORM, comparable to others, like LLBLGen Pro or NHibernate. It's not here that long but still very good. I don't think anybody can say i.e. NHibernate is best because ... Every project needs something more and something less. And every ORM (including Entity Framework) has strong points and places where there's room for improvement.

InfoQ: What areas in particular do you think the .NET-based ORMs need to improve upon?

Jiri:
There's mismatch between relational world and OOP world, even if you believe ORMs are hiding it, it's there. For simple small applications, this is not a problem. But for a big applications, the ORM needs to be flexible enough to allow really experienced developer hook in and in rare cases when performance is critical or special needs are placed in front of him/her allow to do it own way without creating huge disruption in your code.

InfoQ: If you had more resources available to you (i..e. developers, hardware, etc), what would you like to do with Firebird and .NET that you can't do right now?

Jiri: Provide more seamless experience for .NET developers using Firebird and improve codebase. Move further faster and provide more features, both from Firebird world and (ADO).NET world.

[January 31, 2012] Flamerobin 0.9.3 svn revision 2212 is now uploaded to #debian sid

The flamerobin version 0.9.3 revision 2212 is now in published in debian sid.

[January 31, 2012] Flamerobin 0.9.3 svn revision 2212 is now uploaded to ppa for #ubuntu oneiric

The package is now in ubuntu oneiric ppa.

To install it use
sudo add-apt-repository ppa:mapopa/ppa
sudo apt-get update
sudo apt-get install flamerobin

or if you have already installed
sudo apt-get dist-upgrade.

[January 30, 2012] New python fdb driver works on Python3 (in git repository only)

The new driver fdb is branched in github for Python 3.x (work in progress).

You can check the progress by following this thread on firebird-python list and here is another one.

[January 25, 2012] FirebirdDA: Firebird database adapter for Zope2

ИконописInitial release of Firebird database adapter for Zope2.

[January 24, 2012] Flamerobin New snapshot 0.9.3.2210.* builds

New snapshot builds (SVN revision 2210) for Windows 32 and 64 bits are available on SF.net.

Feedback on field and text delimiter settings for save grid data as CSV file command would be especially welcome.

Thanks
Michael Hieke

[January 23, 2012] What version of Firebird do you use? Poll time

There is a new poll on linkedin about the Firebird versions.

[January 21, 2012] Firebird speed RUBY vs DELPHI vs .NET

I did some comparitions selecting 1000, 10000 and 100000 with Ruby Fb gem, Delphi Fibplus and the FB .NET driver, here is the result:
 
ROWS
RUBY
DELPHI
.NET
1000
0.12
0.47
0.09
10000
0.94
0.48
0.53
100000
10.95
3.79
5.53

The results are on milliseconds, the table is from a production database with 40 fields and about 3 million records, as you can see, native code is still the king, .NET result are quite good, but Ruby is quite dissapointing handling lots of data.

[January 20, 2012] DBInfo new IBSurgeon product

IBSurgeon DBInfo is designed to visualize internal structure's statistics, so administrators or developers can view how much data, index, blob or other kind of information your Firebird or InterBase database stores.

DBInfo is a free tool, download it now: http://ib-aid.com/products/firebird_interbase/monitoring/dbinfo
IBSurgeon DBInfo

More information at IBSurgeon official site.

[January 19, 2012] The trunk of django-firebird was updated with support for django 1.3

The svn trunk of django-firebird was updated with support for django 1.3 Please, feel free to try. Any feedback is welcome.

[January 18, 2012] ANN: django firebird with south support

Maxi Robaina wrote on django-firebird list:
I've a first attempt for support firebird into django-south. You can give a try at https://bitbucket.org/maxirobaina/south Feedback is wellcome.

[January 18, 2012] Delphi and Firebird: Marco Cantu's webinar is now uploaded to Youtube channel

Video uploaded to FirebirdSQL channel on Youtube.

Marco Cantu speaks about best practices and approaches to develop Firebird and Delphi applications with dbExpress framework.

[January 18, 2012] IBReplicator V4.0.8 has been released

For more information read the release notes.

[January 16, 2012] FBClone version 2.1.4 is released (bugfix release)

FBClone v2.1.4 is released.This is a "bugfix release" (field "XxX" not found when used against case sensitive databases.)
FBClone can clone a Firebird database in one shot (instead of backup/restore cycle) and pump data from one database to another with the same structure, it handles metadata / data charset conversion and may be useful to ease database owner change process or to migrate a database between two different firebird versions (eg. 2.1 -> 1.5)

[January 16, 2012] Using Embedded Firebird Database In .Net Projects

This post will show an example of using an embedded firebird database in .NET/C# projects.

[January 16, 2012] The Perfect Database Server: Firebird 2.5.1 And FreeBSD 9

Here is the guide on installing Firebird 2.5.1 from FreeBSD 9 Ports and creating your first test database; also we show you how to install Flamerobin GUI (administration tool) and the PHP driver for it. This was tested on fresh FreeBSD 9 on a kvm-linux virtual machine. Download a compressed snapshot of the Ports Collection into /var/db/portsnap.

# portsnap fetch

Or update it. If you are running Portsnap for the first time, extract the snapshot into /usr/ports:

# portsnap extract

If you already have a populated /usr/ports directory and you are just updating, run the following command instead:

# portsnap update

Enter firebird server ports directory:

# cd /usr/ports/databases/firebird25-server

Compile and install firebird server:

# make -DPACKAGE_BUILDING
# make install

Enable it by adding
firebird_enable="YES"
in /etc/rc.conf.

Start it with:

# /usr/local/etc/rc.d/firebird start

logs and security2.fdb seems to be in /var/db/firebird.

# /usr/local/bin/isql-fb

To create a new database:

SQL> create database "tmp/first_database.fdb;
SQL> connect "/tmp/first_database.fdb" ;
Commit current transaction (y/n)?y

Committing.

Database: "/tmp/first_database.fdb"

SQL>

If you want to create a simple table then insert 1-2 rows and select from it; here is one example:

SQL> CREATE TABLE TEST (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(20));
SQL> show tables;
TEST
SQL> INSERT INTO TEST VALUES (1, 'John');
SQL> INSERT INTO TEST VALUES (2, 'Joe');
SQL> select * from test;

ID NAME
============ ====================
1 John 2 Joe
To quit the isql-fb console, type quit:

SQL> quit
CON>;

For a good open source GUI admin tool you might check the flamerobin administration tool included in ports repository; it can be installed by a simple:

# cd /usr/ports/databases/flamerobin/ && make install clean

To use firebird with php, you will need the php5 driver:

# cd /usr/ports/databases/php5-interbase/ && make install clean

You can choose to compile php with apache support (I have chosen cli, cgi , and apache support); check it if is enabled with:

# /usr/local/bin/php -m


[January 15, 2012] IBSurgeon Log Viewer 2.0 free tool for viewing and analyzing firebird.log

IBSurgeon Log Viewer is designed to facilitate viewing and analyzing long Firebird and InterBase logs. Many Firebird and Interbase developers and administrators do not pay enough attention to the contents of firebird.log (interbase.log), though there is a lot of useful information, which can help to find and resolve various issues with Firebird/InterBase databases.

Originally Log Viewer was IBSurgeon's internal application, which helped to quickly navigate through very long Firebird and InterBase logs, and in version 2.0 it became mature enough to be released for the community. Download free version from IBSurgeon's site.

Install it and open server’s log (usually it's in C:\Program Files\Firebird\Firebird_n_n\ folder). There are also descriptions for log entries shipped with IBSurgeon Log Viewer:
 
IBSurgeon Log Viewer

Feel free to contact IBSurgeon Support if you see suspicious messages in your logs. Don't forget to attach log to the message!

[January 14, 2012] Ricardo Obregón has updated the Firebird PHP 5.3.9 PDO extension in ArchLinux

You can check his tweet and the package page in ArchLinux:
Just updated #php-pdo-firebird package in #ArchLinux User Repo to connect to @FirebirdSQL from PHP 5.3.9. #Firebird http://t.co/XyeaRJE0
If you find this package useful and want to have it in the community repository, please Vote Up!

[January 14, 2012] How to make an efficient check constraint for an e-mail field in Firebird

Question of the day on Stack Overflow is:
How to make an efficient check constraint for an e-mail field in Firebird (if field value not null)?

[January 12, 2012] Value of particular column from all (some) tables in database dynamically

A question came to me last week. It was simple. Given the column I’d like to query all tables in database for this column (with some condition) and get values back. It was on Firebird so I jumped into system tables and generated query on the fly in execute block (aka anonymous stored procedure).

Read the rest on Jiri Cicura blog.

[January 12, 2012] Trace API session at the ADUG Sydney meeting Wednesday January 18th, 2012

The new Firebird 2.5 Trace API will be the topic of the next ADUG (Australian Delphi User Group) Sydney meeting on Wednesday January 18th, 2012 6pm Sydney time. http://www.adug.org.au/meetings/syd/next_meeting.htm

There will be a live stream via GoToMeeting available. Seats might be limited. Feel free to join.

[January 12, 2012] RemObjects Article: Accessing Firebird Embedded databases from Data Abstract for .NET

This article shows how to use Data Abstract for .NET and Firebird Embedded together (and that it’s no effort at all to do this). All you need is to deploy the needed dll’s and to remember about the x86/x64 compatibility caveat.

[January 11, 2012] PHP 5.3.9 released with relevant PDO Firebird changes

PHP 5.3.9 is released.

Here are the relevant PDO Firebird changes included.

PDO Firebird:
  • Fixed bug #48877 ("bindValue" and "bindParam" do not work for PDO Firebird).
  • Fixed bug #47415 (PDO_Firebird segfaults when passing lowercased column name to bindColumn).
  • Fixed bug #53280 (PDO_Firebird segfaults if query column count less than param count).

[January 10, 2012] Firebird from the beginning

It was just released the first webinar video from the Mind the Bird campaign. The webinar is about the history of Interbase and Firebird, by Ann Harrison.

[January 10, 2012] Firebird 2.5.2 svn snapshot 53775 landed in Debian testing

firebird2.5 (2.5.2~svn+53775.ds4-1) package is now in debian testing. You can check the list of bugs fixed for firebird 2.5.2 (not yet released) in the tracker.

Here is the list of debian changes and fixes:
  • Snapshot from upstream's 2.5 branch, revision 53775 
  • control: note -doc doesn't contain release notes (LP#908963)
  • control: change transitional 2.5-dev package to oldlibs/extra
  • control: -common package is arch:all the last arch-specific bit, ibutil was moved to -server-common
  • -classic.init: provide a status option
  • control: 2.5-dev, -classic-common: depend on the same (source) version of -common-doc

[January 06, 2012] Firebird Roadmap updated for January 2012

This document states the current development activities of the project and establishes the estimated release schedule for the foreseeable future. It's getting periodically updated in order to be in line with the reality.

The project's development resources are currently dedicated to the v2.5 and v3.0 versions, with v2.0 and v2.1 versions being maintained on the regular basis.

As notified earlier, the v1.5.x series is not being released anymore. Firebird 1.5.6 was the last release of that series officially published by the project. However, its codebase may still collect some bugfixes occasionally backported from the newer versions. Any subsequent binary releases, should they be necessary, would be available from IBPhoenix on a commercial basis.

Please pay attention that the v2.0.x series celebrates its sixth anniversary this year. So far the project maintenance practice was to discontinue support for the release series older than five years. Thus please be prepared that the next point release (v2.0.7) could be the last one published by the project in that series.

For more details about the anticipated releases, read on.

[January 05, 2012] ANN: Firebird PHP Generator 11.12 released

Firebird PHP Generator
SQL Maestro Group announces the release of Firebird PHP Generator 11.12, a frontend to generate feature-rich CRUD web applications for your Firebird database. The software comes in both Freeware and Professional editions.

New version introduces security enhancements, powerful data export features, new insertion and editing modes, improved project management and a lot of other new features. There are also versions for other DBMS (MySQL, PostgreSQL, SQLite, Oracle, etc). Read full press-release.
 

[January 05, 2012] Paul Vinkenoog started working on the DML chapter for the 2.5 Language Reference.

ikoniPaul Vinkenoog announced on firebird-docs mailing list:
Hi all,

I'm going to start working on the DML chapter for the 2.5 Language Reference. Hope we can do some good work in 2012.

Happy New Year every one!

[January 05, 2012] Vote for Firebird as Database of the Year 2011 at LinuxQuestions

Vote for Firebird as Database of the Year 2011 at LinuxQuestions (must be registered user with at least one post) We must Crush MySQL, MariaDB, Drizzle

http://www.linuxquestions.org/questions/2011-linuxquestions-org-members-choice-awards-95/

[January 02, 2012] Free Pascal Compiler 2.6.0 has been released and adds many post-Delphi 7 language features and adds or improves the support for various platforms

Free Pascal Compiler 2.6.0 has been released and adds many post-Delphi 7 language features and adds or improves the support for various platforms also there are Firebird related fixes to the Database Components.

[January 01, 2012] Firebird 2.5.2 svn snapshot 53775 landed in Debian unstable

firebird2.5 (2.5.2~svn+53775.ds4-1) package is now in debian unstable.

Here is the list of debian changes and fixes
  • Snapshot from upstream's 2.5 branch, revision 53775
  • control: note -doc doesn't contain release notes (LP#908963)
  • control: change transitional 2.5-dev package to oldlibs/extra
  • control: -common package is arch:all the last arch-specific bit, ibutil was moved to -server-common
  • -classic.init: provide a status option
  • control: 2.5-dev, -classic-common: depend on the same (source) version of -common-doc

[January 01, 2012] Official FirebirdSQL video channel launched

Official FirebirdSQL video channel launched and contains the prensentations from the Firebird Conference 2011.

About the Newsletter

You can unsubscribe from the newsletter at any time.
December 29, 2011
Editorial

Firebird Conference 2011 is over. It was very intensive, bright and interesting. I would like to thank conference organizers, Sita Software, and personally Vincenzo Sita and Jas Madhur, for the great event and their hospitality. Also many thanks goes to sponsors, IBSurgeon, vendor of recovery and optimization tools, and IBPhoenix, Firebird support company, for their help in organizing conference.

Here you can find list of presentations and videos at official Firebird channel at SlideShare.com and YouTube.com. For your convenience below you can find the list of presentations with available options:

Firebird Conference 2011: Opening Philippe Makowski, Firebird Foundation Download
View at Slideshare
Review of the Firebird development in 2011/2012 Dmitry Yemanov, lead Firebird architect Download
View at Slideshare
View on YouTube
Understanding the lock manager internals with the fb_lock_print utility Dmitry Yemanov, lead Firebird architect Download
View at Slideshare
View on YouTube
New features of SQL in Firebird Vlad Khorsun, Firebird core developer Download
View at Slideshare
Firebird 3: provider-based architecture, plugins and OO approach to API Alexander Peshkov, Firebird core developer Download
View at Slideshare
What is new in .NET provider (trace support, cancellation and more) Jiri Cincura, Firebird .NET developer Download
View at Slideshare
View on YouTube
Tips for success: Common mistakes in application development with Firebird and how to avoid them Pavel Cisar, IBPhoenix Download
View at Slideshare
Continuous Database Monitoring with the Trace API Thomas Steinmauer, SCCH Download
View at Slideshare
View on YouTube
Firebird and RAID Paul Reeves, IBPhoenix Download
View at Slideshare
Firebird and Linux Philippe Makowski, IBPhoenix Download
View at Slideshare
View on YouTube
Firebird: database recovery and protection for enterprises and ISVs Alexey Kovyazin, IBSurgeon Download
View at Slideshare
Superchaging big production systems on Firebird: transactions, garbage, maintenance Dmitry Kuzmenko, IBSurgeon Download
View at Slideshare
View on YouTube
Migration of big production system: 5000 procedures/triggers, 530 tables and 24/7 uptime Alexander Shaposhnikov, Profitmed,
Alexey Kovyazin, IBSurgeon
Download
View at Slideshare
A Bird and the Web — crossbreeding experience Sergey Mereutsa, DQTeam Download
View at Slideshare
Character Sets and Unicode in Firebird Stefan Heymann Download
View at Slideshare
Handling tree structures — recursive SPs, nested sets, recursive CTEs Frank Ingerman Download
View at Slideshare
View on YouTube
IBObjects Jason Wharton, IBObjects View on YouTube (part 1)
View on YouTube (part 2)
Measuring Firebird I/O Paul Reeves, IBPhoenix Download
View at Slideshare
Firebird meets NoSQL Thomas Steinmauer, SCCH Download
View at Slideshare
View on YouTube
Firebird Python Drivers: Current state and future Pavel Cisar, IBPhoenix Download
View at Slideshare
Firebird Success Story: Sita Software Jas Madhur, Sita Software View on YouTube
Firebird 3.0 Window Functions Philippe Makowski, IBPhoenix Download
View at Slideshare

Community News Index (www.firebirdnews.org)

The news below was collected from FirebirdNews site. You can periodically visit the site or subscribe to its RSS feed to keep up to date in almost real-time with all the news coming from the Firebird community. Community News

[December 28, 2011] Php pdo Firebird Just published # in #ArchLinux User Repository

Ricardo Obregón published the php pdo driver in Arch Linux Repository.


[December 27, 2011] Status of PHP PDO_Firebird as of December 2011

If you have read the previous article about Firebird pdo status then you might now that almost all worked except binding parameters by name (see bug #48877).

But as a gift bug #48877 is fixed in svn, and is already in the php snapshots for 5.4.x, 5.3.x and trunk 5.5.x. So it should all work from the mentioned article. There are still some bugs left but it will be fixed until the end of the year.

PS: I now write the tests and apply the patches for Bugs #47415 and #53280.


[December 25, 2011] #AnyDAC Winter 2012 v 5.0.5 #Delphi Components for Firebird, Interbase and more
DA-SOFT Technologies announces the availability of AnyDAC for Delphi Winter 2012 release v 5.0.5.2073 — high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, Advantage, dbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications.

AnyDAC for Delphi can be immediately downloaded from the download page.

What is new in v5.0.5 and what is AnyDAC?


AnyDAC v 5.0.5 Highlights
  • major TADTable and Live Data Window mode optimization;
  • Firebird v 3 support (packaged procedures, PSQL functions, identity columns, BOOLEAN data type);
  • Firebird COMPUTED BY support;
  • PostgreSQL v 9 support (named parameters, anonymous blocks, enums);
  • Interbase v 6, 7 support;
  • Advantage v 8, 9 support;
  • SQL Anywhere v 12 support;
  • SQLite v 3.7.9 support;
  • ElevateDB ODBC support;
  • ReportBuilder DADE;
  • Multiple enahncements to the help system.
And more.

AnyDAC for Delphi

AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage and more. For complete list of features and availability, please check: AnyDAC Core Features
  • Native access to Firebird, MySQL, SQL Server, Oracle, PostgreSQL, SQLite, DB2, InterBase, SQL Anywhere, Informix, Advantage Database and more. Including latest DBMS versions.
  • Generic access to any database supported through dbExpress or ODBC data sources.
  • Optimized for best possible performance. 2 times faster than dbGo, 25% faster than dbExpress.
  • Reach API with 50 Delphi VCL components, including TADConnection, TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable.
  • Unified API for cross-database access, including unified data type mapping, SQL dialect abstraction, connection aliases.
  • First-class support for many database-specific features, including backup, restore, validation, SQL scripting.
  • Advanced Data Access Options, including Array DML, Live Data Window mode, full Unicode support.
  • Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus / Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X.
  • Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.
AnyDAC Natively Supported Databases
  • Enterprise — Oracle, SQL Server, IBM DB2, Informix.
  • Workgroup — Firebird, Interbase, MySQL, PostgreSQL, SQL Anywhere, Advantage DB.
  • Database in clouds — Microsoft SQL Azure.
  • Desktop — SQLite, MS Access, BlackFish SQL, MS SQL CE, Advantage DB.
  • Embedded — SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
  • Bridges — dbExpress, ODBC.
With best regards,
DA-SOFT Technologies Team


[December 23, 2011] Help testing TcpRemoteBufferSize parameter

The parameter TcpRemoteBufferSize found in firebird.conf is supposed to set the maximum size of a packet being transfered. The default value for Firebird is 8K, and the maximum accepted is 32767. Theoretically, bigger packets should make the transfer of large resultsets faster (mostly noticed when connection is high latency networks, aka internet).

Recently, I did some tests with this parameter, but wasn't able to find any differences in the time of a fetchall with a select first 2000 * from some_table_with_no_blobs_and_lots_of_records. A similar test that I did last year, with different FB version and O.S. showed a speed increase of almost 3x in the fetchall time when the packet size was set to 32K, but seems that I cannot reproduce this with my current environment anymore.

If you have some time, please do some tests with this parameter, and publish the results in the comments of this post. Remember to test changing the value at client, at server, and at both, and to mention what Firebird version was used (at server, and client library too, if different). Also, I recommend to run the first select/fetchall at last one time before getting the results, to fill Firebird and O.S. cache and get more accurate results.

If you are a "hardcore" user, you may also want to install Wireshark and have an inside view of the communication process.


[December 22, 2011] List of bugfixes added for next release of FDB Python driver (0.8.0)

Pavel Cisar announced on Python Firebird list:

I forgot to mention that you can use our JIRA tracker to submit bug reports and feature requests for FDB.

And you can check already the TODO list of fixes for the next release.


[December 22, 2011] PowerConsole 0.9.2 realeased and tested with new FDB python driver

Pavel Cisar wrote on google plus about the new PowerConsole:
 
It was tested with new FDB driver (see http://ibphoenix.cz/pwc/ for details), i.e. I've just imported fdb as kdb and skipped the kinterbasdb initialization. Surprise, surprise, it works! All issues I was able to find so far were few small bugs in pwcfb module itself :)

So, I released an update to pwcfb that should fix all issues and sets the dependency to FDB.

To install it simply use `easy_install pwcfb` and it should bootstrap it with all necessary dependencies.

pwcfb 0.9.2 : Python Package Index

Extensive package that enables PowerConsole to work with Firebird databases.


[December 22, 2011] Database .NET 5.7 released

 First of all, Merry Christmas to everyone!

I am happy to announce the new major release of Database .NET (v4) 5.7

Database .NET is an innovative, powerful and intuitive multiple database management tool, you can Browse objects, Design tables, Edit rows, Export data and run Queries with a consistent interface. A standalone tool that does not require installation.

New Features(Ver 5.7) 2011/12/22:
Features: Supports:
  • Firebird Super/Classic/Embedded Server (*.gdb;*.fdb;*.*)
  • PostgreSQL
  • SQL Server 2000/2005/2008/2008R2/2012
  • SQL Server CE 3.1/3.5/4.0 (*.sdf;*.*)
  • SQL Azure
  • SQLite (*.db;*.db3;*.sqlite;*.*)
  • MySQL
  • Oracle
  • IBM DB2
  • IBM Informix
  • Sybase ASE
  • MS Access 97-2003 (*.mdb;*.*)
  • MS Access 2007-2010 (*.accdb;*.*)
  • MS Excel 97-2003 (*.xls;*.*)
  • MS Excel 2007-2010 (*.xlsx;*.*)
  • dBase IV
  • Data Sources(OLE DB) (*.udl;*.*)
  • ODBC DSN(Data Source Name) (*.dsn;*.*)
  • OData
All-In-One, Free, Simple and Standalone (no install).

 Supported Platforms: Windows All (x86/x64)
 Requires: .NET Framework 4.0 or higher

You're welcome to download the Database .NET v4 right now at: DatabaseNet4.zip (7.32MB)


[December 21, 2011] Initial release (0.7.0) of new Python driver for Firebird — FDB is ready for testing

As promised, FDB initial release (0.7.0) is out: http://pypi.python.org/pypi/fdb/0.7.0

It's almost feature-complete (ready for 95% of users), but it could be still buggy (it's beta!), and the code wasn't optimized for size and speed. In all other ways it's ready for wide testing.

What's missing:
  • Distributed transactions
  • ARRAY support
  • EVENTs support
  • Stream BLOBs
  • TRACE service
  • Documentation (but you can use KInterbasDB one as FDB is as close to it as possible)
  • Python 3.x support (haven't had time to test it, but it shouldn't be hard to make it work there)
What's new since my last post here:
  • Support for stored procedures (proper one according to Python DB API, behaviour is the same as in KInterbasDB)
  • Prepared Statements. It works in exactly the same way as in KInterbasDB, i.e. you can use explicit PS via cursor.prep(), or use the internal PS cached for all statements executed via cursor.execute() — it will detect previously executed command and re-use prepared statement (cached per cursor instance!).
  • Fully implemented cursor.description attribute, i.e. including precision for DECIMAL/NUMERIC fields. Should now return the same results as KInterbasDB.
  • trans_info/transaction_info and db_info/database_info calls like in KInterbasDB.
  • Better object dependency and lifetime management, so Python memory GC should be much happier now. I modelled it as much as KDB does it as possible.
Source code is also in Firebird Project's Subversion repository: (KInterbasDB source moved)

Sorry for GIT/Mercurial etc. fans, but Firebird project uses only SVN for all its code (except old obsolete ones that are still in CVS) and it would be pointless to create another type of repository for such a small project. However, you're free to set up mirrors or local repositories on GIT or whatever :)

Merry Christmas to all
Pavel Cisar
IBPhoenix
[ED: if you want to know how easy is to use, or how compatible it is related to kinterbasdb, read this post ]


[December 19, 2011] ADO.NET provider for Firebird 2.7 released

I’m happy to bring you early Christmas gift packed as ADO.NET provider for Firebird version 2.7. More info...


[December 19, 2011] Firebird Development Studio has been released

SQLLY Development team is proud to announce the next major version of Firebird Development Studio.

As usual you will get simple and clear user interface equipped with unique features like SQL code refactoring, intelligent code completion and real-time errors highlighting. Database Comparer, SQL debugger, Code Formatter and ER Diagrams designer are also at your service.

Please visit http://www.sqlly.com for more information. Do not miss our special christmas offer!


[December 18, 2011] Python Firebird driver PyFirebirdSQL 0.6.5 is released with new documentation page and stored procedures fixes

The most important fix is callproc() is now implemented. Here is the download page and the full changelog.

Documentation page is located on github http://nakagami.github.com/pyfirebirdsql/


[December 17, 2011] Why is Firebird better DBMS than Oracle?

Beside being free (both as beer and also open source), you don’t need 24x7 DBA and there are generally less headaches. Here’s a nice example explained by Norman Dumbar in a mailing-list post. Norman administers over 600 Oracle databases and about 40 Firebird ones:


[December 15, 2011] Gifts for new members of Firebird Foundationикони цени

Special gifts for the new members of Firebird Foundation till December 31, 2011:
  • 3 *FREE* FB TraceManager Enterprise licenses (incl. 1 year subscription) for the next 3 members who either renew a VOTING membership or join as a VOTING member
  • 3 *FREE* FB TraceManager Standard licenses (incl. 1 year subscription) for the next 3 members who either renew an ASSOCIATE membership or join as an ASSOCIATE member
  • 3 *FREE* FBDataGuard licenses for the next 3 members who either renew a VOTING membership or join as a VOTING member
  • 3 *FREE* FBScanner licenses for the next 3 members who either renew a VOTING membership or join as a VOTING member
(by "Renew membership" we mean memberships which were excluded from the list there http://www.firebirdsql.org/en/members/)

Hurry up, only 9 gifts for new VOTING members and 3 for new ASSOCIATE members of Firebird Foundation! Join Firebird Foundation Now!


[December 14, 2011] Firebird PHP and ExtJS grid examples

Here
are various articles about Firebird ExtJS and php. Articles are written in Russian Language, so you might need google translation.


[December 13, 2011] Database Workbench 4.2.0 released

Ladies, gentlemen,

Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: "Database Workbench 4.2.0 Pro". This release includes the FREE Lite versions for InterBase, Firebird and MySQL. And if you order before Jan 1st 2012, there's a 40% discount!

For more information, see here.

Click here for the full list of changes in v4.2.0

Database Workbench supports:
  • Borland InterBase (4.x - XE)
  • Firebird (1.x, 2.x)
  • MS SQL Server/MSDE (7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express)
  • MySQL 4.x, 5.x
  • Oracle Database (8i, 9i, 10g, 11g)
  • Sybase SQL Anywhere (9, 10, 11 and 12)
  • NexusDB (3.0 and up)


[December 12, 2011] Using the Firebird 3.0 API with Delphi

Pierre Yager announced on firebird-devel new version of UIB with Firebird 3.0 API support:

Thanks to Vlad, we achieved the translation of the FB3 OO API in UIB Components for Delphi.

You can checkout the code from SourceForge repository : https://uib.svn.sourceforge.net/svnroot/uib/trunk

Now, we only miss hints to deal with FbMessage, it seems that the examples (fbstuff on github) made by Adriano heavily relies on BOOST and as we don't have such possibilities with Delphi we must understand what is exactly an FbMessage and see what we can do.

Thanks for your help, regards,


[December 12, 2011] Faghmie Davids contributed his patches to firebird provider for gnome db

Here is my patch file so far for the firebird provider. [Ed: For gnome db]

It only run select statements. Your feedback and guidance will be appreciated.

There is still quite a bit missing, but at least I can now select data from a firebird database . Please note that it does not do the input,parameters for statements.....mainly cause I never use it

If there is some interest I'll work some more on it.


[December 11, 2011] python firebird driver pyfirebirdsql 0.6.4 is released

Here
is the download page and the full changelog


[December 10, 2011] Logging C# applications in the database FireBird Embedded with NLog 2.0

Tutorial is about logging into the Firebird database using NLog 2.0.

Article is in Russian Language but you can try to read the google translation.

PS: Let's hop you will not spend 5 hours and yogurt to fight with this again ;)


[December 10, 2011] asp.net and firebird part one and two

Articles
are in Portuguese but you can use google translate.

In this post, we will begin a series of articles regarding how to use Firebird DBMS (Database Management System Data) in an ASP.NET 4.0, C #, using Visual Studio 2010.


[December 10, 2011] Sorting using blob column on Firebird

Jiri Cincura wrote a new blog post about Sorting using blob column on Firebird:
Imagine you have a blob column and you want to add sorting clause to your query based on that column. Crazy? Might be. On the other hand, why not?


[December 10, 2011] Hierarchical database structures and Firebird PSQL

The idea of storing a hierarchical data in a relational database is very simple, but effective work with such a data requires some knowledge of server-side programming using procedural SQL (PSQL). So the hierarchical data structures are a good chance to get acquainted with PSQL. For demonstration purposes I created a simple database with single table TCLASS containing Delphi class hierarchy

The rest of the article is here.


[December 08, 2011] Future for Python driver merging the pure driver with the ctypes interface to Firebird

Pavel Cisar wrote on firebird python list:

Those who attended my "Python drivers" session at conference in Luxembourg already know that last two months I have worked on another Python driver for Firebird (codename fdb). It was just an experiment how far I could go in short time with another approach to implementation, not real attempt to replace both existing drivers (KInterbasDB and firebirdsql). However, it went so well, that we have a real chance to get out a truly universal pure Python driver for Firebird next year. Here are details...


[December 08, 2011] International Firebird Conference 2011 videos

Subscribe to Firebird Official Newsletter and be the first to have access to the recordings of the sessions from the International Firebird Conference 2011.

Subscribe now (of course, it is free!)


[December 05, 2011] firebird-devel is also archived now on gmane

Firebird-devel is now archived on gmane and you can use it in your favourite News Reader.


[December 01, 2011] AUDFL: advanced version of rFunc with support for 64-bit Windows and Linux

AUDFL is an advanced version of popular rFunc UDF library for Firebird 2.0-2.5.x, with 32/64-bit support for Windows and Linux. With AUDFL you can easy migrate your Firebird database with rFunc inside to 64-bit Firebird version.

AUDFL is developed by Maxim Filatov (www.ansoft.ru) and supported by IBSurgeon.

AUDFL is under LGPL license — i.e., it's open source and it's 100% free.

Here you can download 32- and 64-bit versions of AUDFL for Windows and Linux, or download full source code (SVN) and build AUDFL yourself using Visual Studio Express or gcc.

If you found a bug or another problem, please create an appropriate ticket. If you need professional support on issues, related with rFunc/AUDFL, please contact IBSurgeon Support.


[November 30, 2011] Jason Wharton talks about FBConference 2011
All,

I would just like to report to the IBO community that the Firebird Conference in Luxembourg was a great success. There were over 60 people in attendance and the sessions I attended were all very good. It's amazing what is being done with Firebird and what is coming in the future. Things are looking very good. The IB Objects session was well attended and it felt like some useful things were learned even by some of the long-time customers. If anyone is interested, the entire session was recorded. I can see about getting permission to put it up on YouTube or to post an MP3 download of it on a file sharing site. Send me a private email.

I think most of the fun we had was getting a personal contact with all the people we rub cyber shoulders with every day. Hopefully in the future there will be more people to come and attend.

I would like to stress the importance of everyone who uses Firebird to consider being a member of the foundation. Your opinions truly matter and your financial contributions are an investment in Firebird's success. All of those who develop Firebird are awesome people. I really enjoyed getting acquainted with them personally. I wish for them to have the means to be compensated financially for their efforts in Firebird. It could be a significant and justified temptation for them to get hired away from their efforts. The best way we can keep their brilliance and talent solely dedicated to Firebird is to give it the resources to secure their interests.

I am working on an idea to give a discount to all those who are members of the Firebird Foundation so if you have some ideas please let me know. I would like to be a strong supporter of Firebird as best I can so I am looking for ways to accomplish this.

Kind regards,
Jason Wharton
www.ibobjects.com
Source: http://tech.groups.yahoo.com/group/IBObjects/message/45720


[November 30, 2011] FB TraceManager V2.0.5 has been released

FB TraceManager V2.0.5 has been released.

More information on this new release can be found here: http://www.upscene.com/displaynews.php?item=20111118


[November 30, 2011] [FB/IB/Ora]Replicator V4.0.7 has been released

Download http://www.ibphoenix.com/download/ibreplicator

Release Notes Version 4.0.7 — 14th November 2011

New Features: None.

Bug Fixes:
  • Fix sending of mail.
  • Fix occasional Linux daemon startup issue.
  • Fix Replication Manager loading of configuration if it was opened via the "Create" option.
  • Fix password decode on some Linuxes.
  • Fix issues after an Oracle connection fails.


[November 30, 2011] Node.js and Firebird installation and usage guide

The article is in Russian but you can use the google translate to make it close to English.


[November 29, 2011] node.js firebird driver 0.0.8 released with experimental support for #node on Windows

Here is the download page and you can check the Commit History for interesting changes.

Under Windows Unzip, modify config.js for your DB. Run: node.exe test.js

[November 29, 2011] Perl Firebird Driver DBD-Firebird 0.91 is released with minor fixes

Here is the list of changes and you can use the cpan download page to get the package.

PS: one cool features that is coming is preliminary ISQL-like tool using DBD::Firebird.


[November 29, 2011] Firebird 3.x OO API example

Pierre Y wrote on Firebird-devel list about the new Firebird 3.x api and he created a project for it:

Now I started playing with the new API. I created a project on github for it : https://github.com/zedalaye/fb3-oo-api

Is the OO API complete? I think very strange to still have to build DPB by hand... Can you expose something that may give access to the ClumpletWriter to ease that?


[November 26, 2011] #fbcon11 Pictures from conference

On the Firebird Facebook page there are some cool pictures from the conferece


[November 25, 2011] #fbcon11 tweet stream

You can watch the tweet stream from the conference rooms, live with pictures https://twitter.com/#!/search?q=%23fbcon11


[November 24, 2011] Flamerobin video tutorial

We're brand new company, who is creating video guides for various software or systems. Recently, we made a video tutorial for your tool "Flamerobin" showing some basic management operations, like registering a database, managing users, changing SYSDBA password etc.
 
 
And the blog post related to this video.


[November 23, 2011] Recursive Queries in Firebird 2.5: example for WITH RECURSIVE

WITH RECURSIVE example with Firebird 2.5.x . Article is in Japanese but you can try to read the google translation

Google translate bar from chrome shows you a better rendering of the page.




[November 23, 2011] How to install Firebird server on Windows Video

Video guide is showing, how to install Firebird Server on a windows platform.

http://www.youtube.com/watch?v=KLg0TuhMUU0


[November 22, 2011] FreePascal FCL web combined live example with ExtJS

The example
uses the latest 3.x version of the ExtJS Library installed at demo.artesoft.gr/ext. I changed a little the database, adding a before update or delete trigger to protect the demo account from accidents.

The database is a firebird 2.1 Superserver, and the server is a CentOS 5.7 64bit with ISPConfig and the demo.artesoft.gr is a subdomain.

Feel free to do whatever you want with the demo as long is up and running.


[November 22, 2011] TurboBird a cross platform FireBird database admin tool written in Lazarus

Turbo Bird
is a Firebird Administration tool. It enables you to create new Firebird database, create/modify tables, procedures, views, triggers, generators, roles, UDFs, Domains, and much more. Turbo Bird application is very easy to install and to use. There are Linux 32 bit, Windows 32 bit, and Mac OS binaries. You can install the source and compile it using Lazarus in any other Plateform that already supported by Lazarus.


[November 22, 2011] Start using gmane.org for news / archive / blog interface for firebird related mailing list
I suggest to drop Atkins [for news readers] and start using gmane.org. I use it for several years in FireBase, and it had always been very stable.
We have also archive on mail-archive:
http://www.mail-archive.com/firebird-devel <at> lists.sourceforge.net
http://www.mail-archive.com/firebird-docs <at> lists.sourceforge.net
http://www.mail-archive.com/firebird-net-provider <at> lists.sourceforge.net

http://www.mail-archive.com/firebird-odbc-devel <at> lists.sourceforge.net
http://www.mail-archive.com/firebird-python <at> yahoogroups.com
http://www.mail-archive.com/firebird-support <at> yahoogroups.com

on gmane:
http://dir.gmane.org/gmane.comp.db.firebird.user
http://dir.gmane.org/gmane.comp.db.firebird.documentation

http://dir.gmane.org/gmane.comp.db.firebird.dotnetprovider
http://dir.gmane.org/gmane.comp.db.firebird.general
http://dir.gmane.org/gmane.comp.db.firebird.net-provider
http://dir.gmane.org/gmane.comp.db.firebird.php
http://dir.gmane.org/gmane.comp.db.firebird.python


Update:
Firebird support archive and NNTP is back on gmane


[November 20, 2011] Firebird CpuAffinityMask for 16 core server? Question of the day

We have this question on serverfault and the answer is in that thread too:
I have a server with 16 cores. What do I set the CpuAffinityMask to?

1111 1111 1111 1111 is 65535, should I put 65535?

Also, how to I configure the SuperClassic server?

This is for Firebird 2.5.


[November 17, 2011] Delphi, Firebird, IBObjects and Transaction Management

I recently had reason to revisit transaction management in our application. The application makes extensive use of data aware grids (TDBGrid) and, as I am sure everyone is aware, it is impossible to explicitly manage transactions when you are displaying data in a grid.

Fortunately, IBObjects provides the means to automatically clean up transactions left hanging by TDBGrid. Unfortunately, this isn’t as well documented or as straightforward as I would like. So, after much research using the programmer’s secret weapon (Google) and a few questions posted to the IBObjects support group (thanks Jason) I think I finally understand how it works.


[November 17, 2011] Firebird + EXT4 + barrier 1/0 + FW ON/OFF

Philippe Makowski did some TPC tests and posted the results at fb-devel:

Hi,

I'm a bit puzzled by the results I get I made test on Fedora 16 with Kernel 3.1.1-1.fc16.x86_64 on LVM2 Logical Volume of 10G

Firebird 2.5.1 Classic

hdparm /dev/vg_tests/testfb
/dev/vg_tests/testfb:
multcount = 0 (off)
IO_support = 1 (32-bit)
readonly = 0 (off)
readahead = 8 (on)

hdparm -Tt /dev/vg_tests/testfb
/dev/vg_tests/testfb:
Timing cached reads: 12976 MB in 2.00 seconds = 6496.46 MB/sec
Timing buffered disk reads: 174 MB in 3.02 seconds = 57.53 MB/sec

database : 1,8G
created with -w20
and buffers 1024

tpcc lanched with -a1 -b1 -W20 -T20 -r1 -R10 -i60
protocol TCP/IP

Scheduler was cfq (deadline scheduler results are really close)

First, on this box (certainly because Fedora 16 use ext4 driver only) ext3 give bad results

so on a database with -write async
for ext4

noatime,async,data=ordered,barrier=1
TPC-C Throughput: 5467.10 tpmC

noatime,async,data=ordered,barrier=0
TPC-C Throughput: 5427.88 tpmC

sync,data=ordered,barrier=0
TPC-C Throughput: 562.11 tpmC

for a raw device
TPC-C Throughput: 6604.00 tpmC

with -write sync
for ext4

noatime,async,data=ordered,barrier=1
TPC-C Throughput: 165.11 tpmC

noatime,async,data=ordered,barrier=0
TPC-C Throughput: 566.89 tpmC

sync,data=ordered,barrier=0
TPC-C Throughput: 568.11 tpmC

for a raw device
TPC-C Throughput: 396.78 tpmC

So reliability have a real cost
hard to have perf and reliability
I really wonder if we can't get MaxUnflushedWrites or something like that under Linux too
I would be curious to do same test with this parameter under Linux

it will not be really safe, but at least a medium solution for people because between
5467.10 tpmC (FW OFF and noatime,async,data=ordered,barrier=1)
and
165.11 tpmC (FW ON and noatime,async,data=ordered,barrier=1) seems that there is a room

Update:
with FW OFF and MaxUnflushedWrites = 100 and MaxUnflushedWriteTime = 5
ext4
noatime,async,data=ordered,barrier=1
TPC-C Throughput: 1155.67 tpmC

as expected between
5467.10 tpmC (FW OFF and noatime,async,data=ordered,barrier=1)
and
165.11 tpmC (FW ON and noatime,async,data=ordered,barrier=1)

but only partially reliable :(


[November 16, 2011] Firebird 2.5.1 final for ubuntu 11.10 published

The package is done (imported from debian repository) with minor modifications (ignoring new dpkg version requirement).

The install guide is the same located in the ubuntu wiki https://help.ubuntu.com/community/Firebird2.5.


[November 14, 2011] Group Statistics for Firebird SQL Community on linkedin.com

I'd like to share vital statistics on the activity, growth, and demographics of this group with you.


[November 14, 2011] ANN: Firebird Maestro 11.11 released

Firebird Maestro SQL Maestro Group is pleased to announce the release of Firebird Maestro v. 11.11, a powerful Windows GUI solution for Firebird administration and database development.

New version features Unicode support in SQL editors and viewers, updated code folding appearance, refactoring of database schema with Split Table wizard, viewing BLOB data as PDF and a lot of other useful things.

Read full press-release.



[November 13, 2011] Firebird 2.5.1 package for Debian Stable named Squeeze

Damyan Ivanov announced:

I have prepared packages from the current version in wheezy (2.5.1.26351), built for squeeze.

ftp://ftp.modsoftsys.net/public/firebird2.5-backports/

If these improve the situation, then we at least know the bug is fixed in that version and can start looking for the exact fix, which would take about 10 iterations (and probably several weeks).

[ED if you want to rebuild them for 32bits you can use these instructions.





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