An image with preconfigured Firebird SQL on Alma Linux 8 is provided, featuring essential system components preinstalled, such as AWS CLI, AWS CloudWatch Agent, AWS Systems Manager Agent, Python 3, and Cloud-Init. Detailed guidance is available in the Additional Resources section of this listing. Upon initial boot, all offerings are updated to ensure the application of the latest packages and security updates.
Firebird is an open-source, SQL-based relational database management system, based on the open source edition of InterBase initially released by Borland Software Corp, formerly known as Inprise Corp. Developed using C and C++, Firebird ensures extensive compatibility across major hardware and software platforms, encompassing Windows, Linux, and Mac OS X. It incorporates numerous ANSI SQL standard features, enabling concurrent OLTP and OLAP operations through its multi-generational architecture, and supports stored procedures and triggers.
Firebird employs a multi-generational architecture, also known as multi-version concurrency control, using record versions instead of read/write locks and transaction logs to ensure external concurrency and consistency. In this approach, the previous version of every modified record is preserved for as long as needed by at least one active transaction. Each record version is associated with the transaction that created it, and transactions are aware of other currently active transactions.