Re: Libpq question - Mailing list pgsql-general

From Chris Angelico
Subject Re: Libpq question
Date
Msg-id CAPTjJmrdxoLc_F8YeFgF4ipceEPyUPnGeCpmof0UGT0STvNqLw@mail.gmail.com
Whole thread Raw
In response to Re: Libpq question  (John R Pierce <pierce@hogranch.com>)
Responses Re: Libpq question
List pgsql-general
On Mon, May 21, 2012 at 6:12 AM, John R Pierce <pierce@hogranch.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

pgsql-general by date:

Previous
From: josepdba
Date:
Subject: Re: Questions of the privileges to use the pg_cancel_backend and pg_terminate_backend function. Thanks.
Next
From: Tom Lane
Date:
Subject: Re: timestamps, formatting, and internals