Update to 0.9998. From the changelog:

- Fixed an issue where Sqitch would sometimes truncate the registry
  version number fetched from MySQL, most likely because the Perl runtime
  was using 32-bit integers. Fixed by casting the version to CHAR in the
  query, before Perl ever see it. Thanks to Allen Godfrey David for the
  report.
- Added the Snowflake engine.
- Now require URI::db v0.19 for Snowflake URI support.
- The Vertica and Exasol engines now require DBD::ODBC 1.59, which fixes
  a Unicode issue. Thanks to Martin J. Evans for the quick fix
  (perl5-dbi/DBD-ODBC#8)!
- Added the `bundle` command to `./Build`. This command installs only the
  runtime dependencies into the `--install_base` directory. This should
  simplify building distribution packages, binary installs, Docker images,
  and the like.
- Added the `--with` option to `./Build`, to require that Sqitch be build
  with the specified engine. Pass once for each engine. See the README
  for the list of supported engines.
- Added a check for Hash::Merge 0.298 during installation, since that
  release has a fatal bug that breaks Sqitch. If it's installed, the
  installer will issue a warning and added v0.299 to its list of
  dependencies. Thanks to Slaven Rezić for the suggestion (#377).
- Fixed the PostgreSQL engine so it properly checks the `psql` client
  version to determine whether or not the `:registry` variable is
  supported. Previously it relied on the server version, which would fail
  if the server version was greater than 8.4 but the `psql` client was
  not. Thanks to multiple folks reporting issues with registry names and
  search paths (#314).
- The plan parser will now complain if a change specifies a duplicate
  dependency. This should be less confusing than a database unique
  violation. Thanks to Eric Bréchemier for the suggestion (#344).
- Moved the project to its own GitHub organization:
  https://github.com/sqitchers.
- Fixed likely cause of Oracle buffer allocation bug when selecting
  timestamp strings. Thanks to @johannwilfling for the bug report and to
  @nmaqsudov for the analysis and solution (#316).
- Changed the way the conninfo string is passed to `psql` to eliminate
  argument ordering problems on Windows. Thanks to @highlowhighlow for
  the report (#384).
- Added `$SQITCH_USERNAME` environment variable to complement
  `$SQITCH_PASSWORD`. It can be used to override the username set in
  for a target.
- Added the `$SQITCH_FULLNAME` and `$SQITCH_EMAIL` environment
  variables, which take precedence over the values of the `user.name` and
  `user.email` config variables.
- Added the `$SQITCH_ORIG_SYSUSER`, `$SQITCH_ORIG_FULLNAME` and
  `$SQITCH_ORIG_EMAIL` environment variables. For those situations when
  Sqitch attempts to read OS data for user information, These new
  environment variables override these system-derived values. The
  intention is to allow an originating host to set these values on
  another host where Sqitch will actually execute.
- Fixed an error triggered by whitespace trailing an engine name in the
  configuration. Thanks to Jeremy Simkins for the report (#400).
- Refactored the engine-specific username and password attributes to
  support a consistent search for values. Sqitch searches first for one
  of its own environment variables (`$SQITCH_USERNAME` and
  `$SQITCH_PASSSWORD`), then the target URI, and finally any engine-
  specific values, which might include additional environment variables,
  configuration files, the system user, or none at all.
- Database engines that implicitly relied on username and/or password
  environment variables or on the system username now explicitly rely on
  them. These include the Firebird, MySQL, Postgres, and Vertical
  engines. This change should exhibit no change in the behavior of these
  engines.
- Added support for the `$MYSQL_HOST` and `$MYSQL_TCP_PORT` environment
  variables to the MySQL engine.
- Documented all supported engine-specific environment variables in the
  sqitch-environment guide.
- Renamed the sqitch-passwords guide to sqitch-authentication and added a
  section on username specification.
- Updated all URLs to use the https scheme. Only exceptions are tt2.org,
  which doesn't support TLS, and conferences.embarcadero.com, which
  appears to be down.

pkgsrc changes:

- Add options: mysql odbc oracle pgsql sqlite

3 files changed, 48 insertions, 13 deletions

diff --git a/databases/p5-App-Sqitch/Makefile b/databases/p5-App-Sqitch/Makefile
index 5c5544cec41..a92871aeba7 100644
--- a/databases/p5-App-Sqitch/Makefile
+++ b/databases/p5-App-Sqitch/Makefile
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.20 2018/08/22 09:43:13 wiz Exp $
+# $NetBSD: Makefile,v 1.21 2018/10/05 10:37:39 schmonz Exp $
 
-DISTNAME=		App-Sqitch-0.9997
+DISTNAME=		App-Sqitch-0.9998
 PKGNAME=		p5-${DISTNAME}
-PKGREVISION=		1
 CATEGORIES=		databases perl5
 MASTER_SITES=		${MASTER_SITE_PERL_CPAN:=App/}
 
@@ -14,7 +13,7 @@ LICENSE=		mit
 DEPENDS+=		p5-Clone-[0-9]*:../../devel/p5-Clone
 DEPENDS+=		p5-Config-GitLike>=1.11:../../devel/p5-Config-GitLike
 DEPENDS+=		p5-DBI-[0-9]*:../../databases/p5-DBI
-DEPENDS+=		p5-DateTime-[0-9]*:../../time/p5-DateTime
+DEPENDS+=		p5-DateTime>=1.04:../../time/p5-DateTime
 DEPENDS+=		p5-Devel-StackTrace>=1.30:../../devel/p5-Devel-StackTrace
 DEPENDS+=		p5-Digest-SHA-[0-9]*:../../security/p5-Digest-SHA
 DEPENDS+=		p5-Encode-Locale-[0-9]*:../../textproc/p5-Encode-Locale
@@ -24,9 +23,9 @@ DEPENDS+=		p5-IO-Pager-[0-9]*:../../devel/p5-IO-Pager
 DEPENDS+=		p5-IPC-Run3-[0-9]*:../../devel/p5-IPC-Run3
 DEPENDS+=		p5-IPC-System-Simple>=1.17:../../devel/p5-IPC-System-Simple
 DEPENDS+=		p5-List-MoreUtils-[0-9]*:../../devel/p5-List-MoreUtils
-DEPENDS+=		p5-Locale-libintl-[0-9]*:../../misc/p5-Locale-libintl
+DEPENDS+=		p5-Locale-libintl>=1.20:../../misc/p5-Locale-libintl
 DEPENDS+=		p5-Moo>=1.002000:../../devel/p5-Moo
-DEPENDS+=		p5-Path-Class-[0-9]*:../../devel/p5-Path-Class
+DEPENDS+=		p5-Path-Class>=0.33:../../devel/p5-Path-Class
 DEPENDS+=		p5-PerlIO-utf8_strict-[0-9]*:../../devel/p5-PerlIO-utf8_strict
 DEPENDS+=		p5-SUPER-[0-9]*:../../devel/p5-SUPER
 DEPENDS+=		p5-Scalar-List-Utils-[0-9]*:../../devel/p5-Scalar-List-Utils
@@ -40,17 +39,18 @@ DEPENDS+=		p5-Try-Tiny-[0-9]*:../../devel/p5-Try-Tiny
 DEPENDS+=		p5-Type-Tiny-[0-9]*:../../devel/p5-Type-Tiny
 DEPENDS+=		p5-Type-Tiny-XS>=0.010:../../devel/p5-Type-Tiny-XS
 DEPENDS+=		p5-URI-[0-9]*:../../www/p5-URI
-DEPENDS+=		p5-URI-db>=0.15:../../www/p5-URI-db
+DEPENDS+=		p5-URI-db>=0.19:../../www/p5-URI-db
 DEPENDS+=		p5-namespace-autoclean>=0.16:../../devel/p5-namespace-autoclean
 
 # XXX TEST_TARGET
 BUILD_DEPENDS+=		p5-Capture-Tiny>=0.12:../../devel/p5-Capture-Tiny
 BUILD_DEPENDS+=		p5-DBD-SQLite-[0-9]*:../../databases/p5-DBD-SQLite
+BUILD_DEPENDS+=		p5-Module-Runtime-[0-9]*:../../devel/p5-Module-Runtime
 BUILD_DEPENDS+=		p5-Test-Deep-[0-9]*:../../devel/p5-Test-Deep
 BUILD_DEPENDS+=		p5-Test-Dir-[0-9]*:../../devel/p5-Test-Dir
 BUILD_DEPENDS+=		p5-Test-Exception-[0-9]*:../../devel/p5-Test-Exception
 BUILD_DEPENDS+=		p5-Test-File-[0-9]*:../../devel/p5-Test-File
-BUILD_DEPENDS+=		p5-Test-File-Contents>=0.05:../../devel/p5-Test-File-Contents
+BUILD_DEPENDS+=		p5-Test-File-Contents>=0.20:../../devel/p5-Test-File-Contents
 BUILD_DEPENDS+=		p5-Test-MockModule>=0.05:../../devel/p5-Test-MockModule
 BUILD_DEPENDS+=		p5-Test-NoWarnings>=0.083:../../devel/p5-Test-NoWarnings
 BUILD_DEPENDS+=		p5-Text-Diff-[0-9]*:../../textproc/p5-Text-Diff
@@ -60,5 +60,7 @@ USE_TOOLS+=		perl
 PERL5_PACKLIST=		auto/App/Sqitch/.packlist
 PERL5_MODULE_TYPE=	Module::Build
 
+.include "options.mk"
+
 .include "../../lang/perl5/module.mk"
 .include "../../mk/bsd.pkg.mk"
diff --git a/databases/p5-App-Sqitch/distinfo b/databases/p5-App-Sqitch/distinfo
index 8a47e0e51e3..1da67e7d0f1 100644
--- a/databases/p5-App-Sqitch/distinfo
+++ b/databases/p5-App-Sqitch/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.11 2018/03/18 08:31:13 wiz Exp $
+$NetBSD: distinfo,v 1.12 2018/10/05 10:37:39 schmonz Exp $
 
-SHA1 (App-Sqitch-0.9997.tar.gz) = 551483cf96372938098528ee349b14cd485dc848
-RMD160 (App-Sqitch-0.9997.tar.gz) = 766771e17775f2409f6acaf9e8daee0a71aae6b9
-SHA512 (App-Sqitch-0.9997.tar.gz) = 8c2176164e8969c0d6053c1330fb3e919fc02b5cc76e23f6ab264c29821fb854eb8ee2d75b56d119424057b1e85767de74110b1211ed224e8f97541092435133
-Size (App-Sqitch-0.9997.tar.gz) = 527865 bytes
+SHA1 (App-Sqitch-0.9998.tar.gz) = 12659220aff24f2866808e9227b1a0d5f379c8fa
+RMD160 (App-Sqitch-0.9998.tar.gz) = f147fe5a87735fd7ec8d43d7071d7e7f3f97b2e3
+SHA512 (App-Sqitch-0.9998.tar.gz) = 4d7f7b8bb94139e39014073e3c4d22954075251e4ce7533d7e590f8f13b22ee4c167ba751b64ea93bf545954071d265d2f5b7c2ed89c590a8149654787d57940
+Size (App-Sqitch-0.9998.tar.gz) = 567429 bytes
diff --git a/databases/p5-App-Sqitch/options.mk b/databases/p5-App-Sqitch/options.mk
new file mode 100644
index 00000000000..52ad68ded0e
--- /dev/null
+++ b/databases/p5-App-Sqitch/options.mk
@@ -0,0 +1,33 @@
+# $NetBSD: options.mk,v 1.1 2018/10/05 10:37:39 schmonz Exp $
+
+PKG_OPTIONS_VAR=	PKG_OPTIONS.sqitch
+
+PKG_SUPPORTED_OPTIONS+=	mysql odbc oracle pgsql sqlite
+
+.include "../../mk/bsd.options.mk"
+
+.if !empty(PKG_OPTIONS:Mmysql)
+DEPENDS+=		p5-DBD-mysql>=4.018:../../databases/p5-DBD-mysql
+# MySQL::Config: '0'
+BUILD_PARAMS+=		--with mysql
+.endif
+
+.if !empty(PKG_OPTIONS:Modbc)
+DEPENDS+=		p5-DBD-ODBC>=1.59:../../databases/p5-DBD-ODBC
+BUILD_PARAMS+=		--with odbc
+.endif
+
+.if !empty(PKG_OPTIONS:Moracle)
+DEPENDS+=		p5-DBD-Oracle>=1.23:../../databases/p5-DBD-Oracle
+BUILD_PARAMS+=		--with oracle
+.endif
+
+.if !empty(PKG_OPTIONS:Mpgsql)
+DEPENDS+=		p5-DBD-postgresql>=2.0:../../databases/p5-DBD-postgresql
+BUILD_PARAMS+=		--with postgres
+.endif
+
+.if !empty(PKG_OPTIONS:Msqlite)
+DEPENDS+=		p5-DBD-SQLite>=1.37:../../databases/p5-DBD-SQLite
+BUILD_PARAMS+=		--with sqlite
+.endif