High-Performance Java Persistence Newsletter, Issue 37

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, 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:

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.

Get in touch with my latest articles!

StackOverflow Answers

The following StackOverflow answers have been trending since the last newsletter episode:

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.