Databases

A database is a collection of structured information organized in a way that it can be easily accessed, managed, and updated by computer programs. Complex databases often use more formalized structures and design patterns, typically defined by a Database Management System (DBMS). There are many different types of common database management systems, some using design patterns like the Relational Model and NoSQL, with query languages like SQL.

featured tutorialHow To Install and Secure Redis on Ubuntu 20.04
Redis is an in-memory key-value store known for its flexibility, performance, and wide language support. This tutoria...

Mark Drake • Published on May 1, 2020 · Updated on May 1, 2020

featured tutorialHow To Install PostgreSQL on Ubuntu 20.04 [Quickstart]
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 tutorialAn Introduction to Document-Oriented Databases
This conceptual article outlines the key concepts related to document databases and discusses benefits of using them....

Mateusz Papiernik • Published on July 20, 2021 · Updated on July 20, 2021

Subscribe to Databases
Get notified when new articles on Databases are published.
    All
  • 20 Results
    Newest
    All time
    English
    • Tutorial

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

      In this tutorial, you’ll modify an application built using Flask and Flask-SQLAlchemy by adding a many-to-many relationship to it. You’ll have a relationship between posts and tags, where each blog post can have sever...
      0 days agoBy Abdelhadi DyouriDatabasesDevelopmentFlaskPythonPython Frameworks
    • Question

      Does Digital Ocean Keep Backups past a month?

      I am trying to retrieve a backup that was about a month ago because when I reset my server I lost the main Database file. I cannot find the backup from around a month ago and further on in my backups list. Does Digita...
      No answers yet0 days agoBy YivsterBackupsDatabasesDigitalOcean Droplets
    • Question

      Does Digital Ocean Keep Backups past a month?

      I am trying to retrieve a backup that was about a month ago because when I reset my server I lost the main Database file. I cannot find the backup from around a month ago and further on in my backups list. Does Digita...
      No answers yet0 days agoBy YivsterBackupsDatabasesDigitalOcean Droplets
    • Question

      Does Digital Ocean keep backups after 30 days?

      I am trying to retrieve a backup that was about a month ago because when I reset my server I lost the main Database file. I cannot find the backup from around a month ago and further on in my backups list. Does Digita...
      No answers yet0 days agoBy YivsterBackupsDatabasesDigitalOcean Droplets
    • Question

      mysql is using 100% cpu and causing establishing database error

      my droplet: 4 GB Memory / 80 GB Disk / BLR1 - Ubuntu/ wordpress/ woo commerceI’m getting database error every 2 hour, sometime i can resolve it by restarting the droplet, and sometime i need to restore a backupfunny t...
      Accepted Answer: Hi there, I would suggest a few things: Try following the steps from this tutorial here on how to tweak your MySQL server for better performance: https://www.digitalocean.com/community/questions/how-to-tweak-mysql-mar...
      1 answer4 days agoBy BIOFOOT MEADICALDatabasesMySQLUbuntu 20.04
    • Question

      App is unable to connect to MongoDB database when added as a trusted source.

      I have an App and a MongoDB database both hosted by DigitalOcean. When I add the app as a trusted source (tripled checked the name) my web app is unable to connect to the database. When I remove the app as a trusted s...
      1 answer13 days agoBy Tom PetersApplicationsDatabasesDigitalOceanDigitalOcean App PlatformDigitalOcean Managed MongoDB DatabaseMongoDB
    • 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...
      15 days agoBy Brian Boucheron, Mark Drake, Tony TranMariaDBDatabasesMySQLUbuntuUbuntu 22.04
    • Question

      Database Error when logging into wordpress

      I can access my website but can’t log into my wordpress website. When I do that I get Database error. I tried doing repairing database but it still showed my database error. I don’t know what happened but I haven’t ch...
      2 answers21 days agoBy Mohit PandeyDatabasesDigitalOcean Managed MySQL DatabaseMySQLWordPress
    • Question

      Can DigitalOcean staff access the data on my database?

      Similar to this question . But since the data is encrypted at rest access to the physical machine shouldn’t be enough to read.
      1 answer25 days agoBy Tim - Databases
    • Question

      How to save all data from database cluster before destroy database?

      I want to save data from my digital ocean’s database before destroy the database cluster. How to save all data ?
      Accepted Answer: Hello, In addition to what has already been mentioned, you can follow the steps from the official documentation here too: https://docs.digitalocean.com/products/databases/postgresql/how-to/import-databases/#export-an-...
      2 answers29 days agoBy EatingNavySnorklerDatabasesDigitalOcean Managed PostgreSQL Database
    • Tutorial

      How To Use Views in SQL

      In Structured Query Language (SQL), a “view” is a virtual table whose contents are the result of a specific query to one or more tables. This guide provides an overview of what SQL views are and why they can be useful...
      1 month agoBy Mark DrakeDatabasesInteractiveSQL
    • Question

      How to connect to database from a docker container inside a droplet?

      I have just created a droplet and installed Docker to run an openjdk image with a springboot app but i get this error when trying to connect to my database java.sql.SQLNonTransientConnectionException: Could not create...
      1 answer1 month agoBy Fer PerezDatabasesDockerJavaMySQLNetworking
    • 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 month 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 answer1 month 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...
      1 month 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 yet2 months 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 yet2 months 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 answer2 months 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 ...
      2 months agoBy Erika HeidiDatabasesLaravelPHPPHP Frameworks
    • 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...
      2 months agoBy Erika HeidiDatabasesLaravelPHPPHP FrameworksDevelopment