Databases

How To Install MySQL on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Install MySQL on Ubuntu 18.04

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data. This tutorial will explain how to install MySQL version 5.7 on an Ubuntu 18.04 server.

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

Como Gerenciar Hashes no Redis

O Redis é um datastore ou armazenamento de dados open-source de chave-valor na memória. Um hash do Redis é um tipo de dado que representa um mapeamento entre um campo de string e um valor de string. Os hashes…

Read more
How To Manage an SQL Database — step-by-step Databases tutorial on Progressive Robot

How To Manage an SQL Database

SQL databases come installed with all the commands you need to add, modify, delete, and query your data. This cheat sheet-style guide provides a quick reference to some of the most commonly-used SQL commands.

Read more
How To Set Up Django with Postgres, Nginx, and Gunicorn on Debian 11 — step-by-step Linux tutorial on Progressive Robot

How To Set Up Django with Postgres, Nginx, and Gunicorn on Debian 11

Django is a powerful web framework that can help you get your Python application or website off the ground. Django includes a simplified development server for testing your code locally, but for anything even slightly production related, a more secure and powerful web server like Nginx is a major asset to your stack.

Read more
How To Troubleshoot Socket Errors in MySQL — step-by-step Linux tutorial on Progressive Robot

How To Troubleshoot Socket Errors in MySQL

MySQL manages connections to the database server through the use of a socket file, a special kind of file that facilitates communications between different processes. The MySQL server’s socket file is named mysqld.sock and on Ubuntu systems it’s usually stored in the /var/run/mysqld/…

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

How To Use Functions in SQL

When working with relational databases and Structured Query Language (SQL), you can store, manage, and retrieve data from the relational database management system. SQL can also perform calculations and manipulate data through the use of functions. In this tutorial, you’ll use different SQL functions to perform mathematical calculations, manipulate strings and dates, and calculate summaries using aggregate functions.

Read more
CHAT