ESP32 WROOM Thing Plus C and MQTT

Greetings,

Using: https://www.sparkfun.com/products/20168

Application: sensor monitor to MySQL database, same network.

I’ve given up on using Chuck Bell’s MySQL client on this device, no matter what I try the code hangs up. The MariaDB version won’t install on Windows, but is ok on Linux. No idea what’s going on there, suppose I could get it and unzip in the Arduino folder as a work around.

I’ve read on simple message queuing and somewhat familiar with this from the old IBM MQ days. I’ve enabled the service on my Linux box, will write a process to pull from the service and insert in to the DB after some device testing is complete.

Looking at the MQTT libraries, there are many. I’m hoping someone can recommend an async flavor that has tested ok on this device. With spending over 6 hours hacking and getting no where with MySQL, trying to save a little time with a tip from the community.

TIA,

Michael

Update, following https://randomnerdtutorials.com/esp32-m … duino-ide/

Got a MQTT test to work using… https://pubsubclient.knolleary.net/

Next is experimenting with Node-RED (workflow on top of node.js) and Mosquitto (a MQTT broker).