PostgreSQL

How To Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How To Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 20.04

A PostgreSQL database is a robust and flexible choice for your Ruby on Rails application. In this tutorial, you will set up a Ruby on Rails development environment connected to a PostgreSQL database on an Ubuntu 20.04 server. You will install and configure PostgreSQL, then test your setup by creating a Rails application that uses PostgreSQL as its database server.

Read more
Como Gerenciar um Banco de Dados SQL — step-by-step Databases tutorial on Progressive Robot

Como Gerenciar um Banco de Dados SQL

Os bancos de dados SQL vêm instalados com todos os comandos necessários para adicionar, modificar, excluir e consultar seus dados. Este guia de consulta rápida fornece uma referência para alguns dos comandos SQL mais usados. **Como…

Read more
How To Audit a PostgreSQL Database with InSpec on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Audit a PostgreSQL Database with InSpec on Ubuntu 18.04

InSpec is an open-source, automated testing framework for testing and auditing your system to ensure the compliance of integration, security, and other policy requirements. In this tutorial, you’ll install InSpec on a server running Ubuntu 18.04. You will start by writing a test that verifies the operating system family of the server, then you’ll create a PostgreSQL audit profile from the ground-up.

Read more
How To Install and Use phpPgAdmin on Ubuntu 12.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use phpPgAdmin on Ubuntu 12.04

phpPgAdmin is a php-based web application that provides a GUI interface for the postgresql system. It performs a similar function to phpMyAdmin, which allows users to manipulate database information in a visual program in MySQL. Here’s how to install and use phpPgAdmin on Ubuntu 12.04.

Read more
CHAT