Databases

What is the Relational Model? — step-by-step DevOps tutorial on Progressive Robot

What is the Relational Model?

The relational model is an abstract model used to organize data within a database. In order to control access to a database, write data, run queries, or perform any other tasks related to database management, a database management system must have some kind of underlying model that defines how…

Read more
Контейнеризация приложения 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
CHAT