ESP8266 GET data from SLQ database

[qwertis]

Hello,

I would like to read data from a SQL database (strings) however I could not find a good example on the internet.

The project is a led matrix ticker where people can go to a website where they can update the displayed text. The website contains of a php script that puts data in a sql database.

Now I would like to let my wemos D1 (ES8266) (or Particle Photon ) to GET this data.

On the internet I only found these two "tutorials" but they do not work for me. It seems that both are for local use (?). There exists a lot of tutorials for writing so i'm doubting if it is even possible.
http://ice786pk.com/?p=662 
http://afterhoursengineering.net/blog/blog/2015/04/11/esp8266-read-and-write-data-to-a-database/

I'm not that experienced with coding hardware. So If you could point me to a step by step guide that would be awesome! 

Thank you in advance,
Mark

[obiwanjacobi]

I would consider putting a simple (REST) interface in front of it in order to simplify the code you need to write on the ESP...
It could be as simple as a GET on an url that delivers you the data (ranges on the query string?).

[kripton2035]

here is an arduino example for postgresql. did not try it for now, but I'm planning to !
https://github.com/ethanak/SimplePgSQL

[qwertis]

Could you give an example or point to a tutorial?
Thank you! 

[qwertis]

Sadly I could not get it working, but thanks for your input.
Please tell if you get it to work!

[mskeete]

Sadly I could not get it working, but thanks for your input.
Please tell if you get it to work!

How far did you get?
Did you write a second web page to return data in a simple format based on a query string?

Error messages and or code that tried that isn't working?