-
Tutorial
A "LAMP" stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps. This stack typically consists of the Linux operating system, the Apache ...
•
By
Mark Drake
LAMP Stack
Databases
PHP
MySQL
Apache
Ubuntu 18.04
-
Tutorial
MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It uses a relational database and SQL (Structured Query Language) to ma...
•
By
Mark Drake
MySQL
Databases
Ubuntu
Ubuntu 18.04
-
Tutorial
This tutorial details the process for installing and configuring the components that constitute a LEMP stack on an Ubuntu 18.04 server, including Nginx, MySQL, and PHP. It also includes instructions for testing that t...
•
By
Justin Ellingwood, Mark Drake
LEMP
Databases
Nginx
MySQL
PHP
Ubuntu 18.04
-
Tutorial
This tutorial provides instructions on how to install the PostgreSQL database software on an Ubuntu 18.04 server. It also includes instructions for basic database management.
•
By
Justin Ellingwood, Mark Drake
PostgreSQL
Databases
Ubuntu
Ubuntu 18.04
-
Tutorial
MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It implements the relational model and uses SQL (Structured Query Langu...
•
By
Mark Drake
MySQL
Databases
Ubuntu 20.04
Ubuntu
-
Tutorial
Sharded databases have been receiving lots of attention in recent years, but many don't have a clear understanding of what they are or the scenarios in which it might make sense to shard a database. This conceptual ar...
•
By
Mark Drake
Databases
Scaling
High Availability
Conceptual
-
Tutorial
This article compares and contrasts three of the most widely implemented open-source RDBMSs: SQLite, MySQL, and PostgreSQL. Specifically, it explores the data types that each RDBMS uses, their advantages and disadvant...
•
By
ostezer, Mark Drake
MySQL
PostgreSQL
Databases
Conceptual
SQLite
-
Tutorial
Forgetting passwords happens to the best of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still gain access and reset the password if you have access to the server and a sudo-e...
•
By
Mateusz Papiernik
MySQL
MariaDB
Databases
CentOS
Debian
Ubuntu
Ubuntu 16.04
-
Tutorial
Being able to import and export your database is an important skill to have. You can use data dumps for backup and restoration purposes, so you can recover older copies of your database in case of an emergency, or you...
•
By
Mateusz Papiernik
MySQL
MariaDB
Databases
Backups
CentOS
Debian
Ubuntu
Ubuntu 16.04
-
Tutorial
MySQL is an open-source database management system. CentOS 7 prefers MariaDB, a fork of MySQL managed by the original MySQL developers and designed as a replacement for MySQL. Unless you have a specific use-case for M...
•
By
Melissa Anderson
MySQL
Databases
MariaDB
CentOS
-
Tutorial
Django is a powerful web framework that can help you get your Python application or website off the ground. Django includes a simplified development server for testing your code locally, but for anything even slightly...
•
By
Justin Ellingwood
Django
Python
Python Frameworks
Databases
PostgreSQL
Nginx
Ubuntu 18.04
-
Tutorial
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 tha...
•
By
Justin Ellingwood, Brian Boucheron, Hanif Jetha
MySQL
Databases
Debian 10
-
Many websites and applications start off with their web server and database backend hosted on the same machine. With time, though, a setup like this can become cumbersome and difficult to scale. A common solution is t...
•
By
Mark Drake
MySQL
Databases
Ubuntu
Ubuntu 18.04
-
Tutorial
PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. This quickstart guide demonstrates how to install Postgres on an Ubuntu 20.04 server. I...
•
By
Mark Drake
PostgreSQL
Databases
Ubuntu
Ubuntu 20.04
Quickstart
-
Tutorial
MariaDB is an open-source database management system, commonly used as an alternative for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It is intended to be a drop-in replacement...
•
By
Brian Boucheron, Mark Drake
MariaDB
Databases
MySQL
Ubuntu
Ubuntu 20.04
-
Tutorial
Laravel is one of the most popular open-source web application frameworks written in PHP. It aims to help developers build both simple and complex applications by making frequently-used application tasks (like caching...
•
By
Mateusz Papiernik
PHP Frameworks
LEMP
MySQL
Let's Encrypt
Security
Nginx
Databases
Ubuntu
Ubuntu 16.04
Laravel
-
Tutorial
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 bein...
•
By
Mitchell Anicas, Vadym Kalsin
PostgreSQL
CentOS
Databases
-
Tutorial
MariaDB is an open-source database management system, commonly used for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack.
•
By
Justin Ellingwood, Jamon Camisso
MariaDB
MySQL
Databases
Debian 10
-
Tutorial
MongoDB is an open-source document database used commonly in modern web applications. It is classified as a NoSQL database because it does not rely on a traditional table-based relational database structure. Instead,...
•
By
Mark Drake
MongoDB
Databases
NoSQL
Ubuntu
Ubuntu 20.04
-
Tutorial
MariaDB is an open-source database management system, commonly installed as part of the popular LEMP stack.
In this tutorial, we will explain how to install the latest version of MariaDB on a CentOS 7 server. If you ...
•
By
Melissa Anderson
MariaDB
Databases
MySQL
CentOS