view release on metacpan or  search on metacpan

lib/sqitch-authentication.pod  view on Meta::CPAN

=encoding UTF-8

=head1 Name

sqitch-authentication - Guide to using database authentication credentials with Sqitch

=head1 Description

For database engines that require authentication, Sqitch supports a number
of credential-specification options, and searches for them in a specific
sequence. These searches are performed in two parts: a search for a username
and a search for a password.

=head1 Usernames

lib/sqitch-authentication.pod  view on Meta::CPAN

For ODBC connections from Sqitch, we can use connection settings in F<~/.odbc.ini>:

  [flipr_test]
  DRIVER = Exasol
  EXAHOST = localhost:8563
  EXAUID = sys
  EXAPWD = exasol
  AUTHMETHOD = refreshtoken

When combining the above, Sqitch doesn't need to know any credentials; they are
stored somewhat safely in F<~/.exasol/profiles.xml> and F<~/.odbc.ini>:

  > sqitch status db:exasol:flipr_test
  # On database db:exasol:flipr_test
  # Project:  flipr
  # ...
  #
  Nothing to deploy (up-to-date)
  > sqitch rebase --onto '@HEAD^' -y db:exasol:flipr_test
  Reverting changes to hashtags @v1.0.0-dev2 from db:exasol:flipr_test

lib/sqitchguides.pod  view on Meta::CPAN

sqitchguides - List of common Sqitch guides

=end private

The common Sqitch guides are:

  changes             Specifying changes for Sqitch
  configuration       Hierarchical engine and target configuration
  environment         Environment variables
  authentication      Specifying target authentication credentials
  tutorial            PostgreSQL Tutorial
  tutorial-firebird   Firebird Tutorial
  tutorial-mysql      MySQL Tutorial
  tutorial-oracle     Oracle Tutorial
  tutorial-sqlite     SQLite Tutorial
  tutorial-vertica    Vertica Tutorial
  tutorial-exasol     Exasol Tutorial
  tutorial-snowflake  Snowflake Tutorial

See C<< sqitch help <command> >> or C<< sqitch help <concept> >> to read about