Firebird: Firebird - A relational database including lots of ANSI SQL standard features that runs on Linux, Windows, Unix

Firebird - A relational database including lots of ANSI SQL standard features that runs on Linux, Windows, Unix

Firebird is a relational database that includes a large array of ANSI SQL standard functions, compatible with Windows, Linux and Unix operating systems.

Used in production systems since 1981, the program provides increased performance and multilingual support for stored triggers and procedures.

Firebird is completely free. You are allowed to build a custom version of the program as long as you make the modifications available for others, using the same IDPL licensing.

You can choose between two different server architectures for Firebird: classic and super server architecture. The super server is the architecture used for Windows 32-bit platforms. For 32-bit Windows platforms the classic architecture is offered only from version 1.5 up. For Unix style platforms, usually both classic and super server architectures are provided.

For learning the basics the classic architecture is the best option since it lets applications to open the database file directly. Also, multiple programs can access the same database simultaneously. The classic engine offers an inetd or xinetd service to establish remote connections to local databases.

The super server architecture offers a server process, with all SQL requests performed by the server using a socket. The client process is not able to open the database file directly. This type of architecture processes requests using lightweight threads.

When you acquire a basic level of experience you can decide which of the two architectures suits best your installation.


- Support is enabled for a large number of hardware and software platforms such as Windows, Mac OS, Linux, Solaris, HP-UX, AIX…etc. Supported hardware platforms include x386, x64 and PowerPC and others, with an easy migration mechanism between any of these platforms.
- Support and development of hybrid OTLP and OLAP applications are enabled by Firebird’s multi-generational architecture.
- Support is enabled for stored triggers and procedures.
- Built-in support for SQL92.
- Comprehensive set of monitoring tables and Trace API are provided.
- Standard security includes organization using users and roles the possibility of using GRANT/REVOKE on main operations and database owner concept.
- Windows Trusted Authentication enables single sign-on for end users and complete integration with Windows domain/Active directory security.
- Requires only one network port open (3050 by default, can be changed).
- Does not expose aliases.


- MS Visual C runtime libraries

Download Details

  • License:
  • Platform:
  • Publisher:
  • File size:
    14.50 Mb
  • Updated:
    Jan 18, 2024
  • User Rating:
    4.5 / 5 (8 votes)
  • Editors' Review:
    Not yet reviewed
  • Downloads:
Similar software
SymmetricDS 3.15.5
Customizable database synchronization solution.
71 / 3,049
Mongoclient 2.2.0
Monitor your MongoDB databases, get related statistics, manage user privileges, and more
27 / 1,915
Mountain Duck 4.15.6 Build 21921
A small and simple application that lets you easily mount all major types of servers as local disks
20 / 2,170
Sqlectron 1.37.1
A simple application that lets you edit and manage PostgreSQL, MySQL and Microsoft SQL Server databases
28 / 2,300
Navicat for SQLite 16.3.9
Administration and development tool
24 / 7,788
Portable HeidiSQL
Manage multiple MySQL database connection with this small, customizable application
139 / 5,373