High-Performance Java Persistence Newsletter, Issue 22

Imagine having a tool that can automatically detect JPA and Hibernate performance issues. Hypersistence Optimizer is that tool!

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

From version 2.12, Percona PMM uses Victoria Metrics instead of Prometheus. Victoria Metrics provides better disk I/0 utilization and less memory usage. For more details about this change and its benefits, check out this article.

By default, the MySQL JDBC Driver only emulates prepared statements. If you wonder whether server-side prepared statements perform better than client-side ones, then this article explains how to configure the useServerPrepStmts and cachePrepStmts settings.

If you’re wondering how to configure PostgreSQL, then there’s this postgresqlco.nf online service that can help you to achieve this goal.

One lesser-known SQL feature is LATERAL JOIN that allows you to encapsulate a given computation in a subquery and reuse it in the outer query. For more details about LATERAL JOIN, check out this article.

If you’re using PostgreSQL, then this list of 60 tools will surely help you identify new applications you could use to get the most out of PostgreSQL.

While it’s a good idea to design the database schema according to the relational model, there are also situations when the relational model is way too strict, so a JSON column type becomes a very handy alternative. For more details about how you can query JSON columns with PostgreSQL, check out this article.

Best Tweets

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

Project Releases

Hibernate Reactive has been released, offering a Reactive API for the HIbernate ORM project. For more details about this project, check out this article.

The 2.10.1 version of the Hibernate Types project has been released and brings several enhancements that make it worth for you to upgrade. For more details about this release, check out this GitHub milestone.

Hibernate ORM released the 5.4.25 version that fixes several issues.

If you like this newsletter,

you are going to love the next episodes!

StackOverflow Answers

The following StackOverflow answers have been trending over the past two weeks:

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.