Re: [Pypgsql-users] c-jdbc (or rather sqlrelay ?)

[Karsten H. <Kar...@gm...>]

> However, some larger companies want to use the application as well. One
> company has some 15 locations where people are working. Off course this
> can be supported with high bandwidth online connections, but these
> connections are expensive, and unreliable. Therefor I have been looking
> for a way to get rid of the direct online connection. So, what I want is
> a local connection to the database, with asynchronous updates to
> databases that are in the same 'logical' cluster of databases. c-jdbc
> looks like the proper candidate for this action, however no luck because
> we developed using Python.....
Sounds like you are looking at a middleware-solution where
frontends talk to a locally running server (say, XML-RPC one)
which in turn talks to the DBs (or not if disconnected). You
might start working against a hot-spare DB on the local host
when the remote DB goes dead and start logging all SQL
statements during disconnected operation. Once reconnected you
can try replaying the DML log (which isn't guaranteed to
succeed due to other users' DMLs).

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346