PostgreSQL

Como Instalar e Utilizar o PostgreSQL no Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

Como Instalar e Utilizar o PostgreSQL no Ubuntu 16.04

Sistemas gerenciadores de banco de dados são um componente chave em muitos sites web e aplicações. Eles fornecem uma forma estruturada de armazenar, organizar, e acessar informações. PostgreSQL, ou Postgres, é um sistema gerenciador de banco de dados relacional que…

Read more
How To Backup PostgreSQL Databases on an Ubuntu VPS — step-by-step Linux tutorial on Progressive Robot

How To Backup PostgreSQL Databases on an Ubuntu VPS

PostgreSQL is a popular database management system that can be used to handle the data from your website or application. This article will discuss methods of backing up PostgreSQL databases to ensure that your information will not be lost in the event of a problem.

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

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

Системы управления реляционными базами данных являются ключевым компонентом многих веб-сайтов и приложений. Они предоставляют структурированный способ хранения, организации и доступа к информации. PostgreSQL, или Postgres, — это система управления…

Read more
How To Install and Use TimescaleDB on CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use TimescaleDB on CentOS 7

TimescaleDB is an open-source database optimized for storing time series data. It is implemented as an extension of PostgreSQL and combines the ease-of-use of relational databases and the speed of NoSQL databases. By following this tutorial, you’ll set up TimescaleDB on CentOS 7, configure it, and learn how to work with it. You’ll run through creating time series databases and making simple queries. Finally, you’ll see how to get rid of unnecessary data.

Read more
How to Use Full-Text Search in PostgreSQL on Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

How to Use Full-Text Search in PostgreSQL on Ubuntu 16.04

In this tutorial, we’ll use PostgreSQL to store data containing articles for a hypothetical news website, then learn how to query the database using FTS and select only the best matches. As the final step, we will explore the available types of indexes in PostgreSQL which can be used to significantly improve performance of the full-text search queries.

Read more
CHAT