revOpenDatabase over SSH tunnel?

[Bob Sneidar]

Yes, the server agent part resides on the same device that the SQL Server is on. The server agent communicates directly with the SQL server, and is responsible for making and storing connection specifics. The client agent can request a list of connections from the server agent when it connects to it. All that passes between the client and server are these requests for connections, the sql statements the server needs to execute, and the data the server retrieves. All back and forth are encrypted. It's really quite elegant if I do say so myself. :-)

It really is just the framework for any client server solution. It can be used for a document storage and retrieval system too, or anything you want to communicate between two devices securely. 

Bob S


> On Mar 10, 2022, at 08:42 , matthias rebbe via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> There is nothing wrong with your method. But there might be situations where you need direct access to the MySQL database, e.g. you are using 3rd party software (in my case SQLPro Studio) or libraries. I have a customer who is using a special Delphi library that only supports direct connections.