Nitrite Database VS hypersistence-utils

Nitrite embedded DB for java objects

I see tinydb is a document store, though. If that's a requirement, I'd recommend nitrite: https://github.com/nitrite/nitrite-java

Unfortunately, you cannot smoothly wrap the sequence-based IDs with value objects. There are solutions, but they are rather cumbersome. I left the proposal to the Hibernate types project of adding support to this feature. You’ve already seen the benefits of user-defined types. So, you can rate up my issue to make it more popular.

The Hibernate Types project.

Spring Data / Hibernate does not support JSON fields out-of-the-box, but there is a library that provides custom types for the most common database systems: hibernate-types. This is a fantastic open source library, please support it!

I will blog about it in the following months. So far, I managed to add a new Hibernate Types module for Hibernate 6 and released the 2.15 version.

For current work, hibernate-types works great to support json/jsonb.

Complex DB structures are not a problem. You can map any database type you want: JSON, HStore, Ranges, Inet, as I did in this hypernate-types project.

I am using the Hibernate Types library for custom Hibernate types.