Quoting Rick Gigger <rick@alpinenetworking.com>:
> > Hi Rick;
> >
> > I have been looking for a few years at a similar situation with my CRM
> > software and soon (once I have the SOAP interfaces done, I will start on a
> > stand-alone client. I have eventually decided on a very different
> structure
> > than you have, though the result is more or less the same.
> >
> > Rather than using PostgreSQL as an embedded database manager, I have
> decided
> > that it makes more sense for my app to "cache objects" in XML documents
> and
> > then use those on trips to customers' sites. The XML documents can then
> be
> > checked and the objects re-sync'd when the app goes online again. The
> > cacheing would be automatic and cached objects would expire unless
> > explicitly saved.
> >
> > Why not use XML for this sort of problem? Or berkeley DB? Is there any
> > reason that PostgreSQL would be better? I am not aware of any functional
> > replication systems which would work in this way, so I am guessing your
> app
> > will have to handle all the logic for the syncronization anyway.
>
> Well since the desktop and server app are using almost exactly the same code
> it is nice to not have to recode everything that accesses the database.
> While data syncronization code will have to be written either way I want the
> existing code to "just work" once taken off line.
Rick,
I'm not sure what OS you're using (I might have missed it in the thread) but
I've never even thought about an embedded database because PG runs very nice on
my laptop (P III - 850Mhz but I did NOT it new). Now, I'm running Linux so
maybe that is the difference. In fact, I'm found it to be invaluable to take it
to a client meeting and show not only the high level application gloss but I can
also show the guts of a application/web site.
Now I do understand the sync'ning issue with the database and I haven't had that
issue yet but since you'd have two Pg server's, I would think this issue could
be handled one of the replication project that is available or by something you
custom build (like a perl script that connects to both systems and syncs by
checking for missing pkey's in both systems).
If you have the ability, you might want to invest in building a laptop with
Linux on it until the features you want are available in the methods you want to
use them in.
-$0.02
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com