Free 2009 firebird software for linux

FireFoot is library that provides an easy way for C language programmers to connect to Firebird database servers (and provably Interbase). It uses the Firebird/Interbase API.
Library supports:
- Create, delete, connect to Firebird database servers.
- Single transaction management.
- Common or parametrized SQL statement support.
- Support for basic data types and BLOBs.
- User management support.
- Support the backup and restore of databases.
This library exists as an alternative of Firebird/Interbase C language API. It is made in C language, using GLib object model.
- It is planned to be multiplatform, working at least on Linux and Windows. Until now it is only tested on Linux, but shouldnt be a problem to port it to Windows.
FireFoot libary is released under the GNU/GPL version 2 licence.

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

PHP Client Sniffer is a PHP class file that allows one to quickly determine the clients browser and system information based on the HTTP_USER_AGENT string. The class can be used to generate browser specific html marks and other client side scripting.
Enhancements:
- add k-meleon support
- add camino support
- add mozilla firebird support
- add amiga support
- fixed issues with netscape and gecko browsers

SureMoKu 2009-05-28 is another compact yet useful SMK analysis tool. It is actually a software used for analysing positions in renju / gomoku games.

Requirements:

• Python