Getting rows of data from a database and printing them using an arduino

Hello guys !!
I want to build a project where everytime there's a new entry on my worpress database, the arduino gets that data and prints it (on a piece of paper for example).
How can i make that happen ?
Will an esp 8266 do the job or will i need the esp32 ?

P.S. i also want to "control" a servo based on a specific column value from that new entry, if anyone can help me with that as well!
Thanks in advance!

My Raspberry Pi interfaces to my website's dB. My RPi running a MQTT Broker has a Python program running that takes the dB info as needed and sends it to the MQTT Broker where the 13 ESP32's receive data from the dB.

The 13 ESP32's send their stuff to the MQTT Broker, which has a Python program running on it that sends the data from the Broker to the dB.

I do it that way cause it simple and I only have one point of contact to my dB and not 13.

1 Like

The easiest way is to use firebase, there are libraries already done in esp32/8266. So you can use a callback function when some data is added/changed and do the servo thing.

1 Like

That sounds good...i will look into that...thanks a lot!

1 Like

Instead of Python Node-RED can be used to do the interfacing.

1 Like

Thanks a lot...someone suggested that to me before...is it free or do they have some sort of plan ?

1 Like

thanks you've been really helpfull...can i link firebase to an existing database instead of creating a new one ?

it has a free plan that is usually enough, you have to check it. And i dont know if you can link it to a existing database, maybe you will need to create a new one. :frowning:

for the created dB just export the create dB sql and then import the create dB sql in firebase.

thanks for all your help you guys!!

1 Like

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.