...

Using this combination ensures better global language support and consistent case-insensitive behavior in text comparisons.

HSQL (file-based) database considerations

Please note we do not recommend using the HSQL (file-based) database for deploys over 100 devices, and do not support HSQL deploys with 1000+ devices.

Since HSQL is a file based database, that keeps all data in a few flat text-based files, as the DB size grows, performance is severely impacted. If you want to use HSQL long-term, you should:

• setup data retention policies for both History Jobs and Backups
• monitor database directory size (it should no reach multi-gigabyte sizes)
• monitor disk usage of the disk where HSQL stores its data

HSQL databases can get corrupted if the disk on which data is stored runs out of space.

PostgreSQL details

Until Unimus 2.6, only PostgreSQL 11 or older were supported. Starting with Unimus 2.6, we now support all newer version of Postgre.

...