Firebird Database Introduction

Firebird Database Introduction

Firebird features: Firebird is a fully functional, powerful, efficient, lightweight, and maintenance-free database. It allows you to easily upgrade from a single user to a single database to an enterprise-level application.
A Firebird Database Server can manage multiple independent databases. Each database supports multiple client connections at the same time. In short: it is an open-source, powerful, and free-to-use database (even for commercial use)
Key features:
Supports atomic, concurrency, isolation, and other concepts.
MGA:
Supports multiple versions of transactions,
Stored Procedure:
With Psql (Procedure SQL), you can create powerful stored procedures to process all data on the service. You can use the select Stored Procedure form to use stored procedures, to obtain the results of a virtual table structure. In this way, you can easily use it in reports.
Event:
Stored Procedures and triggers can trigger events, which can beProgramListen
Generate sub-statement:
It is also called a sequence to generate sub-fields that can be automatically added. It is an int64 length. Therefore, it can be used in a transaction or in many other aspects.
Read-Only database:
We can store data inventory in CD to form a read-only database. If our application
With the embedded FB Database Server added on the CD, you can get an unparalleled
Cdlive (that is, it can run with only a CD) application.

Full transaction control:
A client can have multiple concurrent transactions. In addition, each transaction can be controlled independently, and the two-segment commit function can ensure Database Consistency. The lock optimization mechanism also supports the storage of multiple transaction points.
Online backup:
Backup can be performed without stopping the database. A backup process generates the current snapshot of the database. Therefore, you can perform operations 24x7 (24 hours a day, 7 days a week) during the backup period.
Trigger:
Each table can have multiple concurrent row-level triggers, which can be triggered before, after, before, after, after, before, and after insertion. You can write a Psql statement into a trigger. The default value causes an exception. Firebird now supports a unified trigger, which allows you to manage insert, update, and delete operations in one trigger at a time.
Extended functions:
We can use C, C ++, and Delphi to write udfs. Using udfs (user-defined function libraries) can easily be attached to the database engine to expand the functions we need.
Character Set: Firebird implements many international standard character sets, including Unicode.
SQL standard compatibility: Firebird implements all functions required by sql92 and the most common requirements of sql99. Including but not limited to "Full/left/right [outer] Join, union, distinct, subquery (in, exists), internal functions (avg, sum, Min, Max, coalesce, case ,..), primary Key, foreign key, unique index, and all common data types.
Firebird also implements field-level constraints, views, exceptions, rules, and permission management. For more information, see Firebird release notifications and reference manual.

Hardware requirements:
Firebird can work well in the most common hardware environment or even very poor hardware. Of course, hardware requirements depend on what you want to do, for example, you have a few concurrent users.

Effective platform support:
Firebrid can run on common platforms, such as Linux and Windows (including Windows terminal servers) Other supported platforms including (Mac OS), Solaris and HP-UX)
Transferring a database from one platform to another is very easy. You only need to back up the database and restore it to another platform.
Connectivity:
Firebird supports a series of Connection Methods. Currently, it can be connected through Native Delphi, C ++ components, or ODBC, JDBC, PHP, oledb, and dbexpress. Native Connection provides the ability to directly call Firebird's API function library (fbclient. dll/. So.

Physical restrictions:
Firebird supports a very large database, which can be divided into multiple physical files. The size of each file depends on Operating System Restrictions. Currently, the maximum theoretical limit of a database file is 64 Tb (64000 GB). Therefore, the common limits are the Operating System Restrictions and disk space restrictions.

Server engine version:
There are currently three server versions.
Standard Server: each client connection will lead to a server process (supporting multi-processor)
Super server: The process module of the first-phase server manages all client connections. Currently, multi-processor is not supported.
Embedded Server: the entire server engine is a dynamic library and can only be called locally through Io.
However, all servers use a database format. Therefore, you can easily share the data of database files between different engines.
Protocol:
The Firebird protocol uses IPL (Interbase Public License) and idpl (initial developer's Public License), which are similar to the Mozilla protocol. You can use it freely and deploy it on your customer applications.
You do not need to disclose yourSource code. Of course, if you modify the database engine, you should publish the sourceCode.
Tools:
There are a lot of tools to support Firebird. Including free, free, and commercial.
This includes development tools, management tools, and diagnostic tools.

Support and resources:
On Firebird's official website (www.firebirdsql.org), there is a lot of useful information about this project. Ipphonex also provides professional commercial support. There are also many useful professional information and answers to common questions on their websites.

Team:
Firebird has a series of user-supported teams and newsgroups. You can seek online support. You can
View the list of all newsgroups on the project homepage.
History:
Firebird is based on open-source interbase6.0 and is an open-source version released by Borland in 2000. The earliest history of INTERBASE can be traced back to 1984, so the database is 20 years old.

Features:
Firebird is a real relational database that supports all features of large relational databases, such as stored procedures, views, triggers, and transactions;
2. Firebird supports the vast majority of sql92 commands and most sql99 commands. The new Firebird 2.0 version provides more complete support for sql99;
3. Firebird source code is based on mature commercial database Interbase, with good stability and good compatibility with Interbase;
4. You do not need to consider the authorization fee (free of charge). You or your customers will be taken to court by the database developer one day because of piracy;
5. Easy to publish. The installation file is only a few MB and highly customizable. The client distribution is also very simple. Only one DLL file is required;
6. An Embedded Server version of Firebird, which does not need to be installed and runs directly. It is preferred for standalone development;
7. Firebird is very efficient;
8. It is highly portable and can run in Linux, UNIX, MacOS, windows, and Solaris systems. The database format is the same and does not need to be modified;
9. The Development Environment supports well. Delphi and C ++ builder do not use ODBC connections to develop Firebird-based programs directly using native development interfaces.
Generally, the default username of Firebird is "sysdba" and the password is "masterkey ".