Sqitch

Sqitch works just like any other version control system, tracking changes between files, but unlike normal VCS systems, Sqitch tracks only changes made to a database.

If something went wrong at one point or another during the development stage, Sqitch allows developers to simply go back in time and track the error, or more simply, just revert the entire database.

Sqitch is a very helpful tool, especially in critical Web applications where the stored data must be protected against accidental modifications or hacking attempts.

For now, only PostgreSQL, SQLite and MySQL are supported with Sqitch.

What is new in this release:

• Fixed installation failure due to missing IO::File module on Windows.
• Fixed file test failure for the Oracle engine on Windows.
• Fixed bug where namespace-autoclean: 0.16 caused errors such as "Invalid object instance: 'yellow'".

What is new in version 0.9991:

• Fixed installation failure due to missing IO::File module on Windows.
• Fixed file test failure for the Oracle engine on Windows.
• Fixed bug where namespace-autoclean: 0.16 caused errors such as "Invalid object instance: 'yellow'".

What is new in version 0.999:

• Fixed installation failure due to missing IO::File module on Windows.
• Fixed file test failure for the Oracle engine on Windows.
• Fixed bug where namespace-autoclean: 0.16 caused errors such as "Invalid object instance: 'yellow'".

What is new in version 0.992:

• Fixed target test failures on Windows.
• Added support for Postgres-XC to the PostgreSQL engine. Sqitch registry tables are distributed by replication to all data nodes.
• Added support to MariaDB 5.3 and higher to the MySQL engine.

What is new in version 0.991:

• Eliminated "use of uninitialized value" warnings when database connections fail.
• Reduced the minimum required DBD::Firebird to v1.11.
• Fixed the `--verbose` option to the `target` command.
• Eliminated more user-configuration issues in tests, thanks to chromatic.
• Fixed test failures when the `$PGPASSWORD` environment variable is set.

What is new in version 0.980:

• Removed the special-case handling of the user's full name fetched from the system on OS X.

What is new in version 0.973:

• Now Require DBD::SQLite compiled with SQLite 3.7.11 or higher. It always has, but now it throws a meaningful exception if an older version is compiled into DBD::SQLite.

What is new in version 0.970:

• Added the project name in a header to the output of the `plan` command.
• Added the Oracle engine.
• Added `sqitchtutorial-oracle.pod`, a Oracle-specific variant of `sqitchtutorial.pod`.

What is new in version 0.965:

• Fixed failing test due to line-ending character variations on Windows.
• Replaced all uses of `$/` in output to `"\n"`.
• Fixed build error that prevented installation on Perl 5.10 when the parent module was not installed.

What is new in version 0.964:

• Removed DBD::SQLite from the list of build dependencies.
• Fixed test failures due to encoded (wide-character) warnings on triggered on systems with non-english locales.
• Removed overriding of Throwable's `previous_exception` in App::Sqitch::X on Throwable 0.200007 and higher, where it is no longer needed.
• Changed test comparing file contents that fails on Windows to do a looser comparison and hopefully fix the test failure.

What is new in version 0.960:

• The `rebase` command no longer fails if the database is already reverted, but just makes a note of it and goes on to the deploy.
• Added the `plan` command. It's like `log`, but shows a list of changes in the plan, rather than events recorded in the database.
• Added `search_changes()` to Plan. Used by the `plan` command.
• Added the `--oneline` option to the `log` command.
• Allow tagging of an arbitrary change, not just the last change in the plan, by passing a change specification (name, ID, or tag) as the second argument to the `tag` command.
• Updated error messages to note that blank characters are not allowed in project, change, or tag names.

What is new in version 0.953:

• Fixed test failure in `t/engine.t` triggered by a clock tick.
• Changed the verify template to end with `ROLLBACK` rather than `COMMIT`. This it to encourage folks to make no lasting changes in verify tests.
• Fixed exception triggered on an attempt to revert or rebase `--to` a change that does not exist in the database.
• Added recommendation for Pod::Simple to the build process.
• Added the `--etcdir` build option to specify the directory in which configuration and template files should be installed. Defaults to the `etc/sqitch` subdirectory of the `--prefix`, `--install_base`, or Perl's prefix.
• Added the `--installed_etcdir` build option. This is used to set the location of the system etc directory. Defaults to the value of `--etcdir`.

Limitations:

• Still under development.