Databases

How To Install MariaDB on Ubuntu 22.04 — step-by-step Linux tutorial on Progressive Robot

How To Install MariaDB on Ubuntu 22.04

MariaDB is an open-source database management system, commonly used as an alternative for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It is intended to be a drop-in replacement for MySQL. This tutorial will explain how to install MariaDB on an Ubuntu 22.04 server, and verify that it is running and has a safe initial configuration.

Read more
How To Secure MongoDB on CentOS 8 — step-by-step Linux tutorial on Progressive Robot

How To Secure MongoDB on CentOS 8

MongoDB doesn’t have authentication enabled by default, meaning that any user with access to the server where the database is installed can add and delete data without restriction. In order to secure this vulnerability, this tutorial will walk you through creating an administrative user and enabling authentication on a CentOS 8 server. You’ll then test to confirm that only this administrative user has access to the database.

Read more
How To Migrate a MySQL Database to PostgreSQL Using pgLoader — step-by-step Linux tutorial on Progressive Robot

How To Migrate a MySQL Database to PostgreSQL Using pgLoader

The prospect of migrating a database can be intimidating, especially when migrating from one database management system to another. This tutorial provides instructions on how to install pgLoader, an open-source database migration tool, and use it to migrate a remote MySQL database to PostgreSQL over an SSL connection.

Read more
An Introduction to Queries in PostgreSQL — step-by-step Linux tutorial on Progressive Robot

An Introduction to Queries in PostgreSQL

In this guide, we will discuss the basic syntax of SQL queries as well as some of the more commonly-employed functions and operators. We will also practice making SQL queries using some sample data in a PostgreSQL database.

Read more
Установка и настройка pgAdmin 4 в режиме сервера — step-by-step Linux tutorial on Progressive Robot

Установка и настройка pgAdmin 4 в режиме сервера

pgAdmin — это платформа с открытым исходным кодом для администрирования и разработки для PostgreSQL и связанных с ней систем управления базами данных. Платформа написана на Python и jQuery и поддерживает все функции PostgreSQL. Вы можете использовать…

Read more
CHAT