Databases

Securing Communications in a Three-tier Rails Application Using SSH Tunnels — step-by-step Linux tutorial on Progressive Robot

Securing Communications in a Three-tier Rails Application Using SSH Tunnels

Web applications are often architected with three distinct tiers: the presentation layer, which is what the user sees, the application layer, which provides the business logic of the application, and the data layer which stores the application’s data. In this tutorial, you will deploy a Rails app in a three-tier configuration by installing a unique set of software on three separate servers, configuring each server and their components to communicate and function securely and effectively.

Read more
What is MariaDB? — step-by-step Databases tutorial on Progressive Robot

What is MariaDB?

MariaDB is an open-source relational database management system. As with other relational databases, MariaDB stores data in tables made up of rows and columns. Users can define, manipulate, control, and query data using Structured Query Language, more commonly known as…

Read more
How To Change Redis's Configuration from the Command Line — step-by-step Linux tutorial on Progressive Robot

How To Change Redis’s Configuration from the Command Line

There may be times where you want to change the behavior of your Redis instance on the fly. Redis has several commands that allow you to make changes to the Redis server’s configuration settings directly from the redis-cli interface. This tutorial will go over some of these commands, and also explain how to make these configurations permanent.

Read more
How To Configure Remote Access for MongoDB on CentOS 8 — step-by-step Linux tutorial on Progressive Robot

How To Configure Remote Access for MongoDB on CentOS 8

This tutorial walks you through configuring a MongoDB installation to securely allow access from a trusted remote computer. This will involve updating your firewall rules to provide the remote server access to MongoDB’s default port and changing Mongo’s configuration file to update its IP binding setting.

Read more
How To Create and Manage Tables in SQL — step-by-step DevOps tutorial on Progressive Robot

How To Create and Manage Tables in SQL

Tables are the primary organizational structure in SQL databases. They consist of any number of columns, which reflect individual attributes of each row, or record, in the table. Being such a fundamental aspect of data organization, creating and managing tables are common tasks for anyone who builds or maintains databases. This guide outlines how to create tables in SQL, as well as how to modify and delete existing tables.

Read more
CHAT