On Fri, Nov 22, 2013 at 05:13:53PM -0800, David E. Wheeler wrote: > DBI Folks & Gisle, > > I want to add support for specifying database connections as URIs to Sqitch, > my DB change management system. I started working on it today, following the > examples of JDBC and PostgreSQL. Before I release, though, I’d like a bit of > feedback on a couple of things. > > First, I'm using the database name as the scheme in the URL. Some examples: > > postgresql://user@localhost:5433/dbname > sqlite:///path/to/foo.db > > This is to make it easy to tell one DB from another. But I'm wondering if I > should follow the example of JDBC more closely, and prepend "db:" or > something to them. More like DBI DSNs, too. However, it would require a bit > more work, as URI.pm does not currently recognize multiple colon-delimited > strings as scheme names AFAICT. :-(
Why not define a direct translation from a URL to a DBI DSN? A translation that doesn't require knowledge of any driver-specifics. Tim.
