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

[David M. <dav...@fi...>]

Cool, sounds good.  Let me know how it goes.

Dave
dav...@fi...

On 09/13/2011 11:05 AM, Hagen Münch wrote:
>
> 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
>
>
> ------------------------------------------------------------------------------
> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
> Learn about the latest advances in developing for the
> BlackBerry® mobile platform with sessions, labs&  more.
> See new tools and technologies. Register for BlackBerry® DevCon today!
> http://p.sf.net/sfu/rim-devcon-copy1
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>
>
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com



_______________________________________________________
Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
              http://www.doteasy.com