Databases

How To Store and Retrieve Data in MariaDB Using Python on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Store and Retrieve Data in MariaDB Using Python on Ubuntu 18.04

In this tutorial you will connect a Python application to a database server using the MySQL connector. This module allows you to make queries on the database server from within your application. You’ll set up MariaDB for a Python environment on Ubuntu 18.04 and write a Python script that connects to and executes queries on MariaDB.

Read more
How To Configure a Galera Cluster with MariaDB on Debian 9 Servers — step-by-step Linux tutorial on Progressive Robot

How To Configure a Galera Cluster with MariaDB on Debian 9 Servers

In this guide, you will configure an active-active MariaDB Galera cluster. For demonstration purposes, you will configure and test three Debian 9 Droplets that will act as nodes in the cluster. MariaDB is an open source relational database system that is fully compatible with the popular MySQL RDBMS system. Galera is a database clustering solution that enables you to set up multi-master clusters using synchronous replication.

Read more
How To Create and Manage Tables in SQL — step-by-step DevOps tutorial on Progressive Robot

How To Create and Manage Tables in SQL

Tables are the primary organizational structure in SQL databases. They consist of any number of columns, which reflect individual attributes of each row, or record, in the table. Being such a fundamental aspect of data organization, creating and managing tables are common tasks for anyone who builds or maintains databases. This guide outlines how to create tables in SQL, as well as how to modify and delete existing tables.

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

How To Use Wildcards in SQL

Like many computer languages, SQL allows the use of various wildcard characters. Wildcards are special placeholder characters that can represent one or more other characters or values. This is a convenient feature in SQL, as it allows you to search your database for your data without knowing the exact values held within it. This tutorial will go over how to query data using SQL’s designated wildcards.

Read more
Información sobre las bases de datos relacionales — step-by-step DevOps tutorial on Progressive Robot

Información sobre las bases de datos relacionales

Los sistemas de administración de bases de datos (DBMS) son programas que permiten a los usuarios interactuar con una base de datos. Les permiten controlar el acceso a una base de datos, escribir datos, ejecutar consultas y realizar otras tareas relacionadas con la…

Read more
CHAT