Databases

How To Order Query Results in Laravel Eloquent — step-by-step Programming tutorial on Progressive Robot

How To Order Query Results in Laravel Eloquent

In a previous part of this series, you learned how to obtain database records using the all() method from within an Eloquent model, sorting the resulting collection with the sortDesc() method. In this guide, you’ll learn how to use the orderBy() method to sort results in the database query itself, which offers more flexibility and performance to order query results at the database level.

Read more
Установка и использование TimescaleDB в Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

Установка и использование TimescaleDB в Ubuntu 18.04

Автор выбрал Computer History Museum для получения пожертвования в рамках программы Write for DOnations. Многие приложения, в том числе системы мониторинга и сбора данных, собирают данные для дальнейшего анализа. В…

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
How To Use Unions in SQL — step-by-step DevOps tutorial on Progressive Robot

How To Use Unions in SQL

When retrieving data from a database, you may need to refer to more than one table at a time. In Structured Query Language (SQL), you can use the `UNION` operation, which takes the results of two queries with matching columns and merges them into one. In this guide, you will use `UNION` operations to retrieve data from more than one table simultaneously and combine the results. You will also combine the `UNION` operator with filtering to order the results.

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

How To Install MySQL on Ubuntu 18.04

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data. This tutorial will explain how to install MySQL version 5.7 on an Ubuntu 18.04 server.

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
CHAT