Re: Libpq question

From: John Townsend <jtownsend(at)advancedformulas(dot)com>
To: zeljko <zeljko(at)holobit(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Libpq question
Date: 2012-05-20 19:52:38
Message-ID: 4FB94B86.4000907@advancedformulas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

Would it be worth it? Depends, but for most situations would not give
you more speed. With FPC comes a nice utility called h2pas.exe that does
a decent job and can save you a lot of time. You still have to clean
some translations.

Look at the *.c & *.h \src\interfaces\libpq directory that comes with
the postgres source.

John

On 5/20/2012 7:51 AM, zeljko wrote:
> John Townsend wrote:
>
>> It appears that some developers (Davart) are by-passing the standard
>> client library, “libpq.dll”, and directly accessing the server using
>> Delphi or FPC. I am not sure of the advantage here. All libpq.dll
> I'm FPC user and I use libpq.so(.dll,.dylib) via zeoslib.
> Those who bypass libpq probably uses odbc connections or similar.
>
> zeljko
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-05-20 20:12:24 Re: Libpq question
Previous Message c k 2012-05-20 18:00:54 losing schema name in pg_dump