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
20 Results
Newest
All time
English
- 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 answer • 1 day ago • By 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 answer • 5 days ago • By 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 ago • By 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 yet • 14 days ago • By 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 yet • 14 days ago • By 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 answer • 15 days ago • By 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 ago • By 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 ago • By 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 ago • By 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 ago • By 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 ago • By 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 ago • By 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 ago • By 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 ago • By 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 ago • By 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 answer • 21 days ago • By 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 ago • By 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 ago • By 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 ago • By 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 answer • 22 days ago • By sergio t. ruizDatabasesDigitalOcean App PlatformPostgreSQL