Message-ID: <4AE6A14B.7020909@hogranch.com>
Date: Tue, 27 Oct 2009 00:29:15 -0700
From: John R Pierce <pierce@hogranch.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
To: Raimon Fernandez <coder@montx.com>
CC: pgsql-general@postgresql.org
Subject: Re: Implementing Frontend/Backend Protocol TCP/IP
References: <92781008-8A70-42CE-A49B-6EE67103FACB@montx.com>
	<FC6CBC8C-A398-4835-B3A3-C16C6F4F62D9@pgedit.com>
	<E084987E-A212-4B70-8CFF-D83AA00629C5@montx.com>
	<C670629A-1E54-4F80-9497-6CCAC1A8BDC0@montx.com>
	<20091026231516.GN8812@alvh.no-ip.org>
	<4AE62E21.7040600@hogranch.com>
	<F9B13903-C8D7-4A92-825D-EB12FE646A63@montx.com>
In-Reply-To: <F9B13903-C8D7-4A92-825D-EB12FE646A63@montx.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Raimon Fernandez wrote:
> REALbasic has plugin for PostgreSQL, but they are synchronous  and 
> freeze the GUI when interacting with PG. This is not a problem 
> noramlly, as the SELECTS/UPDATES/... are fast enopugh, but sometimes 
> we need to fetch 1000, 5000 or more rows and the application stops to 
> respond, I can't have a progressbar because all is freeze, until all 
> data has come from PG, so we need a better way.

I would think the better solution would be to get the vendor to fix its 
native plugin to support an asynchronous mode.   Or, does this RealBasic 
support any sort of client-server or multi-task type programming?  if 
so, have a separate task or thread that does the SQL operations which 
your interactice program interfaces with...