Databases

Cara Menginstal PostgreSQL pada Ubuntu 20.04 [Mulai Cepat] — step-by-step Linux tutorial on Progressive Robot

Cara Menginstal PostgreSQL pada Ubuntu 20.04 [Mulai Cepat]

PostgreSQL, atau Postgres, adalah sistem manajemen basis data relasional yang menyediakan penerapan dari bahasa pengkuerian SQL. Panduan mulai cepat ini mendemonstrasikan cara menginstal Postgres pada server Ubuntu 20.04. Panduan ini juga menyediakan instruksi untuk administrasi basis data umum.

Read more
How To Install WordPress with Caddy on CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Install WordPress with Caddy on CentOS 7

WordPress is a CMS that can be used to set up blogs and websites quickly and easily. In this guide, we’ll set up WordPress with Caddy. Caddy is a new web server quickly gaining popularity for its wide array of unique features, like HTTP/2 support and automatic TLS encryption with Let’s Encrypt, a popular free certificate provider.

Read more
How To Manage Lists in Redis — step-by-step Linux tutorial on Progressive Robot

How To Manage Lists in Redis

In Redis, a list is a collection of strings sorted by the order in which they were inserted unless otherwise specified, similar to linked lists. This tutorial details how to create lists and retrieve and delete elements from lists.

Read more
How To Migrate a MySQL Database to PostgreSQL Using pgLoader — step-by-step Linux tutorial on Progressive Robot

How To Migrate a MySQL Database to PostgreSQL Using pgLoader

The prospect of migrating a database can be intimidating, especially when migrating from one database management system to another. This tutorial provides instructions on how to install pgLoader, an open-source database migration tool, and use it to migrate a remote MySQL database to PostgreSQL over an SSL connection.

Read more
How To Optimize MySQL Queries with ProxySQL Caching on Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

How To Optimize MySQL Queries with ProxySQL Caching on Ubuntu 16.04

ProxySQL is a SQL-aware proxy server that can be positioned between your application and your database to create a caching layer to optimize MySQL queries. In this tutorial, you will use ProxySQL to set up transparent caching for a MySQL server on Ubuntu 16.04. You will then test its performance using mysqlslap with and without caching to demonstrate the effect of caching and how much time it can save when executing many similar queries.

Read more
Настройка Django с Postgres, Nginx и Gunicorn в Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

Настройка Django с Postgres, Nginx и Gunicorn в Ubuntu 18.04

Django — это мощная веб-система, помогающая создать приложение или сайт Python с нуля. Django включает упрощенный сервер разработки для локального тестирования кода, однако для серьезных производственных задач требуется более защищенный и мощный веб-сервер. В этом руководстве…

Read more
How To Use Aggregations in MongoDB — step-by-step Databases tutorial on Progressive Robot

How To Use Aggregations in MongoDB

MongoDB provides aggregation operations through aggregation pipelines — a sequential series of data processing operations through which the documents go to obtain the final result. In this tutorial, you’ll learn by example how to use the most common features of the aggregation pipelines.

Read more
How To Use ProxySQL as a Load Balancer for MySQL on Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

How To Use ProxySQL as a Load Balancer for MySQL on Ubuntu 16.04

ProxySQL is an open-source MySQL proxy server which can improve performance by distributing traffic among a pool of multiple database servers and also improve availability by automatically failing over to a standby if a database server fails. In this guide, you will set up ProxySQL as a load balancer for multiple MySQL servers with automatic failover.

Read more
CHAT