[Sqlrelay-discussion] Update two databases simultaneously / Client protocol

[Hagen M. <h.m...@WD...>]

David,

 

the requirement to send the same update query to multiple databases was only a soft requirement. And I agree, that this rather should be a job for a database replication or a synchronization task.

 

I could compile the SQL Relay and got it run after clearing a few hurdles:

-     In config.mk remove -Wno-long-double in CXXFLAGS (obviously my g++ doesn't know it; hope it is not essential) 

-     Add the prefix value (in my case /opt/firstworks) in configure where it tests the rudiments includes and libs

-     Add /opt/firstworks/bin to the PATH variable, otherwise sqlr-start does not start correctly

-     Add the /opt/firstworks/lib to library path

 

The SQL Relay connected to a Oracle data base and I sent some test queries with the command line query utility. All worked fine and the performance was impressive, so I think I can propose this solution.

 

As for the .Net client application, I guess the system owners prefer a web service solution. Hence there is no need for a .Net capable API just now. Nevertheless there are some applications that have to access different data bases and one attractive feature of SQLrelay is that only one interface is needed. If the system owners accept my proposal and if they have some experience with this solution I can imagine that soon there will be requirements that makes a .Net capable API necessary. In this case I'll ask you for an offer.

 

So long,

Hagen