Re: Should psql support URI syntax?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <jd(at)commandprompt(dot)com>,"Andrew Dunstan" <andrew(at)dunslane(dot)net>
Cc: "Joshua Berkus" <josh(at)agliodbs(dot)com>, "Magnus Hagander" <magnus(at)hagander(dot)net>, "Dave Page" <dpage(at)pgadmin(dot)org>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Should psql support URI syntax?
Date: 2011-04-01 17:04:21
Message-ID: 4D95BF45020000250003C137@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Joshua D. Drake" <jd(at)commandprompt(dot)com> wrote:

> Well I would argue that if compatibility (as opposed to
> familiarity) is our goal, we need to focus on one and only one
> syntax, JDBC. It doesn't matter our particular bent, JDBC is the
> one that is in the most use.

The start of a URI defines the protocol so that the correct protocol
handler can be used, like http: versus ftp:. jdbc:postgresql: URIs
define one protocol on the wire. Are we talking about a separate
protocol or the same one, in terms of what happens on the wire? If
the same one, I would tend to agree with JD that we can just use the
existing URI format. It seems to me that claiming a second protocol
prefix for the same protocol would only be a good idea if there was
a "marketing" benefit in doing so.

If we do decide it's worth getting some non-jdbc-based protocol
identifier, I would suggest pq: if it's not taken, as we call the
library for using it libpq.

-Kevin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rajasekhar Yakkali 2011-04-01 17:07:57 Re: Postgres 9.1 - Release Theme
Previous Message Dan Ports 2011-04-01 17:00:28 trivial patch: show SIREAD pids in pg_locks