The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

Changes for version 0.996 - 2014-09-05

  • Fixed one more test failure due to the introduction of "Negative repeat count does nothing" warning in Perl 5.21.1.
  • Fixed "Redundant argument in printf" warning on Perl 5.21.2.
  • Switched from Digest::SHA1, which is deprecated, to Digest::SHA for generating SHA-1 IDs.
  • Switched from Mouse and Moose to Moo. Sqitch no longer depends on any modules that use Moose, either. This results in an approximately 40% startup time speedup.
  • Loading of App::Sqitch::DateTime is now deferred until it's needed. This is because DateTime is rather expensive to load. Since a number of commands don't need it, it seems silly to load it in those cases.
  • Now recommend Type::Tiny::XS and Class::XSAccessor for improved performance.
  • The `check` command now properly fails on a plan parse error, instead of blindly continuing on.
  • Fixed a failing test on PosrgreSQL due to localization issues. Thanks to Sven Schoberf for the report (Issue #171).
  • Added the `revert.prompt_accept`, `rebase.prompt_accept`, and `checkout.prompt_accept` boolean configuration variables. Set these variables to false to change the default answer to the revert prompt to "No". When rebasing or checking out, if the variables specific to those commands are not set, Sqitch will fall back on the value of `revert.prompt_accept`. Suggested by Graeme Lawton (Issue #164).
  • The MySQL engine now sets the `$MYSQL_PWD` environment variable if a password is provided in a target. This should simplify authtentication when running MySQL change scripts through the `mysql` client client (Issue #150).
  • The MySQL engine now reads `client` and `mysql` groups in the MySQL configuration files for a password when connecting to the registry database, and when the target URI includes no password. The MySQL client already read those files, of course, but now the internal database connection does as well (Issue #150).
  • The Firebird engine now sets the `$ISC_PASSWORD` environment variable if a password is provided in a target. This should simplify authtentication when running Firebird change scripts through the `isql` client client. Patch from Ștefan Suciu.
  • No longer passing URI query params as DBI params, because they are already included in the DSN provided by URI::db.
  • Added the Vertica engine.

Documentation

Sqitch add usage statement
Add a database change to the plan
Sqitch bundle usage statement
Bundle a Sqitch project for distribution
Sqitch checkout usage statement
Revert, checkout another VCS branch, and re-deploy changes
Sqitch config usage statement
Get and set local, user, or system Sqitch options
Sqitch deploy usage statement
Deploy changes to a database
Sqitch help usage statement
Display help for Sqitch and Sqitch commands
Sqitch init usage statement
Create a new Sqitch project
Sqitch log usage statement
Show Sqitch change logs
Sqitch plan usage statement
Show planned database changes
Sqitch rebase usage statement
Revert and redeploy database changes
Sqitch revert usage statement
Revert changes to a database
Sqitch rework usage statement
Rework a database change
Sqitch show usage statement
Show object information or change file contents
Sqitch status usage statement
Show the current deployment status of a database
Sqitch tag usage statement
Create or list tag objects
Sqitch target usage statement
Mange set of target databases
Sqitch verify usage statement
Verify deployed database changes
Sane database change management
List of common sqitch commands
A tutorial introduction to Sqitch change management on Firebird
A tutorial introduction to Sqitch change management on MySQL
A tutorial introduction to Sqitch change management on Oracle
A tutorial introduction to Sqitch change management on SQLite
A tutorial introduction to Sqitch change management on Vertica
A tutorial introduction to Sqitch change management on PostgreSQL
Sqitch usage statement

Modules

Sane database change management
Sqitch Command support
Add a new change to a Sqitch plan
Bundle Sqitch changes for distribution
Revert, change checkout a VCS branch, and redeploy
Get and set local, user, or system Sqitch options
Deploy Sqitch changes to a database
Display help information about Sqitch
Initialize a Sqitch project
Show a database event log
List the changes in the plan
Revert and redeploy Sqitch changes
Revert Sqitch changes from a database
Rework a Sqitch change
Show Sqitch changes to a database
Display status information about Sqitch
Add or list tags in a Sqitch plan
Add, modify, or list Sqitch target databases
Verify deployed Sqitch changes
Sqitch configuration management
Sqitch DateTime object
Sqitch Deployment Engine
Sqitch Firebird Engine
Sqitch MySQL Engine
Sqitch Oracle Engine
Sqitch PostgreSQL Engine
Sqitch SQLite Engine
Sqitch Vertica Engine
Format events and changes for command output
Sqitch Deployment Plan
Sqitch deployment plan blank line
Sqitch deployment plan tag
Sqitch deployment plan change list
Sqitch dependency specification
Sqitch deployment plan line
Sqitch deployment plan line list
Sqitch deployment plan blank line
Sqitch deployment plan tag
An engine based on the DBI
A command that reverts and deploys
Definition of attribute data types
Sqitch Exception class