[dhcwg] URIs for backend storage

[Tony Finch <[e-mail]>]

One of the questions that arose in the DHC WG meeting this afternoon was
about a standard YANG netconf way to describe backend storage for leases.
IIRC, someone asked if a URL would be enough and the general response was
um, maybe?

There is a de-facto quasi-standard for database connection URLs used by
JDBC - pretty much all SQL databases and some noSQL databases (including
Cassandra) have a spec for describing connection details in a URL,
including when there are multiple possible servers.

Of course, instead of a JDBC URL, you could also configure your DHCP
server with a file: URL for old school lease storage.

I found out about this from PostgreSQL -
https://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-CONNSTRING

I haven't found a good description of C* JDBC URLs other than
https://stackoverflow.com/questions/30743272/what-is-the-connection-url-to-be-used-for-cassandra#30795079
which suggests that they use `--` for separating hostnames (which from
my pedantic hostmaster point of view is mildly problematic...!)

Tony.
-- 
f.anthony.n.finch  <[e-mail]>  http://dotat.at/  -  I xn--zr8h punycode
Sole, Lundy, Fastnet: Northeast 5 to 7, becoming variable 3 or 4. Moderate or
rough. Mainly fair. Good.