High-Performance Java Persistence Newsletter, Issue 50

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, which explains the bad parts of PostgreSQL. While PostgreSQL is a great open-source database system, it also has some architectural issues that you must be aware of if you plan on using PostgreSQL.

If you’re using Spring, Then you should definitely read this article because it explains to you how read-write and read-only transactions can be sped up by delaying the connection acquisition as much as possible.

Another great read is this article, as it explains how database systems execute reads. Understanding database internals is of paramount importance when designing high-performance database applications.

As a backend developer, when dealing with large volumes of data, stored procedures can help you implement very efficient solutions. In this article, I show one of the best ways to call database stored procedures with Java.

SQL:2023 is ready and provides tons of enhancements. If you are curious about what the latest SQL version provides for you, then check out this article.

If you’re using PostgreSQL, enabling the automatic Explain Analyze feature can be extremely useful when dealing with queries that only run slowly from time to time. Check out this article for more details about how you can achieve this goal.

Best Tweets

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

Project Releases

The 2.7 version of the amazing Hypersistence Optimizer performance tool has been released. For more details about the extra optimizations, you will get by upgrading to this version, check out the release notes.

Hibernate ORM released two versions for the 6.2 branch:

MySQL released the 8.0.33 version, and it provides several bug fixes that you might be interested in if you are using MySQL 8.

The 8.0.33 version of the MySQL JDBC Driver has also been released, bringing you several bug fixes.

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. Required fields are marked *

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