>Hi Viv,
>
>yes, the hosted option does include all costs. The big problem I have with the hosted version is the amount of data space made available (250MB).
Ouch! If I read the pricing correctly for Lianja Cloud server (which includes Lianja SQL server) the annual sub is $3K ?
Can't find anything that shows the hardware spec in any more detail.
With Azure, as an example, for about the same money you could get a 2core VM, a 4gb SQL Instance and 200gb of local storage....
>OTOH, ISV's have distribution rights to Lianja SQL Server and Lianja Cloud Server, no royalties, for any code the ISV owns. Presumably the ISV would have their own experts for cloud installs.
>
>Hank
>
>>>>>Hi All,
>>>>>
>>>>>We are running a software company and have a complex database app in the medical field. Since VFP has been discontinued we are searching for another development tool that can move us to the next level. By that I mean:
>>>>>
>>>>>- A more modern user interface
>>>>>- Running cross platform or at least some tablets natively
>>>>>- A solution to upgrade our application to run in a browser.
>>>>>
>>>>>This of course without having to rewrite all our code or entirely redesigning (we are using a lot of VFP scripts stored in the database, out there on many clients) the application.
>>>>>
>>>>>We have found that at least from a functionality POV Lianja seems to fit us best. Granted, it has not been released yet, but so far the comments I've read are positive. The company behind it seems to be a solid company (as opposed to the ones we have seen in the past) and their functionality is certainly looking impressive.
>>>>>
>>>>>Since it is supporting VFP compatibility to a high degree, it seems very interesting as much code could be ported over without much problems (I'd assume) and we do not have to entirely retrain all programmers into a new programming language. The support for other language like Python, PHP and Javascript as a real bonus I think.
>>>>>
>>>>>If this works, we are willing to invest in this product. the pricing seems reasonable to me.
>>>>>
>>>>>My question is what your opinion is about Lianja. Are there any caveats we should know about. Are there any valid reasons not to go this way ?
>>>>
>>>>I'd not looked at Lianja before but spent half an hour on the web site.
>>>>I got the impression that it was (a) very 'wizardy' and (b) not particularly extensible.
>>>>
>>>>What happens if you want to handle File IO, Webrequests, Email, etc etc - couldn't find anything in the documentation addressing such issues.
>>>>I understand that if you are looking for cross-platform support then the 'lowest common denominator' approach is a given but (unless I missed something) I'd find the whole concept incredibly limiting.....
>>>
>>>There is much more than I've listed below, but this will give you an idea of what is available in the 3 areas you mentioned. If you want more functionality, the entire PHP functions library is available to be called through VFPish; and likewise all the standard Python libraries. If you want additional Python Libraries, you would need to load them in Python, but at that point they are usable directly from VFPish.
>>>
>>>FileIO: In most commands, using a filename will read the filename and pass the stream to the command. For example:
>>>
>>>
>>>use mytable
>>>copy to myfilename.txt
>>>
>>>
>>>and
>>>
>>>
>>>select * from mytable into myfilename.txt
>>>
>>>
>>>The SQL SELECT command will select into XML or JSON by simply adding the appropriate keyword onto the command and the name of the file. Exporting into HTML is also supported.
>>>
>>>Email: the SENDMAIL() function is described here:
http://www.recitalsoftware.com/components/com_joomlawiki/index.php/SENDMAIL%28%29 The other mail functions are linked there.
>>>
>>>Webrequests: It's quite easy: from the Beta10 Roadmap entry:
>>>
>>>
>>>
>>>// send a soap request
>>>response = posturl("http://www.myserver.com/somewebservice.aspx", ;
>>> 30, ;
>>> array("type" => "Content-Type: text/xml"), ;
>>> "somefilename.xml")
>>>
>>>if len(response) = 0
>>> // no data was returned
>>>endif
>>>
>>>// submit a form
>>>response = posturl("http://www.myserver.com/someformsubmission.rsp", ;
>>> 30, ;
>>> array("type" => "Content-Type: application/x-www-form-urlencoded"), ;
>>> "name=barry&product=lianja")
>>>if len(response) = 0
>>> // no data was returned
>>>endif
>>>
>>>>>>
>>>JSON and XML have functions that turned file or memory into objects (in effect, Python dictionaries, but accessible as such from Lianja). Also, GETURL() is available. POSTURL() sends an HTTP Post, of course. If you specify a filename, the filename text is sent. If you specify text, the text is sent.
>>>
>>>hth,
>>
>>Thx. I read a bit more this morning - but purely out of curiosity since it's not relevant to my current (or likely future) projects.
>>Also out of curiosity : do you know if the cloud hosting options include the charges for the provider (Amazon, Azure etc) ?
