On Sep 15, 2005, at 9:54 PM, Greg Stark wrote:
> If you need data to propagate from the clients back to the server
> then things
> get more complicated. Even then you could side step a lot of
> headaches if you
> can structure the application in specific ways, such as
> guaranteeing that the
> clients can only insert, never update records.
And even updates could be OK if the application can support the right
partitioning of the data and only do it one place at a time. With
some kinds of field based work it might be suitable to have global
(read only) data along with data created in the field that is site/
client specific. As long as the data collected in the field is not
being updated on the master, it could continue to be updated in the
field and synced back to the master database.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL