PostgreSQL

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
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
Настройка 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 Monitor Your Managed PostgreSQL Database Using Nagios Core on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Monitor Your Managed PostgreSQL Database Using Nagios Core on Ubuntu 18.04

Database monitoring is key to understanding how a database performs at various points in time. It can help you uncover hidden usage problems and bottlenecks, and will also allow you to be in the loop of everything that is happening to your database. In this tutorial, you will set up PostgreSQL database monitoring in Nagios Core using the check_postgres Nagios plugin and set up Slack-based alerting.

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

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

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

Read more
How To Use PostgreSQL with Your Ruby on Rails Application on CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Use PostgreSQL with Your Ruby on Rails Application on CentOS 7

Ruby on Rails uses sqlite3 as its default database, which works great in many cases, but may not be sufficient for your application. If your application requires the scalability, centralization, and control (or any other feature) that a client/server SQL database, this tutorial will show you how to do just that, with PostgreSQL, on CentOS 7.

Read more
CHAT