| Firebird | |
|---|---|
 |
|
| Developer | Firebird Project |
| OS | Cross-platform |
| Genre | RDBMS |
| License | IPL, IDPL |
| Website | www.firebirdsql.org |
Firebird (sometimes erroneously called FirebirdSQL) is a relational database management system offering many ANSI SQL-2003 features. It runs on Linux, Windows, and a variety of Unix platforms. Started as a fork of Borland's open source release of InterBase, the Firebird codebase is maintained by the Firebird Project at SourceForge. New code modules added to Firebird are licensed under the Initial Developer's Public License (IDPL). The original code released by Inprise (as Borland was then called) is licensed under the InterBase Public License 1.0. Both licenses are modified versions of the Mozilla Public License 1.1.
Contents |
History
Firebird 1.0 was essentially a bug-fixed version of the InterBase 6.0 open source edition with some minor new features. Development on the Firebird 2 codebase began with the porting of the Firebird 1.0 C code to C++, together with a major code-cleaning undertaking. Firebird 1.5 was the first release of the Firebird 2 codebase and as such a significant milestone for the developers and the whole project.
- Firebird 2.0 was released in 2006. The latest stable version is 2.0.3 which was released in September 2007.
- Firebird 2.1 went into beta testing in mid-2007 and is likely be released soon.
- Firebird 3.0 will merge code from several codebases, including Firebird 2.1, Vulcan, and Fyracle. As such, it will not be released before 2008. The schedule at Road to Firebird 3.0 is not up-to-date.
Around the 20th birthday of the InterBase/Firebird product line, original creator Jim Starkey recollected:
- "September 4, 2004 is the 20th anniversary of what is now Firebird. I quit my job at DEC in August, took a three day end-of-summer holiday, and began work on September 4, 1984 in my new career as a software entrepreneur. As best as I can reconstruct, the first two files were cpre.c and cpre.h (C preprocessor), later changed to gpre.c and gpre.h. The files were created on a loaner DEC Pro/350, a PDP-11 personal computer that went exactly nowhere, running XENIX. Gpre was my first C program, XENIX was my first experience with Unix, and the Pro/350 was my very last (but not lamented) experience with PDP-11s."
More information on Firebird's history can be found on the InterBase/Firebird History pages.
Current version
The most recent stable version is Firebird 2.0.3. The Firebird 2 branch contains a large number of new features, including derived tables, support for Execute Block, increased table sizes, improved index code (no more 252-byte index length limit), expression indices, optimizer improvements, enhanced security features, support for on-line incremental backups as well as numerous other improvements and bug fixes. The complete Release Notes are available in PDF format.
Features
- Full support of Stored Procedures and Triggers[1]
- Full ACID compliant transactions
- Referential Integrity
- Multi Generational Architecture (sometimes called MVCC)
- Very small footprint
- Fully featured internal language for Stored Procedures and Triggers (PSQL)
- Support for External Functions (UDFs)
- Little or no need for specialized DBAs
- Almost no configuration needed - just install and start using
- Big community and lots of places where you can get free and good support
- Optional single file embedded version - great to create CDROM catalogs, single user or evaluation versions of applications
- Dozens of third party tools, including GUI administrative tools, replication tools, etc.
- Careful writes - fast recovery, no need for transaction logs
- Many ways to access your database: native/API, dbExpress drivers, ODBC, OLEDB, .Net provider, JDBC native type 4 driver, Python module, PHP, Perl, etc.
- Native support for all major operating systems, including Windows, Linux, Solaris, MacOS.
- Incremental Backups
- 64bits builds available
- Full cursor implementation in PSQL
User documentation
The Firebird 2.0 Quick Start Guide is available on-line as a multi-page HTML document as well as in PDF format. A short introductory paper, Get to know Firebird in two minutes, has been translated into more than a dozen languages. The full Firebird Documentation Index is at http://www.firebirdsql.org/index.php?op=doc.
Mozilla Firefox name clash
In April 2003, the Mozilla Foundation decided to rename their web browser from Phoenix to Firebird. This decision caused concern within the Firebird database project due to the assumption that users would be confused by a database and a web browser both using the name Firebird. The dispute continued until the Mozilla developers issued a statement making clear that their software package was called "Mozilla Firebird", not "Firebird". The statement also said that the Mozilla Firebird name was a project codename. On February 9, 2004, Mozilla renamed its browser Mozilla Firefox, thus ending the confusion.
FireBird Application
- http://www.arkadia.com, Using Firebird to manage all their properties and users.
References
See also
| Free software Portal |
- List of relational database management systems
- Comparison of relational database management systems
- Fyracle
External links
- Firebird - Project website
- IBPhoenix - Firebird Portal
- FirebirdNews - Major source of Firebird related news
- FlameRobin - cross-platform Administration tool for Firebird, Open Source under MIT license
- Yaffil - ex-fork of Firebird 1.x, when its development was stalled. Now merged back to main stream.
- Interview with Jim Starkey, original creator of what would later become Firebird.
- Firebird SQL Code Formatter, online service.
- Firebird collations, charts.
|
|
|
|---|---|
| Database models · Database normalization · Database storage · Distributed DBMS · Referential integrity · Relational algebra · Relational calculus · Relational database · Relational DBMS · Relational model · Transaction processing | |
| Concepts | Database · ACID · Null · Candidate key · Foreign key · Primary key · Superkey · Surrogate key |
| Objects | Trigger · View · Table · Cursor · Log · Transaction · Index · Stored procedure · Partition |
| SQL | Select · Insert · Update · Merge · Delete · Join · Union · Create · Drop · Begin work · Commit · Rollback · Truncate · Alter |
| Implementations | Relational · Flat file · Deductive · Dimensional · Hierarchical · Network · Document-oriented · Object-oriented · Object-relational · Temporal · XML data stores |
| Components | Concurrency control · Query language · Query optimizer · Query plan · ODBC · JDBC |
| Database products: Object-oriented (comparison) · Relational (comparison) · Document-oriented | |
