Table of contents


DBA tools

Alter a column data type in all tables

To list all the indexes of a database

To list all pk’s and fk’s in a database

SQL Design patterns

Calculated columns with a trigger

Remove duplicate records from a table

How to safely delete records ?

A simple audit system

 Docker & PostgreSQL & Pgadmin4

1. How to install docker on Ubuntu

2. How to install PostgreSQL with Docker

3. How to add a persistent volume

4. How to install pgadmin4 with Docker

5. How to install the PL/pgSQL debugger

PostgreSQL and Node.js

To come soon..

Document databases

To come soon…

Temporal databases

To come soon…

Analytical functions

To come soon…

The sandbox framework

A framework for distributed queries where each user his own database called the sandbox where he maps tables from several databases with the Foreign Data Wrapper protocol of PostgreSQL.

1. Architecture

2. A fdw table definitions server

3. The kernel

4. The function connect_database

5. Utilities

6. The attach functions

7. Usage