High-Performance Java Persistence Newsletter, Issue 26

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

The pick of this edition is this article which shows how you can host an SQLite database on GitHub pages and use it to serve dynamic content to a static generated website.

Knowing how a Clustered Index works is very important when you are using MySQL or SQL Server. For this reason, I wrote this article to help you get a good understanding of this topic.

If you’re using PostgreSQL GIN indexes, then you should definitely read this article, which explains how the gin_pending_list_limit setting works for fastupdate.

Talking of PostgreSQL indexes, you should also read this Percona article about BRIN indexes that can help you speed up queries with a very compact index structure.

If your Java application uses SQL Server, then you should always disable the sendStringParametersAsUnicode. For more details about this topic, check out this article.

If you’re using MySQL and want to speed up JSON queries, then you should add a JSON path expression index. For more info about how you can do that, check out this article.

Best Tweets

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

Project Releases

The Hibernate ORM project released the 5.4.31 version.

And, to support the JPA 3.0 spec, which changes the namespaces from javax to jakarta, the Hibernate 5.5 branch has been created, and the 5.5.0.Alpha1 initial version has been released.

If you’re using MySQL, then you might be interested in the 8.0.24 release, which provides several bug fixes and optimizations.

Get in touch with my latest articles!

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.