GitHub

postgres_to_postgres.md

This tutorial demonstrates how to use pgstream to replicate data from one PostgreSQL database to another. It covers setting up the environment, configuring pgstream, and verifying the replication of ...
InfoWorld

SQL tutorial: Learn SQL on PostgreSQL

Follow this step-by-step guide to install PostgreSQL, load data, connect to a database, and execute SQL queries including table joins PostgreSQL is an open-source, object-relational (also called ...
Virtualization Review

Running Apps in Docker, Part 1: Instantiation and Using PostgreSQL

After his introductory series, Tom Fenton deploys a database on Docker and integrates it with other apps deployed from other Docker images. In my Introduction to Docker series, I covered the basics of ...
Imperial College London

Using JDBC with Postgres and MS SQL Server

JDBC (Java Database Connectivity) is the generalised Java to RDBMS interconnection layer, analagous to ODBC in the Windows world, or Perl's DBI framework if you prefer. Using JDBC with an appropriate ...
GitHub

postgres_kafka.md

This tutorial will showcase the use of pgstream to replicate data from a PostgreSQL database to multiple targets (PostgreSQL and OpenSearch), leveraging Kafka. Kafka can also be used to replicate to a ...