-
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
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
-
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
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
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 us...
•
By
bsder
Big Data
Databases
Ubuntu 20.04
-
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
-
Book
This book aims to provide an approachable introduction to Redis concepts by outlining many of the key-value store's commands so readers can learn their patterns and syntax, thus building up readers' understanding grad...
•
By
Mark Drake
Books
Databases
Redis
NoSQL
DigitalOcean Managed Redis
-
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
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 series
Series Description
Structured Query Language (https://en.wikipedia.org/wiki/SQL) — commonly known as SQL — is a language used to define, control, manipulate, and query data held in a relational database. SQL has been ...
•
By
Mark Drake
Databases
Conceptual
SQL
-
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
MySQL
MariaDB
Databases
Ubuntu
Ubuntu 18.04
Featured tutorial
