How to Encrypt a Database at Rest in PostgreSQL on Ubuntu 22.04
Learn three ways to encrypt a database in PostgreSQL.
How To Install and Use PostgreSQL on Ubuntu 12.04
Here we give a quick guide to installing and using PostgreSQL on Ubuntu 12.04.
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 provides instructions for general database administration.
Cómo instalar y configurar pgAdmin 4 en el modo de servidor
pgAdmin es una plataforma de administración y desarrollo de código abierto para PostgreSQL y sus sistemas de administración de bases de datos relacionados. Está escrita en Python y jQuery, y es compatible con todas las características de PostgreSQL….
How To Migrate a MySQL Database to PostgreSQL Using pgLoader
The prospect of migrating a database can be intimidating, especially when migrating from one database management system to another. This tutorial provides instructions on how to install pgLoader, an open-source database migration tool, and use it to migrate a remote MySQL database to PostgreSQL over an SSL connection.
How To Set Up an ASGI Django App with Postgres, Nginx, and Uvicorn on Ubuntu 20.04
In this guide, you will set up an ASGI (Asynchronous Server Gateway Interface) Django app on Ubuntu 20.04. You’ll set up a PostgreSQL database, configure a Gunicorn application server paired with Uvicorn (an ASGI implementation), and then set up Nginx as a reverse proxy to Gunicorn, giving you access to its security and performance features to serve your apps.
How To Set Up Master Slave Replication on PostgreSQL on an Ubuntu 12.04 VPS
PostgreSQL, or postgres, is a popular database management system often used to manage the information from websites and applications. In this guide, we will configure a master server postgres replication set up, which will allow us to replicate the changes from the master server onto the slave. This can be used to distribute reads to multiple machines.
How To Use PostgreSQL with Your Ruby on Rails Application on macOS
When using the Ruby on Rails web framework, the PostgreSQL database could be a robust and flexible choice for your application. In this tutorial, you will set up a Ruby on Rails development environment connected to a PostgreSQL database on a local macOS machine. You will install and configure PostgreSQL, and then test your setup by creating a Rails application that uses PostgreSQL as its database server.
12 Days of the cloud provider (Day 3) – Checking Birthdays and Sending SMS Notifications
Learn how to use Python and Twilio to check for birthdays and send SMS notifications.
Databases Checkpoint
This checkpoint is intended to help you assess what you learned from our introductory articles to Databases, where we defined databases and introduced common database management systems.
