Tho very rare, why would you use a database that is at risk to be erased completely, and with a limited set of queries as the main DB? Honest question.
I think a time series database is best suited for this kind of project (timescale build on top of postgres, influxdb, ...)