First let me preface this by saying I am fairly ignorant about networking stuff and web technologies…
My company does not have a server (file or web) that I can use. Some years back I wrote a Xojo desktop app for in-house use at work that runs both on Mac and Windows and uses SQLite.
The users never write to the DB, but it does need to get updated periodically with new information. The way I handled that (with help from people here) is by storing the encrypted database (and a short text filed with last update date) in a DropBox public folder. The admin (me) uploads the new file to Dropbox when changes need to be made.
The app silently checks weekly to see if the DB has been updated, and if it has it automatically downloads the updated DB. (there is also an update now option that just downloads the file on demand).
The nature of that app is such that multiple people within a department are likely to use the same copy so it does not use, store or ask for passwords. The encrypted DB ensures no one who does not have a copy of the app can read the DB and that is all the security required in this case. (no needs to keep anything i private within the company)
This has worked well for years and has been very convenient for the uses. The new versions of the DB file use the same URL to download, so nothing special besides uploading the modified DB has to be done for updates, so it’s very simple.
Unfortunately DropBox is discontinuing Public folders and with that direct download links, and it’s not realistic to install the Dropbox app on all the machines my app is running on, so I need a replacement… and likely some help with how to do it… Any solution needs to be free as this is something I did on my own.
Does anyone know what my options might be? if worst comes to worst I can Email DB updates to all users and tell people where to put the file, but that just about guarantees that all the users won’t be on the same version of the DB, so I want to avoid that if at all possible.
As my company uses Gmail, I guess Google drive might be a possibility… Does anyone know if it can be made to work as described above in our environment, and if so point me in the right direction…
If there is another good alternative, whatever the service, some example code would be greatly appreciated!!!