[no subject]

I have been considering that method as well. The drawbacks are
intermittent connectivity (fixable with a secondary script to cache and
retry when connectivity returns) the overall size of the originating
codebase (Interchange is freaking HUGE!)
> 
> On Thu, 2005-02-10 at 09:51, James P. Kinney III wrote:
> > More brainstorming (after a mail crash yesterday!)
> > 
> > Postgresql 8 has a pretty good Write Ahead Logging. A seperate project I
> > am looking at is to use the WAL as a way to syncronize two databases
> > that are not in a mirror mode of any type.
> > 
> > The scenario: Main DB has the _real_ web transactions, user list,
> > products, etc.  Second machine gats a clone of the main machine at a
> > point in time. Second machine is hauled to a trade show where the net
> > access is (or lack) prevents a direct line to the main db.
> > 
> > Second machine runs the transaction locally after a checkpoint in the
> > WAL is set. After the show, the WAL is replayed back into the main
> > machine to merge in the transactions from the satellite unit.
> > 
> > Other than the obvious issues of duplicated transactions (not likely
> > except for possibly adding a new user) and the sequence id's for the
> > transactions (I will have to double check that the sequencing id's are
> > only used as record counters), are there any "gotcha's" that others have
> > run across in anything similar?
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
&gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
-- 
James P. Kinney III          \Changing the mobile computing world/
CEO &amp; Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
<a  rel="nofollow" href="http://www.localnetsolutions.com";>http://www.localnetsolutions.com</a>

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
&lt;jkinney at localnetsolutions.com&gt;
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part



</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><a name="00358" href="msg00358.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> david.muse at firstworks.com (David Muse)</li></ul></li>
</ul></li></ul>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00253" href="msg00253.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> jkinney at localnetsolutions.com (James P. Kinney III)</li></ul></li>
<li><strong><a name="00262" href="msg00262.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> kaboom at gatech.edu (Chris Ricker)</li></ul></li>
<li><strong><a name="00343" href="msg00343.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> jkinney at localnetsolutions.com (James P. Kinney III)</li></ul></li>
<li><strong><a name="00344" href="msg00344.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Christopher Fowler)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00344.html">[ale] database conversion</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00346.html">[ale] [Sorta OT] Thinkpad 600x TV out</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00344.html">[ale] database conversion</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00358.html">[ale] database conversion</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00345"><strong>Date</strong></a></li>
<li><a href="threads.html#00345"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>