MySQL

How and When to Use Sqlite — step-by-step Databases tutorial on Progressive Robot

How and When to Use Sqlite

Sqlite is a very simple and fast open source SQL engine. This tutorial will explain when it is optimal to use Sqlite, as opposed to a full-blown RDBMS such as Mysql or Postgres, as well as how to install it and basic usage examples covering CRUD – Create, Read, Update, and Delete.

Read more
How To Connect to a Managed Database on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Connect to a Managed Database on Ubuntu 18.04

If you’re new to working with managed databases, the best way to perform certain tasks, like connecting to the database, may not be self-evident. In this guide, we will go over how to install client programs for a variety of database management systems, including PostgreSQL, MySQL, and Redis, on an Ubuntu 18.04 server. We’ll also explain how to use these programs to connect to a managed database instance.

Read more
How To Install Linux, nginx, MySQL, PHP (LEMP) stack on Ubuntu 12.04 — step-by-step Linux tutorial on Progressive Robot

How To Install Linux, nginx, MySQL, PHP (LEMP) stack on Ubuntu 12.04

LEMP stack is a group of open source software to get web servers up and running. The acronym stands for Linux, nginx (pronounced Engine x), MySQL, and PHP. This tutorial explains how to install the required repos to download nginx and php-fpm, how to install MySQL, how to install nginx, how to install php-fpm, how to configure php and nginx, and how to create a php info page. This tutorial is written for Ubuntu 12.04.

Read more
CHAT