As discussed before I want to ONLY access the data.sorry that is to broad a specification access the data from where? how? ARe you talking about seeing the data in a browser aka a dynamic web site? or you have a client application that your customers use on theyr computers that handles the view and you need to pass them the data for viewing?
All input and output is done locally on a laptop and is NOT through any website.irrelevant. where the input is done only how the data are viewed. In any case my previous advice still stand for both application that handles the view and dynamic web site.
I just use the space (see attachment) These are my tables and views
Are you trying to create a desktop application which can access your cloud-based database?YES..
What's your end goal? Why are you creating this application/What problem are you trying to solve?
Are you trying to create a desktop application which can access your cloud-based database?YES..What's your end goal? Why are you creating this application/What problem are you trying to solve?
My end goal is to be able to make it for multiple user (max 5).
This is still Abracadabra for me.It can't get any easier, after all you're combining multiple concepts together: database access, JSON, client-server through HTTP. Don't expect there will ever be a one liner for all of them, even if it's probably possible.
Isn't their an easier way?
Why do you ever need a JSON (3-tiered application I guess)?The problem relies on the cloud database.
You said your requirements is simple 5 users application.
In your place (being novice), I would go for a good old simple direct SQL connection.
In case of security concerns (you think one provided by the SQL engine is not enough), use firewalls, ssh tunnels or other admin measures.
The problem relies on the cloud database.
This is still Abracadabra for me.Sure just make a post on the job section of the forums and pay some one else to do the work for you.
Isn't their an easier way?
Can you elaborate?The problem relies on the cloud database.
What's problem? Isn't TCP connection available? Even cheapest hosting providers allows that.
Can you elaborate?What exactly?
This is still Abracadabra for me.
Isn't their an easier way?
That TCP-connectionCan you elaborate?What exactly?
That TCP-connection