PostgreSQL

Установка и использование PostgreSQL на Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

Установка и использование PostgreSQL на Ubuntu 20.04

Системы управления реляционными базами данных являются ключевым компонентом многих веб-сайтов и приложений. Они предоставляют структурированный способ хранения, организации и доступа к информации. PostgreSQL, или Postgres, — это система управления…

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
12 Days of the cloud provider: Your Complete Guide — step-by-step Databases tutorial on Progressive Robot

12 Days of the cloud provider: Your Complete Guide

A recap of the 12 Days of the cloud provider tutorial series. Build a Birthday Reminder Service and an Email Receipt Processor while exploring the cloud provider services like managed databases, serverless functions, object storage, logging, and APIs like Twilio and GenAI.

Read more
How To Install and Use PostgreSQL 9.4 on Debian 8 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use PostgreSQL 9.4 on Debian 8

Relational databases are the cornerstone of data organization for a multitude of needs. They power everything from online shopping to rocket launches. A database that is both venerable but very much still in the game is PostgreSQL. PostgreSQL follows most of the SQL standard, has ACID transactions, has support for foreign keys and views, and is still in active development.

Read more
Como Instalar e Utilizar o PostgreSQL no Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

Como Instalar e Utilizar o PostgreSQL no Ubuntu 16.04

Sistemas gerenciadores de banco de dados são um componente chave em muitos sites web e aplicações. Eles fornecem uma forma estruturada de armazenar, organizar, e acessar informações. PostgreSQL, ou Postgres, é um sistema gerenciador de banco de dados relacional que…

Read more
How To Use a PostgreSQL Database in a Flask Application — step-by-step Databases tutorial on Progressive Robot

How To Use a PostgreSQL Database in a Flask Application

In web applications, you usually need a database, which is an organized collection of data. You use a database to store and maintain persistent data that can be retrieved and manipulated efficiently. PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. In this tutorial, you’ll build a small book review web application that demonstrates how to use the psycopg2 library, a PostgreSQL database adapter.

Read more
CHAT