Databases Archives - credativ®

PostgreSQL® is one of the oldest and most advanced object-relational Open Source database systems and offers the exceptional implementation of the ISO SQL2003 standard. Its outstanding stability and scalability is making PostgreSQL® increasingly popular, particularly in large companies. From a technical perspective, PostgreSQL® has long since offered a complete replacement for the database systems of proprietary manufacturers.

You can find further information in our PostgreSQL® Competence Center or on the project page.

Slony-I is an asynchronous replication system for PostgreSQL®.

pgBadger creates reports from PostgreSQL® server log files. Common and resource-consuming statements are collected and compiled as tables and graphs. Error messages are also grouped by frequency.

PgBouncer is a pooler for PostgreSQL® database connections. In this case, a large number of connections from the application to the pooler can be serviced by a much smaller number of connections from the pooler to the database, which saves on resources in the database server. This also accelerates the establishment of connections.

PostGIS is a geoinformation system, which builds on PostgreSQL® and extends this with geographic objects and functions. The basis for implementation is the Open Geospatial Consortium’s OpenGIS Simple Feature Access specification, which defines a data structure for geodata.

You can find more information on the project page.

MySQL is a free database management server that runs on a variety of Unix derivatives as well as on macOS, Linux, and Windows. MySQL is often used together with the Apache web server and PHP to store data for web-based services. With over 6 million installations and over 35,000 downloads every day, it is the most popular database system in the world. On February 26, 2008, MySQL was taken over by Sun Microsystems.

pgAdmin is a graphic interface for administering and maintaining PostgreSQL® databases. It is available as a web and desktop application. Besides SQL queries, backups as well as other maintenance work can be performed.

pgBackRest creates and manages PostgreSQL® backups and provides point-in-time recovery (PITR). This involves the regular creation of base backups with the option of using full, incremental, and differential backups.

Between the base backups, the archiving of the transaction logs ensures the seamless backup of the database activity.

Barman creates and manages PostgreSQL® backups and provides point-in-time recovery (PITR). A central Barman server can be used as a backup center for a large number of PostgreSQL® servers.

Cassandra, developed and supported by the Apache project, is a FOSS database management system for NoSQL databases. The application was originally developed by Facebook to support inbox search features, and in July 2008 it was released as an Open Source project. In 2009 Cassandra became part of the Apache Incubator project before becoming an Apache Top-Level project in 2010.

The main feature of Cassandra is its ability to distribute data over a large number of servers to not only ensure high availability but also to make sure that no single point of failure exists. Cassandra’s cluster concept is also “masterless”, i.e. does not have a specific controlling server, rather it consists of a cooperating network of all the servers included in the cluster. One of the key features of this tight network is the replication across various data centers.

Instead of, as is often the case, using SQL as the query language, Cassandra provides CQL – Cassandra Query Language. This adds another layer of abstraction between the database and users, and contains a multitude of commands specifically tailored to Cassandra and cluster applications. As a Java-based system, Cassandra can be monitored using Java Management Extensions. For example, Nodetool can be used as the management system in order to add machines to/remove them from the cluster, for instance.

MariaDB is a fork of MySQL, which pursues a community-oriented development process.
The aim of MariaDB is to remain as compatible as possible with MySQL despite numerous further developments.

You can find more information on the project page.