hypersistence-utils VS fastexcel

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.

I'm using fastexcel to create the excel file, and I'm flushing it to the OutputStream after every row is written. Right now, I am using a FileOutputStream to write to disk. When the excel file is done being generated, I read it back in using InputStreamResource and stream the response. My thought process is that a ByteArrayOutputStream keeps everything in memory even if I'm flushing the excel file after every row, so I used the FileOutputStream. Does my logic track here? Or am I unnecessarily slowing things down with expensive filesystem IO?

fastexcel the fastest xlsx generation library

I would use some library like for example this one. So you collect all the data you want to store in a list or map, and iterate over it, then add them to the excel like shown in the documentation of the library (should always be the same way more or less for any library)

I've only had memory problems with apache poi. I only use https://github.com/dhatim/fastexcel now