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

Changes for version 0.93 - 2012-08-31

  • Added forward and reverse change references. Append ^ to a change reference to mean the change before, or ~ to mean the change following. Use ~~ and ^^ to select two changes forward and back, and ~n and ^n, where n is an integer, to select that number of changes forward or back. Idea stolen from Git, though the meanings of the characters are different.
  • Added the @FIRST and @LAST symbolic references to refer to the first and last changes deployed to the database, respectively. These vary from the existing @ROOT and @HEAD symbolic references, which refer to the first and last changes listed in the plan.
  • Updated the tutorial to use the new symbolic references and ^ and ~ qualifiers where appropriate.
  • The messages output by the `deploy` and `revert` commands now show the resolved name of the `--to` target, rather than the value passed to `--to`. This is most useful when using a symbolic reference, so you can see what you're actually deploying or reverting to.

Documentation

Sqitch add usage statement
Add a database change to the plan
Sqitch bundle usage statement
Bundle a Sqitch project for distribution
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 database change logs
Sqitch revert usage statement
Revert changes to a database
Sqitch rework usage statement
Rework a database change
Sqitch status usage statement
Show the current deployment status of a database
Sqitch tag usage statement
Create or list tag objects
Sane database change management
List of common sqitch commands
A tutorial introduction to Sqitch

Modules

Sane database change management
Sqitch Command support
Add a new change to a Sqitch plan
Bundle Sqitch changes for distribution
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
Revert Sqitch changes from a database
Rework a Sqitch change
Display status information about Sqitch
Add or list tags in a Sqitch plan
Sqitch configuration management
Sqitch DateTime object
Sqitch Deployment Engine
Sqitch PostgreSQL Engine
Sqitch SQLite Engine
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
Sqitch Exception class