I’m looking at writing a self-hosted (web) service. This service will run under windows server 2008 without IIS running. The windows server is running MSSQL Server 2012. The service should take input from a remote machine with data to be massaged by an already extant stored procedure so the service should pass the incoming data through to the stored procedure after some verification etc. My thought is to have the remote machine send a JSON string that the service then verifies and configures before sending it off to the stored procedure.
It seems that I’ll need to be able to build to the web version of Xojo and then deploy… or do I? I don’t know enough about the deployment deliverables of the web version to answer my question. Is it a cgi that needs to be run under a web server? I want to be able to talk to the build deliverable without having the overhead of maintaining a web server as well (thus ‘self-hosted’). Is it possible to write/build a service that accepts something like a JSON string without using the web version i.e. using desktop framework or perhaps even just the console framework?
I know there are solutions for this process through visual studio. Having spent the last two days looking at the requirements and running through tutorials using the WCF (Windows Communication Framework) and the Holy Hell of configuration options that sorta work when you do things ‘just so’, I thought I would step back and take a look at this problem from a Xojo perspective and get some feedback from the most excellent Xojo forum.