Firebird RDBMS: What is it and what is new in its new version 4.0?

Firebird RDBMS: What is it and what is new in its new version 4.0?

Firebird RDBMS: What is it and what is new in its new version 4.0?

A little over a month ago, "Firebird" RDBMS, a known Relational database management system open source, has released a new version 4.0 which has new data types and many improvements.

And so that we do not miss the news, in this publication we will delve a bit about said RDBMS (Relational Database Management System) in English or RDBMS (Relational database administration system) in Spanish.

DBeaver

As usual, for those interested in deepening the subject after reading this publication, we will immediately leave below some related previous posts with the topic so that they can easily access them and complement the reading:

"DBeaver is open source software that acts as a universal database tool for database developers and administrators. It has a well-designed user interface, and allows writing in multiple extensions, as well as being compatible with any database. Therefore, it supports all the most popular databases such as: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, among others." DBeaver: an excellent tool for managing different DBs

DBeaver
Related article:
DBeaver: an excellent tool for managing different DBs
Related article:
35 Open Source Database engines

Firebird RDBMS: Management system relational database

What is Firebird?

According to its developers in its Official website"Firebird" It is described as follows:

"It is a powerful and complete RDBMS, which can handle Databases from just a few KB to many Gigabytes with very good performance and practically free of maintenance. In addition, it has excellent performance and is impressively adaptable, from an integrated single user model to deployments in any company with multiple databases of 2Tb or more, operating with hundreds of simultaneous clients."

General characteristics

Among the latests Moravia's compositions main features de "Firebird" the following may be mentioned:

  • Firebird is software compatible with Windows, Linux, MacOS, HP-UX, AIX, Solaris, among others. And as for Hardware, it works on x386, x64 and PowerPC, Sparc, among other hardware platforms. Also, it supports an easy migration mechanism between these platforms.
  • It is usually included in the Linux repositories of the following Distributions: Fedora, OpenSuse, CentOS, Mandriva, Ubuntu.
  • It has a multigenerational architecture, which allows the development and support of hybrid OLTP and OLAP applications. This makes it possible for a Firebird database to simultaneously serve as a warehouse for analytical and operational data, because readers do not block writers when accessing the same data under most conditions.
  • It supports stored procedures and triggers, and offers extensive support for SQL92. This includes benefits such as high ANSI SQL compatibility, Common Table Expressions (CTE), Flexible Transaction Management, Comprehensive Stored Procedures, Cross-Database Queries, Concept of Active Tables and Events, and User Defined Functions.
  • Its transactions are of the ACID type (Acronym of: Atomic, Consistent, Isolation, Durability), which means that the transaction is guaranteed safely.
  • It is free for both commercial and educational use. Therefore, it does not require use of license fees, or installation or activation restrictions. The Firebird license is based on the Mozilla Public License (MPL).

And among many others, the following can be briefly added: It has a low resource consumption, requires little or no need for specialized DBAs, virtually no configuration required (install and use practically), and has a great community and many sites where we can find excellent free support.

Much more information about "Firebird" and its characteristics and benefits can be obtained at the following links:

  1. Features: In English
  2. Meet Firebird in 2 minutes!: In Spanish

What's new in version 4.0

"Firebird" 4.0 introduces new data types and many improvements without radical changes in architecture or operation. Between the 10 most important To be highlighted, the following can be mentioned:

  1. Built-in logical replication;
  2. Extended length of metadata identifiers (up to 63 characters);
  3. New INT128 and DECFLOAT data types, higher precision for NUMERIC / DECIMAL data types;
  4. Support for international time zones;
  5. Configurable timeouts for connections and statements;
  6. Pooling of external connections;
  7. Batch operations in the API;
  8. Integrated cryptographic functions;
  9. New ODS (version 13) with new system and monitoring tables;
  10. Increased maximum page size to 32 KB.

Para ver the full list of changes you can click the following link.

"Firebird is derived from Borland's InterBase 6.0 source code. It is open source and does not have dual licenses. Whether you use it in commercial or open source applications, it is totally FREE! Firebird technology has been in use for 20 years, making it a very stable and mature product." Meet Firebird in 2 minutes!

Summary: Various publications

Summary

We hope this "useful little post" about «Firebird RDBMS», which is a Relational database management system widely used open source software, which recently released a new version 4.0 that it has new types of data and many improvements; is of great interest and utility, for the entire «Comunidad de Software Libre y Código Abierto» and of great contribution to the diffusion of the wonderful, gigantic and growing ecosystem of applications of «GNU/Linux».

For now, if you liked this publicación, Do not stop share it with others, on your favorite websites, channels, groups or communities of social networks or messaging systems, preferably free, open and / or more secure as TelegramSignalMastodon or another of Fediverse, preferably.

And remember to visit our home page at «DesdeLinux» to explore more news, as well as join our official channel of Telegram from DesdeLinuxWhile, for more information, you can visit any Online library as OpenLibra y jedit, to access and read digital books (PDFs) on this topic or others.


2 comments, leave yours

Leave a Comment

Your email address will not be published. Required fields are marked with *

*

*

  1. Responsible for the data: Miguel Ángel Gatón
  2. Purpose of the data: Control SPAM, comment management.
  3. Legitimation: Your consent
  4. Communication of the data: The data will not be communicated to third parties except by legal obligation.
  5. Data storage: Database hosted by Occentus Networks (EU)
  6. Rights: At any time you can limit, recover and delete your information.

  1.   someone said

    I have been using Firebird since it was "born" and it is fantastic, totally recommendable in all aspects, it has nothing to envy to any other "big one", with the advantage of being small, not consuming hardly any resources, working on almost all operating systems maintenance-free and scalable from single user to large multi-user systems with hundreds of active connections. No problem.
    Greetings.

    1.    Linux PostInstall said

      Greetings, Someone. Thank you for your comment and contribution from your personal experience regarding said RDBMS.