I was seeing the changelog for the CasparCG official client and appears the possibility of connecting to a mysql database. Anyone know what can we do in the client with mysql? For instance can we send any mysql table to a template?
That would request a VERY advanced template to be able to handle ANY table. This would not make sense at all. I guess that mysql is just to store the playlist instead of the currently used XML file.
I use Excel for that. I am currently programming a plugin, that I will open source as soon as it is a bit cleaned up (currently it’s messy code). Yo can query any databases with the PowerQuery function and add a few formulas to foramt the stuff the way, the template needs it and send it to Caspar. Last weekend I did a drone race with it, where the data was coming from a json feed. Worked quite well.