From: | Chris Angelico <rosuav(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Libpq question |
Date: | 2012-05-20 22:19:30 |
Message-ID: | CAPTjJmrdxoLc_F8YeFgF4ipceEPyUPnGeCpmof0UGT0STvNqLw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, May 21, 2012 at 6:12 AM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 05/20/12 12:52 PM, John Townsend wrote:
>>
>> By by-passing the "dll" (or "so" on Linux) library I mean you write
>> function or procedure calls to the server that is running as a service on
>> Windows. You don't use the library with its 160 exported functions. You
>> connect directly to the server thus saving one layer of protocols. To do
>> this, you have to translate all the c functions you need (not just the
>> headers or ".h" files) into pascal. Not a trivial task!
>
> the database service is a completely separate collection of processes. you
> can't just 'call' between processes, you need a RPC mechanism. sockets are
> as good a mechanism as any.
In that case, yes, there are such implementations around. Martijn
mentioned a few, and I mentioned the Pike one, all of which do indeed
bypass libpq and talk directly to the server. It is, as I understand
it, an open and stable protocol, so it's no different from writing a
program that connects to port 25 and talks SMTP rather than dropping
to sendmail.
Chris Angelico
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-05-20 22:50:42 | Re: timestamps, formatting, and internals |
Previous Message | josepdba | 2012-05-20 20:45:19 | Re: Questions of the privileges to use the pg_cancel_backend and pg_terminate_backend function. Thanks. |