MySQL

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 Use Nested Queries in SQL — step-by-step Databases tutorial on Progressive Robot

How To Use Nested Queries in SQL

A useful function in SQL is creating a query within a query, also known as a subquery or nested query. A nested query is a SELECT statement that is typically enclosed in parentheses, and embedded within a primary SELECT, INSERT, or DELETE operation.

Read more
How To Ensure Code Quality with SonarQube on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Ensure Code Quality with SonarQube on Ubuntu 18.04

Code quality is an approximation of how useful and maintainable a specific piece of code is. Quality code will make the task of maintaining and expanding your application easier. In this guide, you will deploy a SonarQube server and scanner to analyze your code and create code quality reports. Then you’ll perform a test on your machine by scanning it with the SonarQube tool.

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 Configure Varnish for Drupal with Apache on Debian and Ubuntu — step-by-step Linux tutorial on Progressive Robot

How To Configure Varnish for Drupal with Apache on Debian and Ubuntu

In this the cloud provider article, as a part of a series to help developers with scaling, we will be talking about configuring Varnish with Drupal. This will greatly reduce the amount of time it takes users to load your Drupal based website, and increase the simultaneous serving capacity of your the cloud provider VPS by passing requests through the Varnish Cache software first.

Read more
CHAT