The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
App-Sqitch-0.9998
River stage one • 2 direct dependents • 2 total dependents
43 ++

Changes for version 0.9998 - 2018-10-03

  • 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.

Documentation

sqitch-add-usage
Sqitch add usage statement
sqitch-add
Add a database change to plans
sqitch-authentication
Guide to using database authentication credentials with Sqitch
sqitch-bundle-usage
Sqitch bundle usage statement
sqitch-bundle
Bundle a Sqitch project for distribution
sqitch-checkout-usage
Sqitch checkout usage statement
sqitch-checkout
Revert, checkout another VCS branch, and re-deploy changes
sqitch-config-usage
Sqitch config usage statement
sqitch-config
Get and set local, user, or system Sqitch options
sqitch-configuration
Hierarchical engine and target configuration
sqitch-deploy-usage
Sqitch deploy usage statement
sqitch-deploy
Deploy changes to a database
sqitch-engine-usage
Sqitch engine usage statement
sqitch-engine
Manage database engine configuration
sqitch-environment
Environment variables recognized by Sqitch
sqitch-help-usage
Sqitch help usage statement
sqitch-help
Display help for Sqitch and Sqitch commands
sqitch-init-usage
Sqitch init usage statement
sqitch-init
Create a new Sqitch project
sqitch-log-usage
Sqitch log usage statement
sqitch-log
Show Sqitch change logs
sqitch-passwords
Guide to using database passwords with Sqitch
sqitch-plan-usage
Sqitch plan usage statement
sqitch-plan
Show planned database changes
sqitch-rebase-usage
Sqitch rebase usage statement
sqitch-rebase
Revert and redeploy database changes
sqitch-revert-usage
Sqitch revert usage statement
sqitch-revert
Revert changes to a database
sqitch-rework-usage
Sqitch rework usage statement
sqitch-rework
Rework a database change
sqitch-show-usage
Sqitch show usage statement
sqitch-show
Show object information or change file contents
sqitch-status-usage
Sqitch status usage statement
sqitch-status
Show the current deployment status of a database
sqitch-tag-usage
Sqitch tag usage statement
sqitch-tag
Create or list tag objects
sqitch-target-usage
Sqitch target usage statement
sqitch-target
Manage target database configuration
sqitch-upgrade-usage
Sqitch upgrade usage statement
sqitch-upgrade
Upgrade the registry to the current version
sqitch-verify-usage
Sqitch verify usage statement
sqitch-verify
Verify deployed database changes
sqitch
Sane database change management
sqitchchanges
Specifying changes for Sqitch
sqitchcommands
List of common sqitch commands
sqitchguides
List of common Sqitch guides
sqitchtutorial-exasol
A tutorial introduction to Sqitch change management on Exasol
sqitchtutorial-firebird
A tutorial introduction to Sqitch change management on Firebird
sqitchtutorial-mysql
A tutorial introduction to Sqitch change management on MySQL
sqitchtutorial-oracle
A tutorial introduction to Sqitch change management on Oracle
sqitchtutorial-snowflake
A tutorial introduction to Sqitch change management on Snowflake
sqitchtutorial-sqlite
A tutorial introduction to Sqitch change management on SQLite
sqitchtutorial-vertica
A tutorial introduction to Sqitch change management on Vertica
sqitchtutorial
A tutorial introduction to Sqitch change management on PostgreSQL
sqitchusage
Sqitch usage statement

Modules

App::Sqitch
Sane database change management
App::Sqitch::Command
Sqitch Command support
App::Sqitch::Command::add
Add a new change to Sqitch plans
App::Sqitch::Command::bundle
Bundle Sqitch changes for distribution
App::Sqitch::Command::checkout
Revert, change checkout a VCS branch, and redeploy
App::Sqitch::Command::config
Get and set local, user, or system Sqitch options
App::Sqitch::Command::deploy
Deploy Sqitch changes to a database
App::Sqitch::Command::engine
Add, modify, or list Sqitch database engines
App::Sqitch::Command::help
Display help information about Sqitch
App::Sqitch::Command::init
Initialize a Sqitch project
App::Sqitch::Command::log
Show a database event log
App::Sqitch::Command::plan
List the changes in the plan
App::Sqitch::Command::rebase
Revert and redeploy Sqitch changes
App::Sqitch::Command::revert
Revert Sqitch changes from a database
App::Sqitch::Command::rework
Rework a Sqitch change
App::Sqitch::Command::show
Show Sqitch changes to a database
App::Sqitch::Command::status
Display status information about Sqitch
App::Sqitch::Command::tag
Add or list tags in Sqitch plans
App::Sqitch::Command::target
Add, modify, or list Sqitch target databases
App::Sqitch::Command::upgrade
Upgrade the Sqitch registry
App::Sqitch::Command::verify
Verify deployed Sqitch changes
App::Sqitch::Config
Sqitch configuration management
App::Sqitch::DateTime
Sqitch DateTime object
App::Sqitch::Engine
Sqitch Deployment Engine
App::Sqitch::Engine::exasol
Sqitch Exasol Engine
App::Sqitch::Engine::firebird
Sqitch Firebird Engine
App::Sqitch::Engine::mysql
Sqitch MySQL Engine
App::Sqitch::Engine::oracle
Sqitch Oracle Engine
App::Sqitch::Engine::pg
Sqitch PostgreSQL Engine
App::Sqitch::Engine::snowflake
Sqitch Snowflake Engine
App::Sqitch::Engine::sqlite
Sqitch SQLite Engine
App::Sqitch::Engine::vertica
Sqitch Vertica Engine
App::Sqitch::ItemFormatter
Format events and changes for command output
App::Sqitch::Plan
Sqitch Deployment Plan
App::Sqitch::Plan::Blank
Sqitch deployment plan blank line
App::Sqitch::Plan::Change
Sqitch deployment plan tag
App::Sqitch::Plan::ChangeList
Sqitch deployment plan change list
App::Sqitch::Plan::Depend
Sqitch dependency specification
App::Sqitch::Plan::Line
Sqitch deployment plan line
App::Sqitch::Plan::LineList
Sqitch deployment plan line list
App::Sqitch::Plan::Pragma
Sqitch deployment plan blank line
App::Sqitch::Plan::Tag
Sqitch deployment plan tag
App::Sqitch::Role::DBIEngine
An engine based on the DBI
App::Sqitch::Role::RevertDeployCommand
A command that reverts and deploys
App::Sqitch::Role::TargetConfigCommand
A command that handles target-related configuration
App::Sqitch::Target
Sqitch deployment target
App::Sqitch::Types
Definition of attribute data types
App::Sqitch::X
Sqitch Exception class

Other files