mqtt-client

It would be nice to be able to augment cache hit ratio metrics with how many requests were marked as uncacheable, which could be done by adding the MAIN.beresp_uncacheable metric to the metrics already being pulled from Varnish.

Current behavior:
All the SQL activities either don't support Insert or are specific to a usecase

Expected behavior:
to be able to insert to a sql database in an activity

What is the motivation / use case for changing the behavior?
many workflows/pipelines require logging to a database

Additional information you deem important (e.g. I need this tomorrow):

Some more stats for perfromace would be nice:

• Messages last minute
• Messages last hour
• Messages last 24h
• Shortest time between messages
• Min/max/average message payload size

Problem or use case

The client is currently only logging errors and warnings. For debugging purposes and during application development, it would be very useful to also have logs detailing the message flow.

Preferred solution or suggestions

TRACE level logging for incoming and outgoing MQTT control packet types, e.g., PUBLISH, SUBSCRIBE, PUBACK, SUBACK.

Device normal info

• Smart Wireless Switch M2

Device info:

{
"active_time": 1624995021,
"biz_type": 18,
"category": "wxkg",
"create_time": 1624995021,
"icon": "smart/icon/ay1536047723331OpdLN/166bec229d0c60605b4d068e0d9b7e50.png",
"id": "eb7669e6fb880cb4c******",
"ip": "",
"lat": "",
"local_key": "***",
"lon