Re: Libpq question

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

In response to

Responses

Browse pgsql-general by date

  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.