Re: [GENERAL] Disconnected editing - versioning of databases

2009-04-15 Thread Johan Nel
Will, William Temperley wrote: Hi All I'm wondering if anyone can share any insights or experience with temporary versions of databases, allowing disconnected editing during Internet downtime. What do your users use for updating data? Software that you developed for them? Do they use a

Re: [GENERAL] Disconnected editing - versioning of databases

2009-04-15 Thread Dimitri Fontaine
Le Wednesday 15 April 2009, Greg Smith a écrit : On Tue, 14 Apr 2009, William Temperley wrote: I could potentially run a database in each of these countries and provide 100% uptime, obviously raising the issue of version conflicts that would require hand-merging. Can you partition data on

Re: [GENERAL] Disconnected editing - versioning of databases

2009-04-15 Thread William Temperley
On Wed, Apr 15, 2009 at 9:34 AM, Dimitri Fontaine dfonta...@hi-media.com wrote: On Tue, 14 Apr 2009, William Temperley wrote: I could potentially run a database in each of these countries and provide 100% uptime, obviously raising the issue of version conflicts that would require

Re: [GENERAL] Disconnected editing - versioning of databases

2009-04-14 Thread Greg Smith
On Tue, 14 Apr 2009, William Temperley wrote: I could potentially run a database in each of these countries and provide 100% uptime, obviously raising the issue of version conflicts that would require hand-merging. It sounds like you want an asynchronous master-slave database architecture

[GENERAL] Disconnected editing - versioning of databases

2009-04-14 Thread William Temperley
Hi All I'm wondering if anyone can share any insights or experience with temporary versions of databases, allowing disconnected editing during Internet downtime. The use-case is that I run a Postgres database, hosted in the UK, but used by scientists in several other countries - Ecuador,