High-Performance Java Persistence Newsletter, Issue 14
Imagine having a tool that can automatically detect JPA and Hibernate performance issues. Wouldn’t that be just awesome?
Well, Hypersistence Optimizer is that tool! And it works with Spring Boot, Spring Framework, Jakarta EE, Java EE, Quarkus, or Play Framework.
So, enjoy spending your time on the things you love rather than fixing performance issues in your production system on a Saturday night!
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 PostgreSQL Tricks article. In this article, you are going to learn about some lesser-known features, like UNLOGGED tables, invisible indexes, transactional DDL, BRIN indexes, and more.
Another very good article is this one written by Gerald Venzl, which demonstrates that a RDBMS, like Oracle, can easily handle 1 billion records.
If you’re using MySQL, you might want to read this article, which explains how you should configure the underlying Linux OS in order to get the most out of your database engine.
If you are using Hibernate, then this article, written by Nicolas Fränkel, explains how the Hibernate Caching mechanisms (first-level cache, second-level cache, and Query cache) work.
I added two more articles in the JOIN section of my SQL tutorial:
If you want to implement a very simple audit logging solution, then you can use database triggers to feed the old and new row states in JSON columns. This article explains how you can achieve this goal using MySQL.
Project Releases
The 2.9.13 version of the Hibernate Types project has been released, and it now offers support for mapping Java boolean[] and List<Boolean> entity attributes to PostgreSQL boolean[] column types. Check out the release notes for more details.
The 5.4.19 version of the Hibernate ORM project was released, adding support for CockroachDB, as well as fixing some issues. For more details about this release, check out the release notes on JIRA.
Get in touch with my latest articles!
StackOverflow Answers
The following StackOverflow answers have been trending over the past two weeks:
- Hibernate performance tuning tips
- How to create Triggers to add the change events into Audit Log tables
- How does the JPA
@SequenceGeneratorannotation work - What is the difference between
CascadeType.REMOVEandorphanRemovalin JPA? - Why an Object annotated with @MappedSuperclass is not an @Entity in JPA?
- MySQL ON vs. USING?
- How to create audit trail or logging tables with triggers in MySQL
