Skip to content

Firebird SQL

A True Universal Open Source Database

Firebird is a truly performant database management system. It scales impressively from a single-user model to enterprise-wide deployments with multiple databases running with hundreds of simultaneous clients.

Main features :

  • Full support for stored procedures and triggers
  • Full ACID compliant transactions
  • Referential integrity
  • Multi Generational Architecture (sometimes called MVCC)
  • Support for External Functions (UDFs)
  • SQL activity can send asynchronous notification events to clients
  • Third-party tools, including GUI administrative tools and replication tools
  • Careful writes – fast recovery, no need for transaction logs
  • Many access methods: native/API, dbExpress/FireDAC drivers, ODBC, OLE DB, .NET provider, JDBC native type 4 driver, Python module, PHP, Perl
  • Incremental backups
  • Full cursor implementation in PSQL

Go Behind The Facts and Figures

While it is interesting to look at data such as the ranking of database engines, we definitely won’t referred to it as fact. This is because looking at ranking alone says very little about the features, performance, security and potential of a database engines like Firebird.

Firebird

vs

Mircrosoft SQL Server

Here are some amazing facts that you may not know about Firebird