Databases

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 Benchmark the Performance of a Redis Server on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How to Benchmark the Performance of a Redis Server on Ubuntu 18.04

Benchmarking is an important practice to analyse the overall performance of servers and identify bottlenecks as well as opportunities for improvement within those systems. In this guide, we’ll demonstrate how to benchmark the performance of a Redis server running on Ubuntu 18.04, using a few different tools and methods.

Read more
What is Redis? — step-by-step Databases tutorial on Progressive Robot

What is Redis?

Redis is an open-source key-value data store known for its flexibility, performance, and wide language support. An in-memory database, Redis is also known for its speed and has found wide use as a cache and message broker, as well as a database.

Read more
How To Address Crashes in MySQL — step-by-step Linux tutorial on Progressive Robot

How To Address Crashes in MySQL

The most common cause of crashes in MySQL is that it stopped or failed to start due to insufficient memory. To check this, you will need to review the MySQL error log after a crash. First, attempt to start the MySQL server by typing: sudo systemctl start mysql Then…

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

How To Use WHERE Clauses in SQL

In Structured Query Language (SQL) statements, WHERE clauses limit what rows the given operation will affect. This guide will go over the general syntax used in WHERE clauses. It will also outline how to combine multiple search condition predicates in a single WHERE clause to filter data with more granularity, as well as how to use the NOT operator to exclude, rather than include, rows that meet a given search condition.

Read more
CHAT