search

mint-dewit / slogo-playout-server

GNU General Public License v3.0
2 stars 0 forks source link

MySQL schema #1

Open mickaelmonsieur opened 7 years ago

mickaelmonsieur commented 7 years ago

Hi Balte, I want to test slogo playout server. It's possible to have the MySQL schema ?

mint-dewit commented 7 years ago

Hi Mickael,

I do have the MySQL schema, but I do not necessarily recommend using this playout system. Development has basically stalled, and I'm now working on making the folderplayout project more flexible. Is there any specific reason you are interested in this project? I could perhaps prioritize some of the workload in your favour.

If you want to have the schema, shoot me an email: balte.dewit@gmail.com

mickaelmonsieur commented 7 years ago

Hi Balte, I started developing a "capsarCG scheduler", with Zend Framework, but I have trouble managing a permanent php process at about 100ms accuracy to send the AMCP actions to Caspar. PHP is probably not the best language to make a daemon. Without doubt Python more adapted ... I think you must have had this problem with slogo playout server. I send you an email anyway so that you give me the schema because I still spent 1h to run codeigniter, so my morning will not be lost :-) Best regards, Mickael

mint-dewit commented 7 years ago

I'm afraid that you're looking in the wrong direction then. This repository just provides a user interface to a database and an API. There's a javascript client (different repository) that maintains a persistent connection to a CasparCG installation!

Is there a specific reason you have to use PHP? A websocket connection with a middleware to AMCP would seem much more suitable for just the reason you mentioned: a persistent connection.

mickaelmonsieur commented 7 years ago

Ok I see. This is the code of http://text-tv.rtvslogo.nl/api/videos. I'm going to go to the slogo-playout-client side, but I have less experience in server-side javascript. Server and client are needed! :) Thank you for the schema.

mint-dewit commented 7 years ago

If you're looking for a way to send AMCP through nodejs, you should check out the library casparcg-connection. I use it in folderplayout as well, and it manages the connection (including connection loss etc.), uses promises, and has a high level interface.

Also, if you're not comfortable using javascript server side, you could set up just a socket.io server and proxy the socket.io events to an AMCP connection.