The best way to use the JPA OneToOne optional attribute

Introduction In this article, we are going to see what is the best way we can use OneToOne optional attribute so that we can avoid N+1 query issues.

How to calculate percentiles with SQL PERCENTILE_CONT

Introduction In this article, we are going to investigate how to calculate percentiles with the SQL PERCENTILE_CONT function.

PostgreSQL FOR UPDATE vs FOR NO KEY UPDATE

Introduction In this article, we are going to investigate the difference between the PostgreSQL FOR UPDATE and FOR NO KEY UPDATE when locking a parent record and inserting a child row.

High-Performance Java Persistence Newsletter, Issue 61

Introduction Welcome to a new issue of the High-Performance Java Persistence Newsletter in which we share articles, videos, workshops, and StackOverflow answers that are very relevant to any developer who interacts with a database system using Java.