Re: Question: merit / feasibility of compressing frontend

Hello,

Without getting into a huge debate over which implementation is
better. I can suffice to say that we have seen significant demand for
this solution without the obnoxiousness of ssh. SSH is great for lots of
stuff, but you are adding an addition user layer application to manage.
Our implementation will make it so that you literally just say
compression=yes in the connection string and boom.... it's compressed.

There is a real commercial need, when dealing with VPN's, remote
users, and web based distributed applications for something like this.

Sincerely,

Joshua Drake

Chris Albertson wrote:

>Does the ODBC or JDBC interface use compression? I think these
>are more likely to be used over a non-LAN connection.
>
>The other use for compression would be for a data sync between
>two database installations that are geographically distributed.The idea
>is that two offices would each have a local DBMS but the link
>between them is slow. Compression could help in that case.
>
>Compression is not all that hard to set up using port forwarding
>proxies
>like you thought. In fact ssh can do it already if you specify the
>"-C" option.
>
>
>--- Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> wrote:
>
>
>>On Mon, Jul 15, 2002 at 12:01:03PM -0700, pgsql-general wrote:
>>
>>
>>> As one of my first projects I'm been asked to compress with zlib
>>>(www.gzip.org/zlib ) data flowing from postgres clients to and
>>>especially from the backend server. Our first idea was to write a
>>>
>>>
>>sort
>>
>>
>>>of 'compression proxy' with a frontend and backend of its own. The
>>>postgres client would connect to the compression frontend on their
>>>
>>>
><SNIP>
>
>=====
>Chris Albertson
> Home: 310-376-1029 chrisalbertson90278(at)yahoo(dot)com
> Cell: 310-990-7550
> Office: 310-336-5189 Christopher(dot)J(dot)Albertson(at)aero(dot)org
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Autos - Get free new car price quotes
>http://autos.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>