Tags:
create new tag
view all tags

Exploring database management: - The 7 best free open-source systems

IT departments work with paltry budgets. Therefore, cutting costs will allow the company not only to stay afloat, but also to direct the saved funds to development. To make better use of the available budget, let's get acquainted with 7 free systems that allow database development and management and DBM open source solutions.

  • Synopsis of

  • CUBRID

  • Firebird

  • MariaDB database software

  • MongoDB

  • MySQL

  • PostgreSQL

  • SQLite

  • Any ideas?

  • CUBRID

A free open-source database program optimized specifically for web applications. This service is designed for processing large amounts of data and generating multiple parallel queries. This solution is implemented in the C programming language.

Advantages

  • Multiple degree of blocking fragmentation;

  • Online backup creation;

  • GUI tools and drivers for JDBC, PHP, Python, Perl and Ruby;

  • Support for built-in database segmentation for scalability;

  • In large systems, data is shared across multiple database instances;

  • Full-text database replication and transaction consistency.

Disadvantages

  • Does not work on Apple systems;

  • No scripting debugger;

  • The manual is only available in English and Korean;

  • Discussions on the official forum tend to be outdated (most of them several years old).

Firebird

This database builder 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

  • Trace API for real-time monitoring;

  • Authentication with Windows authentication;

  • Four supported architectures: SuperClassic, Classic, SuperServer and Embedded;

  • Different development tools: FIBPlus and IBObjects commercial tools;

  • Automatic deployment option for database cleanup;

  • Event notifications from database triggers and stored procedures;

  • Free support for the global Firebird community. Which is important when developing database requirements.

Disadvantages

  • Integrated replication support is not included and is only available as an add-on;

  • Lack of temporary tables and integration with other database management systems;

  • Windows authentication is inadequate compared to solutions available in other operating systems.

  • MariaDB database software

dbForge Studio for SQL Server

Powerful development environment for sql server gui from Devart. This product includes a huge set of tools that make your everyday tasks much faster and easier: advanced IntelliSence, visual table and query designers, database diagrams, T-SQL debugger, query profiler, data and schema comparison, test data generation, work with source control, unit-tests support, backups creation, and much more. A kind of Swiss knife for the developer.

However, there is an express edition which is free. It is clear that the functionality is truncated and may not be enough for good work. It is absolutely free for noncommercial use. If you have an open-source project, if you want to work with databases at home, if you represent an educational institution - this tool is for you!

Advantages

  • Edit and run queries in a new SQL document

  • Build queries in a visual designer

  • Run a large script without loading it into memory

  • Track changes of production database

  • Create unit tests using tSQLt framework

  • Debug stored procedures and functions

  • Source-control database changes

  • Create database objects in a visual edit or

  • Generate database scripts


MySQL database access management

Created by the developers of MySQL, MariaDB is used by tech giants like Wikipedia, Facebook and even Google. MariaDB is a database server that offers an embedded 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 as needed.

Advantages of

  • Scalability with easy integration;

  • Real-time access;

  • Basic MySQL features (MariaDB is an alternative to MySQL);

  • Alternative storage mechanisms, server optimization and patches;

  • Extensive knowledge base of SQL database development accumulated over 20 years of MariaDB.

Disadvantages

  • No password complexity checking plugin;

  • No memcached interface (distributed in-memory caching system);

  • No optimizer trace.

MongoDB

MongoDB was founded in 2007 and is known as a "database for great ideas." The project is funded by prominent investors such as Fidelity Investments, Goldman Sachs Group, Inc. and Intel Capital. Since its inception, MongoDB has been downloaded 20 million times and is supported by more than 1,000 partners. These partners adhere to the principle of a free, open-source solution.

The merits of

  • Document validation;

  • Encrypted storage mechanism.

Popular uses:

  • Mobile apps;

  • product catalogs;

  • content management;

  • Real-time applications with in-memory storage mechanism (beta);

  • Shortens the time between initial failure and recovery.

Disadvantages

  • Not suitable for applications requiring complex transactions;

  • Not suitable for legacy applications;

  • Young solution: software is changing and evolving rapidly.

  • MySQL

  • Learning MySQL stored procedures

The most notable representative of our database development software review. The free MySQL database has been around since 1995 and is now owned by Oracle. The DBMS is open source. There are also several paid versions that offer additional features such as cluster geo-replication and automatic scaling.

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

Advantages

  • Server side validation;

  • Can be used as a local database;

  • Flexible system of privileges and passwords;

  • Secure encryption of all password traffic;

  • A library that can be embedded into standalone applications;

  • Provides a server as a stand-alone program for a client/server network environment.

Disadvantages of practical MySQL database development and administration Acquired by Oracle:

  • Users believe that MySQL no longer falls under the category of free and open source software;

  • No longer supported by the community;

  • users cannot fix bugs and patches;

  • loses out to other solutions because of 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 ACID principles (atomicity, consistency, isolation, robustness).

Advantages

  • Ability to create custom data types and query methods;

  • Database development environment executes 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): combines different sorting and search algorithms: B-tree, B+-tree, R-tree, partial sum trees and ranked B+ -trees;

  • Ability to create for more concurrency without changing Postgres code, such as CitusDB.

Disadvantages

  • MVCC system requires regular "cleanup": problems in environments with high transaction rates;

  • Development is done by a large community: too much effort for improvements.

  • SQLite

Proclaimed to be the most widely used DBMS in the world, SQLite originated 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

  • No separate server process;

  • The file format is cross-platform;

  • Transactions are ACID compliant;

  • Professional support is available.

  • Disadvantages

Not recommended for:

  • Client-server applications;

  • Large-scale sites;

  • large data sets;

  • Programs with a high degree of multithreading.

Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r2 - 2021-05-03 - DevartDevart
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2021 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback