High-Performance Java Persistence Newsletter, Issue 8

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 written by Jaana Dogan. The article explains multiple hard-to-grasp topics in a very clear and concise manner, which is very easy to follow, no matter how much experience you have on this topic. Therefore, I strongly recommend you read Jaana’s article.

Another very interesting discussion is this Quora answer, which explains how Quora managed to implement Sharding for its MySQL databases.

Java 14 introduced support for Records, which are a special type of Java class that is suitable for encapsulating data. If you want to understand what Java Records are and how they differ from POJOs or Java Beans, then you should start with this article.

While Java Records are not suitable for defining JPA entities, they are a very good choice for DTO projections. This article explains why Java Records are very suitable for wrapping query projections and shows you how you can nest multiple Java Records using the Hibernate ResultTransformer.

The default configuration values offered my many relational database systems are suitable for desktops or notebooks. If you want to install PostgreSQL or MySQL for a production system, you have to adjust various database settings to take advantage of the underlying server capabilities. For instance, when using PostgreSQL, you might want to adjust the shared_buffers, wal_buffers, effective_cache_size, and maintenance_work_mem configuration properties. If you want to learn what is the purpose of the aforementioned PostgreSQL settings, then this article is a good starting point.

If you’re using MySQL in the cloud and want to scale it to accommodate more traffic from the application, this article from Percona gives you a lot of suggestions for what you can do to achieve this goal.

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.