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. 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) under the InterBase Public License v.1.0 on 25 July, 2000.
Firebird Database Supported platforms
Currently our main supported platforms are 32-bit Windows, Linux (i586 and higher), Solaris (Sparc and Intel), HP-UX (i386), FreeBSD and MacOS X. Main development is done on Windows and Linux, so all new releases are usually offered first for these platforms, followed by other platforms after few days (or weeks).
This installs the bulk of firebird to /usr/lib/firebird and is configured for the data files to be stored in
You can start and stop firebird with /etc/init.d/firebird or the ibmgr utility in /usr/lib/firebird/bin.
Changing the sysdba password
Firebird comes with a special user called sysdba that is very useful tool on your database server. You should first modify the default password for this user using the firebird security tool called gsec.
Pretty much any time we want to create databases or interact with them we can use the command line sql client isql that comes with firebird. First lets create a test database
SQL> create database 'localhost:/var/lib/firebird/data/test.gdb' user 'ruchi' password 'ruchi';
That created a new empty database /var/lib/firebird/data/test2.gdb owned by our new user ruchi. After creating a database you are already connected to it so I didn't really need to quit but it gives the opportunity to show how to connect to an existing database. Let's connect and create a sample table.