How pau4o/sqitch works
Sqitch is a standalone database change-management application. Users define database-native change scripts and a plan with dependencies; Sqitch uses that plan to order changes and deploy them to a supported database engine, maintaining deployment integrity. The tree shows command, plan, target, configuration, and engine modules, but no source excerpts were provided, so internal calls and finer command relationships cannot be verified. The README documents the plan/script/deployment relationships and supported engines.
Main entry points: Engine.pm Engine interface · Plan.pm Change plan · deploy.pm Deploy command · Target.pm Database target
Components 17
Command interface
- Sqitch commands
lib/App/Sqitch/Command.pm - Deploy command
lib/App/Sqitch/Command/deploy.pm - Revert command
lib/App/Sqitch/Command/revert.pm - Verify command
lib/App/Sqitch/Command/verify.pm
Change planning
- Change plan
lib/App/Sqitch/Plan.pm - Plan changes
lib/App/Sqitch/Plan/Change.pm - Dependencies
lib/App/Sqitch/Plan/Depend.pm - Native scripts
Deployment engines
- Engine interface
lib/App/Sqitch/Engine.pm - PostgreSQL engine
lib/App/Sqitch/Engine/pg.pm - MySQL engine
lib/App/Sqitch/Engine/mysql.pm - SQLite engine
lib/App/Sqitch/Engine/sqlite.pm - Other engines
lib/App/Sqitch/Engine
Project and state
- Database target
lib/App/Sqitch/Target.pm - Configuration
lib/App/Sqitch/Config.pm
Other components
- Project user
- Database
Connections 17
- Project user → Sqitch commands: runs
README.md - Project user → Native scripts: writes
README.md - Project user → Change plan: defines
README.md - Change plan → Dependencies: declares
README.md - Change plan → Plan changes: orders
README.md - Deploy command → Change plan: uses
README.md - Deploy command → Engine interface: deploys through
README.md - Engine interface → Native scripts: executes
README.md - Engine interface → Database target: connects to
README.md - Database target → Database: selects
README.md - Engine interface → PostgreSQL engine: supports
README.md - Engine interface → MySQL engine: supports
README.md - Engine interface → SQLite engine: supports
README.md - Engine interface → Other engines: supports
README.md - Project user → Configuration: configures
- Revert command → Engine interface: reverts through
- Verify command → Engine interface: verifies through