High-Performance Java Persistence Newsletter, Issue 17

Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. 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

The pick of this edition is this article, which talks about a hypothetical new database system that’s, as the author puts it, “embedded, immutable, syncable, and relational”, serving the purpose of building decentralized client-side applications that share data.

If you are using the MySQL JSON column type and need to encrypt some specific JSON attribute values, then this article explains how easily you can achieve this goal using JPA and Hibernate.

If you’re using MySQL 8, then this Percona article explains how you can tune the InnoDB checkpoint process using the innodb_io_capacity_max and innodb_doublewrite_pages configuration properties.

Another great article is this one written by Kuba Łopuszański about locking in InnoDB. This is the first part of the series, so I’m looking forward to reading the second part as well.

If you’ve been using MySQL and now need to use PostgreSQL in a different project, then you should read this article which points out some differences between these two very popular relational database systems.

The Hibernate hbm2ddl.auto tool allows you to generate the database schema from the JPA and Hibernate entity mappings. While you’d normally use a tool like Flyway to manage the schema migrations, it doesn’t mean that the hbm2ddl.auto tool is not useful. For more details about this topic, check out this article I wrote on my blog.

Java Version Pooling Results

This week, I ran a Java version survey on Twitter, and over 4400 participants managed to cast their votes:

So, here are the conclusions:

  • It looks like Java 6 and 7 are seldom used.
  • Java 8 is still hugely popular.
  • Java 11 is slowly getting traction.
  • The Java 12 to 15 versions are used only marginally.

Next Online Workshops

I’m going to run three new online workshops in the upcoming two months.

The first one will be run on the 30th of September and is about Caching Best Practices and covers database caching, application-level cache systems, data synchronization, CDC (Change Data Capture), and the Hibernate second-level cache mechanism. If you’re interested in these topics, then you should definitely join in.

The next one is a 4-hour High-Performance SQL online workshop that will run on the 6th of October via Voxxed Days Ticino.

The last one is a 12-hour High-Performance SQL online workshop that is organized by Bouvet Norway and starts running on the 28th of October.

Best Tweets

There are many social media platforms, but for me, Twitter is the one I like best. Here are the best tweets I posted since the last newsletter:

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.

Hypersistence Optimizer 2.2 has been released!