Databases

Контейнеризация приложения Node.js для разработки с использованием Docker Compose — step-by-step Docker tutorial on Progressive Robot

Контейнеризация приложения Node.js для разработки с использованием Docker Compose

Если вы активно занимаетесь разработкой приложений, использование Docker может упростить ваш рабочий процесс и процесс развертывания вашего приложения в продакшен. Работа с контейнерами в процессе разработки предоставляет следующие преимущества: Среды…

Read more
How To Analyze Managed Redis Database Statistics Using the Elastic Stack on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Analyze Managed Redis Database Statistics Using the Elastic Stack on Ubuntu 18.04

Database monitoring is the continuous process of systematically tracking various metrics that show how the database is performing. In this tutorial, you’ll import database metrics, generated by the Redis INFO command, into Elasticsearch via Logstash. The imported data can later be analyzed and visualized in Kibana. By the end of the tutorial, you’ll have an automated system pulling in Redis statistics for later analysis.

Read more
How To Configure a Galera Cluster with MariaDB on CentOS 7 Servers — step-by-step Linux tutorial on Progressive Robot

How To Configure a Galera Cluster with MariaDB on CentOS 7 Servers

In this guide, you will configure an active-active MariaDB Galera cluster. For demonstration purposes, you will configure and test three CentOS 7 Droplets that will act as nodes in the cluster. MariaDB is an open source relational database system that is fully compatible with the popular MySQL RDBMS system. Galera is a database clustering solution that enables you to set up multi-master clusters using synchronous replication.

Read more
How To Create a Database Model in Laravel with Eloquent — step-by-step Programming tutorial on Progressive Robot

How To Create a Database Model in Laravel with Eloquent

Eloquent is an object relational mapper (ORM) included by default within Laravel applications. It facilitates the task of interacting with database tables, providing an object-oriented approach to inserting, updating, and deleting database records, while also providing a streamlined interface for executing SQL queries. In this guide, which is part of a larger Laravel series, you’ll see how to create an Eloquent model for a links landing application.

Read more
How To Insert New Database Records in Laravel Eloquent — step-by-step Programming tutorial on Progressive Robot

How To Insert New Database Records in Laravel Eloquent

In the second part of our Practical Introduction to Laravel Eloquent Series, you’ll learn how to insert records in the database using Eloquent models. One of the biggest advantages of using an ORM system is the ability to manipulate rows in a database table as objects within your codebase. With Eloquent, as with other ORMs, the object itself provides methods that can be used to persist it to the database, saving you the work of writing SQL statements.

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

How To Install and Use ClickHouse on Debian 9

ClickHouse is an open-source, column-oriented analytics database created by [Yandex](https://yandex.com) 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
CHAT