Setting up Connections Between R and Databases

Setting up Datagrip

Getting to Know a Database Continued: a Showcase of Some Custom Functions

A Comparison of Different Ways to Define and Return Outputs From PL/pgSQL Functions

Getting to Know a Database: Using SQL-Compliant Methods to Retrieve Various Information

Creating User-Defined Functions in PostgreSQL

Setting Up PostgreSQL

Continuous Archiving and Point-in-Time Recovery with PostgreSQL