High-Performance Java Persistence Newsletter, Issue 18

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 published by GitLab about what it took to upgrade their underlying PostgreSQL database from 9.6 to 11, considering that they have a 12-node cluster that contains 6TB of data, processing 300k transactions per second from 6 million users.

The new 2.2 version of Hypersistence Optimizer provides even more SLA (Service Level Agreement) checks, like the EntityManager duration, the flush execution time, or the query result size. For instance, if you want to speed up your Spring Boot application, then you can use Hypersistence Optimizer to automatically validate the performance guarantees. For more details, check out this step-by-step guide.

PostgreSQL 13 is under active development, and it already provides a lot of improvements. If you are curious about what’s coming in PostgreSQL 13, then you should read this article.

JPA and Hibernate are very popular choices when it comes to implementing a Java data access layer. However, there are many other alternatives, like MyBatis, QueryDSL, jOOQ, or Spring JDBC. If you want to know whether you should use JPA and HIbenrate, then this article is going to help you make the right decision.

Videos

Peter Zaitsev, the CEO of Percona, talks about how you can optimize MySQL using the [PMM 2](Percona Monitoring and Management) tool.

Relational Database Polling Results

Last week, I ran a database vendor survey on Twitter, and over 5000 participants managed to cast their votes:

The results are relevant for my audience, which consists of Java developers mostly:

  • Almost 40% of Java projects use PostgreSQL
  • MySQL and Oracle are used by 24% of responders
  • SQL Server is used by over 11% of projects

From the tweet comments, I noticed that Db2 was mentioned most often, especially since it wasn’t included in the poll due to the four-option limit imposed by Twitter.

Next Online Workshops

I’m going to run 3 sessions of 4-hour High-Performance SQL online workshops, organized by Bouvet Norway and starting on the 28th of October.

So, if you are interested in learning more about SQL and database systems, then you should definitely join this training.

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:

Project Releases

I have the pleasure to announce that the 2.2 version of Hypersistence Optimizer has bee released. This version brings more runtime checks, like the Persistence Context flush duration and the query result size. For more details about all the improvements offered by this new version, check out the release notes.

I also released the 2.2.3 version of Flexy Pool. If you want to know what’s the right size for your database connection pools, then you should definitely use this open-source project.

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:

2 Comments on “High-Performance Java Persistence Newsletter, Issue 18

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.