Databases

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

How To Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 18.04

A PostgreSQL database is a robust and flexible choice for your Ruby on Rails application. In this tutorial, you will set up a Ruby on Rails development environment connected to a PostgreSQL database on an Ubuntu 18.04 server. You will install and configure PostgreSQL, and then test your setup by creating a Rails application that uses PostgreSQL as its database server.

Read more
How To Manage Lists in Redis — step-by-step Linux tutorial on Progressive Robot

How To Manage Lists in Redis

In Redis, a list is a collection of strings sorted by the order in which they were inserted unless otherwise specified, similar to linked lists. This tutorial details how to create lists and retrieve and delete elements from lists.

Read more
How To Optimize MySQL Queries with ProxySQL Caching on Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

How To Optimize MySQL Queries with ProxySQL Caching on Ubuntu 16.04

ProxySQL is a SQL-aware proxy server that can be positioned between your application and your database to create a caching layer to optimize MySQL queries. In this tutorial, you will use ProxySQL to set up transparent caching for a MySQL server on Ubuntu 16.04. You will then test its performance using mysqlslap with and without caching to demonstrate the effect of caching and how much time it can save when executing many similar queries.

Read more
How To Install MySQL on Rocky Linux 8 — step-by-step Linux tutorial on Progressive Robot

How To Install MySQL on Rocky Linux 8

Introduction MySQL is an open-source database management system, commonly installed as part of the popular LEMP (Linux, Nginx, MySQL/MariaDB, PHP/Python/Perl) stack. It implements the relational model and Structured Query Language (SQL) to manage and query data. This tutorial explains how to install MySQL version 8 on a Rocky Linux 8 server. Prerequisites To complete this […]

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

How To Install and Use PostgreSQL on Rocky Linux 8

PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced features like reliable transactions and concurrency without read locks.

Read more
CHAT