7 best free and open source software solutions for database management

IT departments work with a meager budget. Therefore, cost-cutting will allow the company not only to stay afloat, but also to direct the saved money to development.

To use the available budget more rationally, we will get acquainted with 7 free software products for database development and open source DBM solutions.

CUBRID

Free open source version, optimized specifically for web applications. The service is designed for processing large amounts of data and generating numerous parallel requests. This solution is implemented in the C programming language.

Advantages of:

• Multiple degree of blockage crushing;
• Backing up online;
• GUI tools and drivers for JDBC, PHP, Python, Perl and Ruby;
• Support for built-in database segmentation for scaling;
• In large systems, data is split into multiple database instances;
• Full text database replication and transaction consistency.

Disadvantages of:

• Does not work on Apple systems;
• No script debugger;
• Manual available in English and Korean only;
• Official forum discussions are usually outdated (most of them several years).

FIREBIRD

This relational database has been used in production systems (under different names) since 1981 and implements many ANSI SQL standards. Firebird can run on Linux, Windows and various Unix platforms.

Advantages of:

• Trace API for real time monitoring;
• Windows Authentication with Windows Authentication;
• Four supported architectures: SuperClassic, Classic, SuperServer and Embedded;
• Various development tools: commercial tools — FIBPlus and IBObjects;
• Possibility of automatic deployment for database cleaning;
• Event notifications from database triggers and stored procedures;
• Free support for the global Firebird community. What is important when developing database requirements.

Disadvantages of:

• Integrated replication support is not included and is only available as an add-on;
• Lack of timesheets and integration with other database management systems;
• Windows Authentication is not sufficient compared to solutions available in other operating systems.

MARIADB

Created by MySQL developers, MariaDB is used by technical giants such as Wikipedia, Facebook and even Google. MariaDB is a database server that offers a built-in replacement for MySQL functionality. Security is the main principle and priority of DBMS developers. In each release they add all MySQL security patches and improve them if necessary.

Advantages of:

• Scalability with easy integration;
• Real-time access;
• Basic MySQL functions (MariaDB is an alternative to MySQL);
• Alternative storage mechanisms, server optimization and patches;
• Extensive knowledge base on SQL database development, accumulated during 20 years of MariaDB work.

Disadvantages of:

• There is no password complexity check plugin;
• No memcached interface (distributed caching system in RAM);
• No optimizer trace.

MONGODB

MongoDB was founded in 2007 and is known as a “database for great ideas”. The project is funded by such renowned investors as Fidelity Investments, Goldman Sachs Group, Inc. and Intel Capital.

Since its inception, MongoDB has been downloaded 20 million times and is supported by over 1000 partners. These partners are committed to a free and open source solution.

Advantages of:

• Document check;
• Encrypted storage mechanism.

Popular use cases:

• mobile applications;
• product catalogues;
• content management;
• Real-time applications with memory storage mechanism (beta);
• reduces the time between initial failure and recovery.

Disadvantages of:

• Not suitable for applications that require complex transactions;
• Not suitable for legacy applications;
• Young solution: Software is changing and evolving rapidly.

MYSQL

The most prominent representative of our database development programme review. MySQL exists since 1995 and is now owned by Oracle. The DBMS has open source code. There are also several paid versions that offer additional features, such as georeplication of the cluster and automatic scaling.

Since MySQL is an industry standard, it is compatible with virtually all operating systems and is written in C and C++. This solution is an excellent option for international users. The DBMS server can display error messages to the clients in several languages.

ADVANTAGES OF:

• Checking on the server side;
• Possibility of local use;
• Flexible privilege and password system;
• Secure encryption of all password traffic;
• A library that can be built into offline applications;
• Provides the server as a separate client/server program for the network environment.

SHORTCOMINGS IN PRACTICAL DEVELOPMENT AND ADMINISTRATION OF MYSQL DATABASES ACQUIRED BY ORACLE:

• users believe that MySQL no longer falls into the category of free and open source software;
• is no longer supported by the community;
• users can no longer fix bugs or patches;
• loses to other solutions due to slow updates.

POSTGRESQL

PostgreSQL is another outstanding open source solution that runs on all major operating systems including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64) and Windows. PostgreSQL fully complies with the principles of ACID (atomicity, consistency, isolation, resilience).

Advantages of:

• Ability to create custom data types and query methods;
• The database development environment performs stored procedures in more than a dozen programming
• languages: Java, Perl, Python, Ruby, Tcl, C/C++ and its own PL/pgSQL;
• GiST (Generalized Search System): integrates various sorting and search algorithms: B-tree, B+-tree, R-tree, partial sum trees and ranked B+-trees;
• Ability to create more parallelism without changing Postgres code, such as CitusDB.

Disadvantages of:

• The MVCC system requires regular “cleansing”: problems in environments with high transaction rates;
• Development is a large community: too much effort for improvement.

SQLITE

Proclaimed the most common DBMS in the world, SQLite was born in 2000 and is used by Apple, Facebook, Microsoft and Google. Each release is thoroughly tested. SQLite developers provide users with bug lists as well as a chronology of code changes for each version.

Advantages of:

• No separate server process;
• The file format is cross-platform;
• Transactions meet ACID requirements;
• Professional support available.

Disadvantages of:

Not recommended for:

• client-server applications;
• large scale sites;
• large data sets;
• programs with a high degree of multi-threading.

Any ideas?

Did I miss any of the significant advantages or disadvantages of the database development solutions listed above? Do you think there are better alternative DBMS solutions? Share your opinion in the comments.