Database in the Cloud

[Scott24x7]

So, I've been thinking...
I would like to have my VFP tables and files (associated with it) in an internet accessible "space".
The idea is, the DBC and all tables would live in a directory on the cloud somewhere...
Then my "Client" application is on the PC, and just need to <map the cloud as a drive>. I am not interested in "Web-facing" the application, keeping it client-server is fine, but has anyone done this? Is there a specific service that caters to this? (AWS, Azure, Bob's Swampland Fox DBFS). I also don't want to have to use a VPN to get to it...

In "the past" I would just have the tables on a server somewhere on the network, with a mappable drive letter... we install the client, establish the "drive" link to the PC and then Bob's your uncle.
But I've done nothing with this in more "modern" days, beyond accessing cloud data by FTP, and that's not what I'm after.


Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."

 

[Mike Gagnon]

I have installed a RemoteApp type setup recently. it is not that difficult and it works well here (Canada), but there a cost involved. You need to buy licences for all users. We use Active Directory to authenticate the users.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Scott24x7]

License costs are ok, so long as reasonable for what we get out of it (maybe $100 - $200 a user, less is better of course).
At the conceptual level, what was involved?

I'm going to be attending the FoxIn Cloud sessions after SW Fox in a few weeks, but I have a feeling that solution will be ok for what we want to expose to a web front-end, but not really be part of our core client-side application. I really don't know much about FiC but figured since I was making the trek, I'd drop the extra $750 to find out more about it.


Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."

 

[Mike Gagnon]

For RemoteApp we did this.
1. Rented a server in a SaaS provider.
2. Had them install MS SQL server.
That is it for that part.
The rest we did.
1. Installed Foxpro.
2. Installed our Application.
3. Configured Active directory.
4. Published the application
5. Sent the clients RemoteApps Icons for eache user.

And that was it, 2 days work.

As for FoxInCloud, it takes your existing application and your pass it through their application to point out corrections you need to make to make it work on The Internet. Once that is done you end up with both a desktop version and an HTML/CSS version of your application. And any time you make a change to your FoxPro code, you re-pass through their application to push the changes to the HTML/CSS version.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.