PostgreSQL

How To Use PostgreSQL with Your Ruby on Rails Application on CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Use PostgreSQL with Your Ruby on Rails Application on CentOS 7

Ruby on Rails uses sqlite3 as its default database, which works great in many cases, but may not be sufficient for your application. If your application requires the scalability, centralization, and control (or any other feature) that a client/server SQL database, this tutorial will show you how to do just that, with PostgreSQL, on CentOS 7.

Read more
Containerizing a Ruby on Rails Application for Development with Docker Compose — step-by-step Docker tutorial on Progressive Robot

Containerizing a Ruby on Rails Application for Development with Docker Compose

If you are actively developing an application, using Docker can simplify your workflow and the process of deploying your application to production. This tutorial will show you how to set up a development environment for a Ruby on Rails application using Docker. You will create multiple containers – for the application itself, the PostgreSQL database, Redis, and a Sidekiq service – with Docker Compose.

Read more
How To Choose a Redundancy Plan To Ensure High Availability — step-by-step Databases tutorial on Progressive Robot

How To Choose a Redundancy Plan To Ensure High Availability

Redundancy is a way of reducing the impact of system failures by configuring multiple avenues to achieve the objective. If a disk, a computer, or an entire portion of the network becomes unavailable for some reason, various forms of redundancy can help mitigate the impact on your currently running systems. This will allow you to address the issue without experiencing downtime.

Read more
How To Install and Use PostgreSQL on Ubuntu 22.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use PostgreSQL on Ubuntu 22.04

PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. This guide demonstrates how to install Postgres on an Ubuntu 22.04 server. It also provides instructions for general database administration.

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
CHAT