Read replicas and Spring Data Part 3: Configuring two entity managers

Our previous setup works as expected. What we shall do now is to get one step further and configure two…

Read More »

Read replicas and Spring Data Part 2: Configuring the base project

In our previous post we set up multiple PostgreSQL instances with the same data.Our next step would be to configure…

Read More »

Running PostgreSQL in a Cloud on Oracle Containers Engine for Kubernetes

In this post I am going to show a few steps to deploy and run PostgreSQL database in a K8S…

Read More »

Reactive Programming and Relational Databases

Imperative code eats threads at the pace of incoming requests while Software is eating the world. This post discusses the assumptions…

Read More »

How to map PostgreSQL Enums to JPA entity properties using Hibernate

Introduction The open-source hibernate-types project allows you to map JSON, ARRAY, YearMonth, Month or database-specific columns (e.g. INET addresses). In…

Read More »

PostgreSQL on Open Liberty

Open Liberty is an interesting new OSS Java EE application server that originated from WebSphere Liberty. You can configure Open…

Read More »

Tuning PostgreSQL with pgbench

When it comes to performance tuning an environment, often the first place to start is with the database. The reason…

Read More »

More on Spooling Queries and Results in psql

In the recent blog post SPOOLing Queries with Results in psql, I looked briefly at some PostgreSQL database psql meta-commands…

Read More »

AutoCommit in PostgreSQL’s psql

One potential surprise for someone familiar with Oracle database‘s SQL*Plus when being introduced to PostgreSQL database‘s psql may be psql‘s…

Read More »