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.

Black Friday 50% off the High-Performance Java, Spring, and SQL course bundle: 24 hours of video lessons Get the Bundle

Black Friday

Seize the deal! 50% off my video courses

Java Persistence Video Course Save 50% Buy Now SQL Video Course Save 50% Buy Now Spring Persistence Video Course Save 50% Buy Now

The BLACKFRIDAY26 coupon is applied automatically at checkout.