From the original SynthMaker forum (2004–2014), with its members’ names and dates.
jobro ·
Scenario 1:
So you've spended a good portion of the last months updating your plugin with a ton of new features. Now it is the time to spread the word to your plugin users. The user Adam Folds (fictive person) starts up his latest track in whatever sequencer he uses. Once the plugin boots up it performs a check online with your mysql database to see what version is available. He sees that a new version is available, and starts to download it.
Scenario 2:
You've done a new plugin, and you want to spread the news. In your mysql database you have a table PlugNews. Once our fictive user boots up your plugin he recieves the latest news from your table. He reads about the new plugin, clicks the button to read more about it, and decides to download it to give it a spin.
You see where I want to reach? Public relations with your customers. Nothing beats the feeling of having your customer's attention, and SM has all what it needs to get that job done, except for having mysql access and a file download primitives. If this was available it would really become the bliss for plugin developers (like me) who wants to give the users of my plugins the latest versions instantly available for their use.
MyCo ·
Do you have a MySQL Server with an open port outside? I work as webdeveloper and I've never seen such a server configuration. The MySQL ports are in 99% of all setups bound to the localhost or bound to the intranet. So there is no chance that you can access them through the web. Actually only an owner of a Server or VServer could setup such a configuration, and whoever does this doesn't care about his data or his web service.
mwvdlee ·
MyCo wrote: Do you have a MySQL Server with an open port outside? I work as webdeveloper and I've never seen such a server configuration. The MySQL ports are in 99% of all setups bound to the localhost or bound to the intranet. So there is no chance that you can access them through the web. Actually only an owner of a Server or VServer could setup such a configuration, and whoever does this doesn't care about his data or his web service.
Many shared hosting services that I've come across tend to have MySQL ports to the outside world by default. My own host has it optionally when creating a database.
Regardless, giving outside application direct access to the database is just the wrong way of doing this for so many, many reasons.
Instead, set up some .PHP (or whatever your favourite flavour of server-side scripting language might be) that does the database querying and formats the data in some easily parsable format for the plug-in. With FlowStone's internet client module this would be easy to retrieve directly into the plug-in, with S|M your best bet is to use ShellExecute and something like cURL to get the data from your server. Given the current asynchronous state of ShellExecute you'll probably need to wrap something around cURL so S|M can retrieve a "finished" signal or write your own functionally similar code.
There are other ways of creating similar functionality, for instance you could create a .exe that opens a nicely formatted web-page in a system-modal window instead of presenting the data as unformatted text inside S|M.
Wrote something here? To have a post removed or your name hidden, write to [email protected].