Home > Archive > PostgreSQL Discussion > March 2005 > Re: do I need replication or something else?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: do I need replication or something else?
Tony Caduto

2005-03-30, 9:41 am

If you are using Delphi you can use the tclientdataset which has a
Briefcase type system built in.
Or you can use one of the many middleware systems that are available for
Delphi, all of which will do what you want.
www.remobjects.com
www.astatech.com
etc etc

Most of them work by creating a XML local dataset then applying that XML
dataset when the client logs back in, it handles the conflict resolution
etc.

Delphi really is one of THE best ways to develop database apps.

Tony

Scott Marlowe wrote:

>On Tue, 2005-03-29 at 16:06, Caleb Simonyi-Gindele wrote:
>
>
>
>It's important to understand that what you're asking for is MORE than
>simple replication, it is replication with ((semi)automatic) conflict
>resolution. If you use a simple replication system to try and do this,
>you are likely to wind up with inconsistent data.
>
>Just because SQL Server does it doesn't mean it does it right. And the
>general philosophy of the PostgreSQL team seems to be do it right or
>don't bother.
>
>So, what are the chances that you'll have records on your sales folks
>machines that have also been updated back at the home office? What
>rules should be applied when conflicts arise? These are the kinds of
>questions you need to answer before jumping feet first into the fire and
>getting burnt.
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
>
>



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com