Databases

Установка PostgreSQL в Ubuntu 20.04 [Краткое руководство] — step-by-step Linux tutorial on Progressive Robot

Установка PostgreSQL в Ubuntu 20.04 [Краткое руководство]

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

Read more
Understanding Database Sharding — step-by-step DevOps tutorial on Progressive Robot

Understanding Database Sharding

Sharded databases have been receiving lots of attention in recent years, but many don’t have a clear understanding of what they are or the scenarios in which it might make sense to shard a database. This conceptual article goes over what sharding is, some of its main benefits and drawbacks, and also a few common sharding methods.

Read more
Managed Databases Connection Pools and PostgreSQL Benchmarking Using pgbench — step-by-step Databases tutorial on Progressive Robot

Managed Databases Connection Pools and PostgreSQL Benchmarking Using pgbench

In this tutorial we’ll use `pgbench`, PostgreSQL’s built-in benchmarking tool, to run load tests on a the cloud provider Managed PostgreSQL Database. We’ll dive in to connection pools, describe how they work, and show how to create one using the Cloud Control panel. Finally, using results from the `pgbench` tests, we’ll demonstrate how using a connection pool can be an inexpensive method of increasing database throughput.

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

What is MariaDB?

MariaDB is an open-source relational database management system. As with other relational databases, MariaDB stores data in tables made up of rows and columns. Users can define, manipulate, control, and query data using Structured Query Language, more commonly known as…

Read more
CHAT