PostgreSQL
-
Enterprise Java
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 » -
DevOps
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 » -
Software Development
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 » -
Enterprise Java
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 » -
Enterprise Java
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 » -
Software Development
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 » -
Software Development
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 » -
Software Development
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 » -
Software Development
Does PostgreSQL Have an ORA-01795-like Limit?
The Oracle database requires that no more than 1000 entries be used in a SQL IN portion of a WHERE…
Read More »