Databases

How To Reset Your MySQL or MariaDB Root Password on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Reset Your MySQL or MariaDB Root Password on Ubuntu 18.04

Forgetting passwords happens to the best of us. If you forget or lose the **root** password to your MySQL or MariaDB database, you can still gain access and reset the password if you have access to the server and a sudo-enabled user account. In this tutorial you’ll reset the root password for your MySQL or MariaDB database running on Ubuntu 18.04.

Read more
How to Set Up a Website Hit Counter With Redis and PHP on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How to Set Up a Website Hit Counter With Redis and PHP on Ubuntu 20.04

A hit counter is an application that records and indicates the number of visits your web page has received. The counter starts from 1 and is incremented once every time a web page is visited. To keep track of the visits, the hit counter application requires a form of a database. To track your site visits, you require a Redis hash map. In this guide, you’ll set up a website hit counter with Redis and PHP on your Ubuntu 20.04 server.

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

How To Use MongoDB Compass

With MongoDB Compass, you can access most of the features the MongoDB database engine offers through an intuitive visual display. You can glance through the databases, collections, and individual documents, interactively create queries, manipulate existing documents, and design aggregation pipelines through a dedicated interface.

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
Compreendendo bancos de dados relacionais — step-by-step DevOps tutorial on Progressive Robot

Compreendendo bancos de dados relacionais

Os sistemas de gerenciamento de banco de dados (SGDB, no inglês DMBS) são programas de computador que permitem que usuários interajam com um banco de dados. Um DBMS permite que os usuários controlem o acesso a um banco de dados, gravem dados, executem consultas e façam outras…

Read more
CHAT