Re: libpq URL syntax vs SQLAlchemy - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: libpq URL syntax vs SQLAlchemy
Date
Msg-id 4FAE2F510200002500047C20@gw.wicourts.gov
Whole thread Raw
In response to libpq URL syntax vs SQLAlchemy  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
>>Simon Riggs  wrote:
>>On 9 May 2012 19:17, Peter Eisentraut  wrote:
>>
>>> I have been reviewing how our new libpq URL syntax compares
>>> against existing implementations of URL syntaxes in other drivers
>>> or higher-level access libraries. In the case of SQLAlchemy,
>>> there is an incompatibility regarding how Unix-domain sockets are
>>> specified.
>>
>> Is there an open standard that already defines this?
There are many.  The most recent, as far as I know is RFC 3986, which
updates one previous RFC and obsoletes three others.
http://tools.ietf.org/html/rfc3986
We should also take the JDBC URL requirements into consideration. 
One unpleasant aspect of this is that what JDBC calls a "URL" is
"jdbc:" followed by what could be a valid URI; but I don't see how
the *whole thing* (including the leading "jdbc:" qualifies as a URI
or URL).  Unless someone has a better idea, I suggest that we make
what follows the "jdbc:" portion of the JDBC "URL" match what we use
for a URI for everything else.
>> If there is an existing standard we should follow it
+1

I don't know whether recent work on this has respected the standards.
I hope so.
-Kevin


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Draft release notes complete
Next
From: Tom Lane
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Ensure age() returns a stable value rather than the latest value