Newbie - Is the Timescale Managed Service Suitable

Timescale Hosted Services
1

I have an interest in storing time series data generated by IIoT-type devices. I am expecting these devices to either generate MQTT packages directly or via some form of OPC UA/MQTT gateway. The issue I am having is understanding the required architecture to ingest the MQTT payloads into TimeScaleDB.

As an example:

  1. EMQX provide a MQTT Broker and Rule Engine that can then forward ‘messages’ to PostgreSQL. Under these circumstances, I would appear to need two separate cloud instances (EMQX Enterprise and TimescaleDB) which doesn’t appear to be overly elegant
  2. An alternative approach would be to use a third-party MQTT broker and write my own MQTT client/ingestion routine around it. As far as I am aware I couldn’t run this within the TimescaleDB instance, please correct me if I am wrong, so again I need to have two instances.

Is my understanding correct? Is there a more elegant way of ingesting MQTT data? Any guidance would be much appreciated.

2

Hey Chris! that’s a great question and your understanding is correct.

I think you’ll need to maintain both machines. You can also wrap then on a docker-compose or something to simplify the way you manage it but still not available.