I'm a kdb+/q[1] developer. It's a proprietary timeseries database used in finance/trading, but also for IoT/sensor data. But for your usecase I think Timescale

I'm a kdb+/q[1] developer. It's a proprietary timeseries database used in finance/trading, but also for IoT/sensor data. But for your usecase I think TimescaleDB will be the best fit. It's an opensource extension for PostgreSQL, so you can use any PL/framework which can work with Postgres. And you have all the felxibility of RDBMS and can use standard SQL queries. [1] https://en.wikipedia.org/wiki/Kdb%2B https://en.wikipedia.org/wiki/Kdb%2B https://code.kx.com/q/ https://code.kx.com/q/ [2] https://www.timescale.com/ https://www.timescale.com/