Free 2010 firebird software for linux

Firebird .NET Data Provider is an ADO.NET data provider for Firebird. Firebird .NET Data Provider is written in C# and provides a high-performance native implementation of the Firebird API. It also includes an implementation of the Firebird Services API and Firebird array datatype support.

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981.

Firebird is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) on 25 July, 2000 under the InterBase Public License v.1.0

Jaybird is JCA/JDBC driver suite to connect to Firebird database server. Historically Borland opened sources of type 3 JDBC driver called InterClient.

However due to some inherent limitations of Firebird client library it was decided that type 3 driver is a dead end, and Firebird team developed pure Java implementation of wire protocol.

This implementation became basis for JayBird, pure Java driver for Firebird relational database.

This driver is based on both the new JCA standard for application server connections to enterprise information systems and the well known JDBC standard.

The JCA standard specifies an architecture in which an application server can cooperate with a driver so that the application server manages transactions, security, and resource pooling, and the driver supplies only the connection functionality.

While similar to the JDBC 2 XADataSource idea, the JCA specification is considerably clearer on the division of responsibility between the application server and driver.

JayBird 1.5 provides extensions to some JDBC interfaces. All extension interfaces are released under modified BSD license, on “AS IS” basis, this should make linking to these classes safe from the legal point of view. All classes belong to org.firebirdsql.jdbc.* package.

JayBird 1.0 provided only pure Java wire protocol implementation. While being most effective in client-server setups (even more effective than native client libraries), it performed worser when connected to the server residing on the same host compared to native (C/C++/Delphi/etc) solutions. Reason is that type 4 driver communicates with the server using network sockets, which introduce additional overhead. Native client library has possibility to use IPC when connecting to the database on the same host. This might increase performance even by 100%.

JayBird 1.5 provides also type 2 JDBC driver that uses native client library to connect to the databases. Additionally JayBird 1.5 can use embedded version of Firebird relational database allowing to create Java applications that does not require separate server setup.

However type 2 driver has also limitations. Due to multi-threading issues in Firebird client library, it is not possible to access it from different threads simultaneously when running in local mode (IPC). In this case only one thread is allowed to access library at a time. Driver tries to provide needed synchronization.

Current implementation uses mutex that is local to the classloader that loaded JayBird classes. This poses some deployment limitations: firebirdsql.jar must be deployed so, that it is loaded by the system classloader. For standalone web containers like Resin or Tomcat, JayBird should usually be deployed in their lib/ directory. It is allowed to include it in the WAR archives, but if and only if it is guaranteed that only one application will access Firebird.

When accessing remote servers thread per connection policy applies. Driver provides necessary synchronization for this situation.

Embedded version of the server cannot be used on Linux systems in multi-threaded applications. In particular this makes embedded version of the server unusable for web applications, where usually each request is served in separate thread.

Tiny Report is a free software that helps you to Design, Manage, and Deliver Reports for Extreme Business Insight.
It simply automates to production of dynamic PDFs. It allows you to design your templates in OpenOffice.
Main features:
The process
- Design your .SXW fie in OpenOffice,
- Use tiny_sxw2rml.py to convert the file in a .RML template,
- Use tiny_report.py to produce PDF file using any database.
Report Designer
- The report designer used is OpenOffice. All styles, tags and features of OpenOffice documents (.SXW) are implemented instead frames.
- No specific language to learn,
- Support style, colors, table, section, items, images, ...
- OpenOffice is not needed to render the PDF
Data Acquisition
- Support python expressions for effective computation,
- Browse through table with the object relationnal mapping,
- You do not have to code the database structure (introspection on the DB),
- You can create your own object and functions
- Lots of databases supported: MySQL, Postgres, SQLite, Firebird, SybaseConnection, MAX DB
- Support all links between tables (one2many, many2one, ...),
- Lots of special features using simple Python: group, sort.
Report Renderer
- Fast, simple and easy,
- Standalone to be included in other applications.

FlameRobin project is a database administration tool for Firebird DBMS.
Main features:
- lightweight (small footprint, fast execution)
- cross-platform (Linux, Windows for start, others planned too)
- dependant only on other open source software

ibWebAdmin is a web frontend for the Firebird and InterBase database server. ibWebAdmin project makes the attempt to support all features which Firebird and SQL are offering.
Even if this goal is unattainable, quite a few steps have already been done. By now ibWebAdmin has the basic functions for creating, deleting, modifying databases, tables, generators, triggers and domains. It lets you import, export, enter, edit, delete, query, browse your data. And some more ...
To execute this program you need, beside the Firebird or InterBase database server, an apache webserver with php support.
Enhancements:
- restored php4 compatibility by adding a php4 replacement for the php5-only array_combine() function

Konq Rellinks is an add-on for Konqueror, the official KDE browser.
It allows you to access the relations defined in the header of the document. These relations can be links to other versions of the document, RSS backend, search page, copyright informations,.... For more informations about this, see The link-Element in (X)HTML .
The look of the Rellinks add-on is similar to the "Site Navigation Toolbar" of the Mozilla browser (not Mozilla Firebird).
Enhancements:
- Support for "target" attribute,
- Distinction between "rel" and "rev" relations

libdbi implements a database-independent abstraction layer in C, similar to the DBI/DBD layer in Perl.
Writing one generic set of code, programmers can leverage the power of multiple databases and multiple simultaneous database connections by using this framework.
The libdbi-drivers project provides the database-specific drivers for the libdbi framework. The drivers officially supported by libdbi are:
- Firebird/Interbase
- FreeTDS (provides access to MS SQL Server and Sybase)
- MySQL
- PostgreSQL
- SQLite/SQLite3
The following drivers are in various stages of completion and are supposed to be included into the next release:
- mSQL
- Oracle
Enhancements:
- This release fixes a packaging error in 0.8.2. There are no source code changes.