|
Firebird is the underlying database of Ovitec. It is an open database used in thousands of projects with excellent results. You can use your preferred tools to extract data, such as Microsoft Access, Microsoft Excel, Crystal Reports, etc. See the ODBC chapter in the manual.
History
Firebird is derived from Borland InterBase 6.0 source code. It is open source and has no dual license, whether you need it for commercial or open source applications.
Firebird technology has been in use for 20 years, which makes it a very mature and stable product.
Major Features
Firebird is a fully featured and powerful RDBMS. It can handle database sizes from a few KB to many Gigabytes with good performance and is almost free of maintenance.
Below is a list of some of the Firebird’s major features:
| • | Full support of Stored Procedures and Triggers |
| • | Full ACID compliant transactions |
| • | Multi Generational Architecture |
| • | 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 |
| • | 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. |
| • | Full cursor implementation in PSQL |
| • | Connection and Transaction Triggers |
|