I'm about to do this project where I will make some lights flash up depending on some values that are in an SQL database on a server. I have already bought my Arduino and waiting for it to arrive. But I've been stuck at how to read the SQL data from the Arduino, connected to ethernet only.
Is there a library where I can select from the database directly or do I have to make a web service, in which I can make a http request to when needed?
If it's a web service, can I be directed to some examples of this being used with Arduino? I've been looking around the past few days but haven't been able to find a decent example.
Best regards and thanks a lot in advance for your time! :-)