Databases

Databases are organized data structures that store information. Typically, databases contain multiple tables and many different fields that hold data. Databases are a key component of many websites and applications, and are at the core of how data is stored and exchanged across the internet.

featured tutorialHow To Install and Use PostgreSQL on Ubuntu 20.04
PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL queryi...

Mark Drake • Published on April 23, 2020 · Updated on March 18, 2022

featured tutorialSQLite 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 Postg...

ostezer, and Mark Drake • Published on February 21, 2014 · Updated on March 9, 2022

featured tutorialHow To Manage a Redis Database eBook
This book aims to provide an approachable introduction to Redis concepts by outlining many of the key-value store’s c...

Mark Drake • Published on July 17, 2020 · Updated on July 17, 2020

Subscribe to Databases
Get notified when new articles on Databases are published.
    All
  • 20 Results
    • Question

      Check provision status of api created database cluster

      We are creating a database cluster from the api. That part works fine, but we need a way to check and be notified once the cluster is done provisioning so we can add the databases to it. We tried making a curl call to...
      1 answer1 day agoBy Garrett WeinbergDatabasesMongoDBNode.js
    • Question

      WP database present on SFTP but can't see it when I run SHOW DATABASES; on CLI

      I was facing some issue with mysql so I had uninstalled it completely and then reinstalled it again. So, when I went to my website now it was giving me “Error Establishing Database Connection” Just to confirm everythi...
      1 answer5 days agoBy Mohit PandeyDatabasesDigitalOcean DropletsDigitalOcean Managed MySQL Database
    • Tutorial

      How To Set Up a Remote Database to Optimize Site Performance with MySQL on Ubuntu 20.04

      This guide will walk you through the process of configuring a remote MySQL database server that your website or application can connect to. It uses WordPress as a working example of something that can connect to the M...
      7 days agoBy Mark Drake, Brian Boucheron, Kong YangDatabasesMySQLUbuntuUbuntu 20.04WordPress
    • Question

      Terraform force replacement on replica already imported

      I’m trying to run terraform and don’t make changes related to the db, for that reason I already imported all the resources.I’m having an issue with the replica because I have already imported that resource, with all t...
      No answers yet14 days agoBy HappyNavyJellyfishDatabasesTerraform
    • Question

      Outgoing Traffic From Back-end Pod Through NGINX Ingress IP

      “Hello There”, I am trying to deploy a web application that uses the Django framework, running on a Daphne server on a k8s cluster. I have a couple of services listed below (FYI): Celery Celery Beat Redis Django There...
      No answers yet14 days agoBy Toni SkuljDatabasesDjangoKubernetes
    • Question

      How do I use Timescale DB with Managed Postgres in App Platform

      I was reading the tutorial on how to download timescaleDB on Ubuntu , but it did not seem to provide instructions on how to use on a Postgres managed database that is spun up from the app platform PaaS. Is this possib...
      1 answer15 days agoBy jjfantiniDatabasesDigitalOcean App PlatformDigitalOcean Managed PostgreSQL DatabasePostgreSQL
    • Tutorial

      How To Create Artisan Commands To Manage Database Records in Laravel

      If you followed along with this series so far, your database tables should be all set by now. However, you still need to implement a way to let users insert new entries in the links table. In this guide, we’ll create ...
      18 days agoBy Erika HeidiLaravelPHPPHP FrameworksDatabases
    • Tutorial

      How To Use Migrations to Create and Manage Database Tables in Laravel

      In this guide, you’ll create a database migration to set up the table where you’ll save the application links. In order to do that, you’ll use the Artisan command-line tool that comes with Laravel by default. At the e...
      18 days agoBy Erika HeidiLaravelPHPDatabasesPHP FrameworksDevelopment
    • Tutorial

      How To Create a Database Model in Laravel with Eloquent

      Eloquent is an object relational mapper (ORM) included by default within Laravel applications. It facilitates the task of interacting with database tables, providing an object-oriented approach to inserting, updating,...
      18 days agoBy Erika HeidiLaravelPHPPHP FrameworksDatabasesDevelopment
    • Tutorial

      How to Use One-to-Many Database Relationships with Flask-SQLAlchemy

      In this tutorial, you’ll build a small blogging system that demonstrates how to build one-to-many relationships using the Flask-SQLAlchemy extension. You’ll have a relationship between posts and comments, where each b...
      18 days agoBy Abdelhadi DyouriDatabasesDevelopmentFlaskPythonPython Frameworks
    • Tutorial

      How To Install and Configure Neo4j on Ubuntu 22.04

      Neo4j is a graph database that records relationships between data nodes, whereas traditional relational databases use rows and columns to store and structure data. Since each node stores references to all the other no...
      18 days agoBy Jamon CamissoDatabasesNoSQLUbuntuUbuntu 22.04
    • Tutorial

      How To Install and Use PostgreSQL on Ubuntu 22.04

      PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. This guide demonstrates how to install Postgres on an Ubuntu 22.04 server. It also prov...
      21 days agoBy Mark Drake, Kong YangDatabasesPostgreSQLUbuntuUbuntu 22.04Interactive
    • Tutorial

      How To Install MySQL on Ubuntu 22.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...
      21 days agoBy Hazel Virdó, Mark Drake, Kong YangDatabasesMySQLUbuntuUbuntu 22.04Interactive
    • Tutorial

      How To Install and Secure phpMyAdmin on Ubuntu 22.04

      phpMyAdmin is an application that allows users to interact with MySQL databases through a web interface. This tutorial outlines the process of installing and securing phpMyAdmin on an Ubuntu 22.04 server.
      21 days agoBy Mark DrakeApacheApplicationsDatabasesMySQLPHPUbuntuUbuntu 22.04
    • Tutorial

      How To Install MariaDB on Ubuntu 22.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...
      21 days agoBy Brian Boucheron, Mark Drake, Tony TranDatabasesMariaDBMySQLUbuntuUbuntu 22.04
    • Question

      CSV Import through PGAdmin Not working, alternate options?

      Hello, We wish to import data in a table from a csv. The copy command fails as super user permissions are not there. I have raised a ticket. But the issue is not resolved yet. Are there any easy tools or any other opt...
      1 answer21 days agoBy SandyGraySnorklerDatabases
    • Tutorial

      How To Set Up Django with Postgres, Nginx, and Gunicorn on Ubuntu 22.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...
      22 days agoBy Erin Glass, Jamon CamissoDatabasesDjangoNginxPostgreSQLPythonPython FrameworksUbuntu
    • Tutorial

      How To Install PostgreSQL on Ubuntu 22.04 [Quickstart]

      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 22.04 server. I...
      22 days agoBy Alex GarnettDatabasesPostgreSQLQuickstartUbuntuUbuntu 22.04Interactive
    • Tutorial

      How To Install and Secure Redis on Ubuntu 22.04

      Redis is an in-memory key-value store known for its flexibility, performance, and wide language support. This tutorial demonstrates how to install, configure, and secure Redis on an Ubuntu 22.04 server.
      22 days agoBy Mark DrakeDatabasesNoSQLRedisSecurityUbuntuUbuntu 22.04
    • Question

      How to connect APP Platform to external database?

      I have an APP that I have just deployed to the APP Platform. It looks like it runs fine, but I cannot connect to my remote database. In order to connect to the remote database, I need to add the APP’s IP to the securi...
      1 answer22 days agoBy sergio t. ruizDatabasesDigitalOcean App PlatformPostgreSQL