Databases

Databases subscription active
You will receive email notifications for new publications on Databases.
317 Results
  • Tutorial

    How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu 18.04

    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

    How To Install MySQL on Ubuntu 18.04

    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

    How To Install and Use PostgreSQL on Ubuntu 18.04

    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

    How To Install Linux, Nginx, MySQL, PHP (LEMP stack) on Ubuntu 18.04

    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

    SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems

    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

    Understanding Database Sharding

    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

    How To Reset Your MySQL or MariaDB Root Password

    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

    How To Install MySQL on CentOS 7

    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

    How To Install MySQL on Ubuntu 20.04

    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

    How To Set Up Django with Postgres, Nginx, and Gunicorn on Ubuntu 18.04

    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

    How To Import and Export Databases in MySQL or MariaDB

    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

    How To Set Up Django with Postgres, Nginx, and Gunicorn on Ubuntu 20.04

    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 slightl...
    By Erin Glass Ubuntu 20.04 Nginx Python Python Frameworks Django PostgreSQL Databases
  • How To Allow Remote Access to MySQL

    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

    How To Deploy a Laravel Application with Nginx on Ubuntu 16.04

    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

    How To Install and Use PostgreSQL on CentOS 7

    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

    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 tha...
    By Justin Ellingwood, Brian Boucheron, Hanif Jetha MySQL Databases Debian 10
  • Tutorial

    How To Install MariaDB on Ubuntu 18.04

    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
  • Tutorial

    How To Use One-to-Many Database Relationships with Flask and SQLite

    Flask is a framework for building web applications using the Python language, and SQLite is a database engine that can be used with Python to store application data. In this tutorial, you will use Flask with SQLite to...
    By Abdelhadi Dyouri Python Frameworks Python Development Databases
  • Tutorial

    How To Install MariaDB on CentOS 7

    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
  • Tutorial

    How To Install MariaDB on Ubuntu 20.04

    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