Re: Connecting over UNIX domain sockets

From: Florian Weimer <fweimer(at)bfk(dot)de>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Connecting over UNIX domain sockets
Date: 2011-02-09 10:14:56
Message-ID: 82aai5zf8f.fsf@mid.bfk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

* John R. Pierce:

> On 02/08/11 6:55 AM, Florian Weimer wrote:
>> I would like to have the option to connect to the database over UNIX
>> domain sockets (sidestepping the question of password management).
>>
>> Even though the JVM knows about UNIX domain sockets, this
>> functionality is not exposed to user code, so we'd have to add some
>> JNI code. Would you like to integrate this in some way? If yes,
>> would you prefer a socket-based or libpq-based approach?
>
> socket based would require less work, as you'd just add that to the
> existing socket code, while using libpq would essentially end up with
> an entirely different JDBC.

I would try to add a low-level read/write API to libpq. libpq would
only handle configuration processing, authentication and the transport
layer (which may include TLS).

> managing and installing JNI based code across platforms is a pain in
> the sternum.

Some people do have working software distribution platforms. 8-)

--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver 2011-02-09 11:34:18 postgres.jar
Previous Message Oliver Jowett 2011-02-09 09:40:00 Re: ResultSet.getClob() causing problems when used with JPA's @Lob