Databases

How To Install and Secure Redis on CentOS 8 — step-by-step Linux tutorial on Progressive Robot

How To Install and Secure Redis on CentOS 8

This tutorial provides instructions for installing Redis on a CentOS 8 server and using its built-in security features, in coordination with some other security configurations, to keep it from being accessed by unauthorized users.

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

How To Install and Use ClickHouse on Ubuntu 18.04

[ClickHouse](https://clickhouse.yandex) is an open-source, column-oriented analytics database for [OLAP](https://en.wikipedia.org/wiki/Online_analytical_processing) and big data use cases. In this tutorial, you’ll install the ClickHouse database server and client on your machine. You’ll use the DBMS for typical tasks and optionally enable remote access from another server so that you’ll be able to connect to the database from another machine.

Read more
How To Use the BETWEEN and IN Operators in SQL — step-by-step DevOps tutorial on Progressive Robot

How To Use the BETWEEN and IN Operators in SQL

In certain Structured Query Language (SQL) statements, WHERE clauses can be used to limit what rows the given operation will affect. SQL allows users to retrieve granular result sets by providing a variety of different types of predicates, each of which use a specific operator to evaluate rows. This guide will outline two types of predicates: range predicates which use the BETWEEN operator, and set membership predicates which use the IN operator.

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 Use SQLite with Node.js on Ubuntu 22.04 — step-by-step Linux tutorial on Progressive Robot

How To Use SQLite with Node.js on Ubuntu 22.04

In this tutorial, readers will use node-sqlite3 to create a connection with an SQLite database. Next, they’ll create a Node.js app that creates a table and insert data into the database. Finally, they’ll modify the app to use node-sqlite3 to retrieve, update, and delete data from the database.

Read more
CHAT