Jmix support for TimeScale DB

Support
#1

Hi All,

In a project which requires the insertion of about 15 million tuples per day in a telemetry table (the data produced by about 7000 IIoT devices) with a retention of at least 30 days (probably in the future there will be a request to extend it to 6 /12 months), we were considering Timescale DB as a “transparent” replacement for PostgreSQL. Is Timescale supported by Jmix or could we run into incompatibilities?

#2

Hi Davide,

Since Timescale DB is an extension of PostgreSQL, I suppose it can be used also as a standard PostgreSQL through its JDBC driver. Did you try it?

#3

Yes it seems to work, to be honest I was hoping that someone had tested it to confirm and avoid finding problems in the future :slight_smile: