Databases

How To Install WordPress with a Managed Database on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Install WordPress with a Managed Database on Ubuntu 18.04

WordPress is the most popular CMS (content management system) on the internet. It allows you to easily set up flexible blogs and websites on top of a MySQL backend with PHP processing. In this guide, we’ll focus on getting a WordPress instance set up on a managed MySQL database on an Ubuntu 18.04 server.

Read more
How To Install and Use PostgreSQL on CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use PostgreSQL on CentOS 7

PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced features like reliable transactions and concurrency without read locks.

Read more
How To Install the Latest MySQL on Debian 10 — step-by-step Linux tutorial on Progressive Robot

How To Install the Latest MySQL on Debian 10

MySQL is a prominent open source database management system used to store and retrieve data for a wide variety of popular applications. MySQL is the M in the LAMP stack, a commonly used set of open source software that also includes Linux, the…

Read more
How To Delete Data in SQL — step-by-step DevOps tutorial on Progressive Robot

How To Delete Data in SQL

As the name implies, DELETE operations irreversibly delete one or more rows of data from a database table. Being such a fundamental aspect of data management, it’s important for SQL users to understand how the DELETE statement behaves and how it deletes data. This guide will go over how to use SQL’s DELETE syntax to delete data from one or more tables. It will also explain how foreign key constraints handle DELETE operations.

Read more
CHAT