Databases

How To Install and Configure Neo4j on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Configure Neo4j on Ubuntu 20.04

Neo4j is a graph database that records relationships between data nodes, whereas traditional relational databases use rows and columns to store and structure data. Since each node stores references to all the other nodes that it is connected to, Neo4j…

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

How To Use Indexes in MongoDB

Indexes are one of the most essential tools the database administrator can use to consciously aid the database engine and improve its performance. In this tutorial, you’ll learn what indexes are, how to create them and check if they are used when querying the database.

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

How To Install and Use TimescaleDB on Ubuntu 20.04

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 Ubuntu 20.04, 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 compress data and get rid of unnecessary data.

Read more
How To Use Joins in SQL — step-by-step DevOps tutorial on Progressive Robot

How To Use Joins in SQL

Many database designs separate information into different tables based on how certain data points relate to one another. Even in cases like this, it’s likely that there will be times when someone will want to retrieve information from more than one table at a time. A common way of accessing data from multiple tables in a single SQL operation is to combine the tables with a JOIN clause. This guide outlines how to retrieve data from multiple tables by joining them together.

Read more
Como Gerenciar Conjuntos no Redis — step-by-step Linux tutorial on Progressive Robot

Como Gerenciar Conjuntos no Redis

O Redis é um datastore ou armazenamento de dados open-source de chave-valor na memória. Conjuntos ou Sets no Redis são coleções de strings armazenadas em uma determinada chave. Quando mantido em um conjunto, um…

Read more
CHAT