High-Performance Java Persistence Newsletter, Issue 37

Last modified:

Imagine having a tool that can automatically detect JPA and Hibernate performance issues. Wouldn’t that be just awesome?

Well, Hypersistence Optimizer is that tool! And it works with Spring Boot, Spring Framework, Jakarta EE, Java EE, Quarkus, or Play Framework.

So, enjoy spending your time on the things you love rather than fixing performance issues in your production system on a Saturday night!

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.

Articles

The pick of this edition is this article about the PostgreSQL 14 enable_memoize optimization that can help you speed up LATERAL join queries.

A very interesting tool I had the chance to investigate lately is Lightrun, which helps you inject logs and metrics or collect snapshots from production. If you’re interested in seeing how it works, check out the following two articles:

A very good article I read is this one about the uselessness of SELECT 1 queries executed by old connection pools still in use today because of legacy configurations no one took care to update.

Formatting SQL is a very common requirement because, most often, SQL statements are logged as a single-line string. If you are curious about how I’m formatting SQL queries directly from the command line, then check out this article.

If you’re using PostgreSQL, you might want to check out this article, which explains how to set up your PostgreSQL machines to get the most out of your database.

I managed to build a very nice tool that can help you assert if JPA associations are fetched using secondary queries or via JOINs. If you’re interested in validating your JPA data access layer, then check out this article.

Best Tweets

Here are the best tweets I posted since the last newsletter:

✅ You’re solely responsible for your career journey.

❌ Not the company you're working for.
❌ Not your manager you're reporting to.
❌ Not the team you’re working with.

The sooner you realize this, the better.
— Vlad Mihalcea (@vlad_mihalcea) March 13, 2022

Hibernate 6 has arrived!

Congrats to the development team and looking forward to writing about it.https://t.co/1zyqe3KILi pic.twitter.com/Bc0CzTFarQ
— Vlad Mihalcea (@vlad_mihalcea) April 3, 2022

For a software architecture, less is more.
— Vlad Mihalcea (@vlad_mihalcea) March 10, 2022

My Dell XPS is 5 years old today. I plan on keeping it for at least 2 or 3 more years.

Buying less electronics helps us reduce our ecological footprint. pic.twitter.com/FQhj1eNYjv
— Vlad Mihalcea (@vlad_mihalcea) March 17, 2022

A beginner’s guide to CDC (Change Data Capture)https://t.co/dFR5UbuOX4 pic.twitter.com/WAl2voSOqr
— Vlad Mihalcea (@vlad_mihalcea) April 4, 2022

Project Releases

After years of development, I’m very excited to announce to you that Hibernate 6 has been released. I remember discussing it in Paris in December 2017 when I got the chance to meet the Hibernate development team. Hibernate 6 provides many improvements like the new SQM parser, positional-based parameter binding, a much better JPQL parser that allows Window Functions, a new entity attribute type system, and many more features.

I also released the 2.16.1 version of the Hibernate Types project, and I’m studying how I could add support for Hibernate 6.