Databases

How To Use Constraints in SQL — step-by-step DevOps tutorial on Progressive Robot

How To Use Constraints in SQL

When designing an SQL database, there may be cases where you want to impose restrictions on what data can be added to certain columns in a table. SQL makes this possible through the use of constraints. After applying a constraint to a column or table, any attempts to add…

Read more
How To Install Wordpress and PhpMyAdmin with Docker Compose on Ubuntu 14.04 — step-by-step Docker tutorial on Progressive Robot

How To Install WordPress and PhpMyAdmin with Docker Compose on Ubuntu 14.04

This article provides a real-world example of using Docker Compose to install an application, in this case WordPress with PHPMyAdmin as an extra. WordPress normally runs on a LAMP stack, which means Linux, Apache, MySQL/MariaDB, and PHP. The official WordPress Docker image includes Apache and PHP for us, so the only part we have to worry about is MariaDB.

Read more
How To Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How To Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 20.04

A PostgreSQL database is a robust and flexible choice for your Ruby on Rails application. In this tutorial, you will set up a Ruby on Rails development environment connected to a PostgreSQL database on an Ubuntu 20.04 server. You will install and configure PostgreSQL, then test your setup by creating a Rails application that uses PostgreSQL as its database server.

Read more
How To Query the Database in Laravel with Eloquent (Select) — step-by-step Programming tutorial on Progressive Robot

How To Query the Database in Laravel with Eloquent (Select)

One of the biggest advantages of using an ORM system is the ability to manipulate rows in a database table as objects within your codebase. Eloquent provides several methods that can be accessed directly from models to query the database and filter results without having to write SQL statements. In this guide, you’ll learn more about how to make database queries using Eloquent models.

Read more
How To Fix Corrupted Tables in MySQL — step-by-step Linux tutorial on Progressive Robot

How To Fix Corrupted Tables in MySQL

Occasionally, MySQL tables can become corrupted, meaning that an error has occurred and the data held within them is unreadable. Attempts to read from a corrupted table will usually lead to the server crashing. Some common causes of corrupted tables are: The MySQL server stops in middle…

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

How To Install and Use ClickHouse on CentOS 7

ClickHouse is an open-source, column-oriented analytics database created by Yandex for OLAP and big data use cases. In this tutorial, you’ll install the ClickHouse database server and client on your machine. You’ll use the DBMS for typical tasks and optionally enable remote access from another server so that you’ll be able to connect to the database from another machine.

Read more
CHAT