Free firebird software for linux

Mozilla Firefox project (formerly Firebird, which was formerly Phoenix) is a redesign of Mozillas browser component, written using the XUL user interface language and designed to be cross-platform.
Mozilla Firefox is a Mozilla browser.
It is small, fast and easy to use, and offers many advantages over other web browsers, such as the tabbed browsing and the ability to block pop-up windows.
Main features:
- comprehensive popup controls to keep unwanted advertising off your desktop;
- a tab browsing mode that lets you open several pages in a single window, allowing you to load links in the background without leaving the page youre on;
- integrated search (powered by Google);
- industry leading accessibility with Find As You Type - find links and page text by simply typing;
- simplified privacy controls that let you cover your tracks more effectively;
- a streamlined browser window that lets you see more of the page than any other browser while at the same time being more configurable;
- a large variety of free downloadable extensions and themes that add specific functionality and visual changes to the browser.

Firebird is a relational database offering many ANSI SQL-99 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. Firebird Relational Database has been used in production systems and 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.


New code modules added to Firebird are licensed under the Initial Developers Public License. (IDPL). The original modules released by Inprise are licensed under the InterBase Public License v.1.0. Both licences are modified versions of the Mozilla Public License v.1.1.

Installing:

In order to install the firebird version of IB 6.0 you will need to perform the following steps:

1. Get the required packages:

Get the glibc update from RedHat, the one I used
was from ftp://updates.redhat.com/7.0/i386/glibc-2.2-5.i386.rpm

Get ncurses4 from
ftp://carrier.ision.net/pub/ftp.redhat.com/i386/en/RedHat/RPMS/ncurses4-5.0-2.i386.rpm
or another redhat mirror.

Get Firebird from
ftp://firebird.sourceforge.net/pub/firebird/release/FirebirdSS-0.9-1.i386.rpm

2. Prepare the installation:

Log in as root.
Use a plain text console to do this and be sure
that all Gnome desktops are closed.
(One user reported that the Gnome desktop
(apparently ICEwm)
blocked port 3050. I could not reproduce this
here, but it seems that it uses port numbers
that arent assigned in /etc/services for own
purposes)

3. Add localhost.localdomain to /etc/hosts.equiv:
echo localhost.localdomain >>/etc/hosts.equiv

4. Change to the directory where you have placed
the downloaded packages.

5. Install the glibc update:
rpm --install --force glibc-2.2-5.i386.rpm

6. Install libncurses.so.4:
rpm --install --force ncurses4-5.0-2.i386.rpm

7. Install Firebird:
rpm --install --force FirebirdSS-0.9-1.i386.rpm

8. Add /opt/interbase/bin to your path:
You can either change /etc/profile
or do
export PATH=$PATH: /opt/interbase/bin
or
change the profiles in your users home directories

9. Check that all went well:

Read /opt/interbase/SYSDBA.password
to get your SYSDBA password.

gsec -display
should display the list of known users
(SYSDBA only after a fresh install)

isql /opt/interbase/examples/employee.gdb
SQL> SHOW TABLES;
should display all tables from this database
SQL>quit;

DBD-InterBase is a Perl-DBI driver for the InterBase Databases and Firebird, written using the InterBase C API.

Kfb (KDE Firebird Basictool) is a GUI administration tool for the Firebird database system. The application includes most functions offered by Firebird and introduces some new operations said to be impossible

Kfb is programmed with KDevelop (C++ and Qt). It is fully GUI and based mainly on IBPP, another open source project of C++ interface to Firebird APIs. Kfb also includes some other libraries, ncrypt and fbcopy, and all of them are open source projects.

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

The Job Scheduler runs executable files, shell scripts and database procedures automatically (MySQL, PostgreSQL, Firebird and SQL Server, Oracle, DB2).

Job Scheduler processes sequential and parallel tasks and job chains, provides an API for job implementation with Java, Javascript, VBScript, Perl and exposes jobs as Web Services.

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

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.