Databases

How To Build a REST API with Prisma and PostgreSQL — step-by-step Docker tutorial on Progressive Robot

How To Build a REST API with Prisma and PostgreSQL

Prisma is an open source database toolkit. In this tutorial, you will build a REST API for a small blogging application in TypeScript using Prisma and a PostgreSQL database. At the end of the tutorial, you will have a web server running locally on your machine that can respond to various HTTP requests and read and write data in the database.

Read more
How To Configure a Galera Cluster with MySQL on Ubuntu 18.04 Servers — step-by-step Linux tutorial on Progressive Robot

How To Configure a Galera Cluster with MySQL on Ubuntu 18.04 Servers

In this guide, you will configure an active-active MySQL Galera cluster with three Ubuntu 18.04 servers. Clustering adds high availability to your MySQL database by distributing changes to different servers. In the event that one of the instances fails, others are quickly available to continue serving. Galera is a database clustering solution that enables you to set up multi-master clusters using synchronous replication.

Read more
How To Connect to a Managed Database on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Connect to a Managed Database on Ubuntu 18.04

If you’re new to working with managed databases, the best way to perform certain tasks, like connecting to the database, may not be self-evident. In this guide, we will go over how to install client programs for a variety of database management systems, including PostgreSQL, MySQL, and Redis, on an Ubuntu 18.04 server. We’ll also explain how to use these programs to connect to a managed database instance.

Read more
How To Design a Document Schema in MongoDB — step-by-step Databases tutorial on Progressive Robot

How To Design a Document Schema in MongoDB

Document-oriented databases like MongoDB make it possible to break free from rigidity and limitations of the relational model. However, the flexibility and freedom from being able to store self-descriptive documents in the database can lead to other pitfalls and difficulties. This conceptual article outlines the common guidelines related to schema design in a document-oriented database and typical ways to model relationships between data.

Read more
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 CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use ClickHouse on CentOS 7

ClickHouse is an open-source, column-oriented analytics database created by Yandex for OLAP 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 Install and Use PostgreSQL on CentOS 8 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use PostgreSQL on CentOS 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
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 Install MariaDB on Debian 11 — step-by-step Linux tutorial on Progressive Robot

How To Install MariaDB on Debian 11

MariaDB is an open-source database management system, commonly used for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. In this tutorial, install it on Debian 11.

Read more
CHAT