Linux

How To Troubleshoot MySQL Queries — step-by-step Linux tutorial on Progressive Robot

How To Troubleshoot MySQL Queries

Sometimes users run into problems once they begin issuing queries on their data. In some database systems, including MySQL, query statements in must end in a semicolon (;) for the query to complete, as in the following example…

Read more
How To Upgrade to Ubuntu 20.04 Focal Fossa — step-by-step Linux tutorial on Progressive Robot

How To Upgrade to Ubuntu 20.04 Focal Fossa

The Ubuntu operating system’s latest Long Term Support (LTS) release, Ubuntu 20.04 (Focal Fossa), was released on April 23, 2020. This guide will explain how to upgrade an Ubuntu system of version 18.04 or later to Ubuntu 20.04.

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
How To Use Logstash and Kibana To Centralize Logs On Ubuntu 14.04 — step-by-step Linux tutorial on Progressive Robot

How To Use Logstash and Kibana To Centralize Logs On Ubuntu 14.04

In this tutorial, we will go over the installation of Logstash 1.4.2 and Kibana 3, and how to configure them to gather and visualize the syslogs of our systems in a centralized location. Logstash is an open source tool for collecting, parsing, and storing logs for future use. Kibana 3 is a web interface that can be used to search and view the logs that Logstash has indexed.

Read more
CHAT