[ale] Question: Transparent document sharing over the Internet

[James P. Kinney III]

On Wed, 2005-06-08 at 16:15 -0400, Jeff Hubbs wrote:
> I'm not sure about PostgreSQL's ability to store arbitrary binaries -
> and you'd have to write something to interface with it if it did - but I
> know that Zope can do this sort of thing if you let your participants
> "under the hood" of the app server and let them upload arbitrary files
> as Zope objects.  
> 
> Jeff

PostgreSQL support blobs up to 2 GB per blob on a 32 bit machine and
much larger (and totally impractical) on 64 bit machines.

However, blob can't be "dumped" in a restorable format. They can be
dumped in a maner that requires an external script to reimport into the
database.

The idea of recovering a downed database with multiple gig+ size blobs
make me queasy just thinking about it.


What this problem requires is automatic VPN's for the remote crowd and
an automatic rsync script on every machine that merges back to the main
server.

The better solution is better user training. Software solutions for
idiot problems only make more incompetent idiots.

-- 
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
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