Sqitch
No Change
assess
Sqitch. Is a standalone database change management tool.
Summary
Garden stance: We assess Sqitch for our estate.
Key points:
| Topic | Notes |
|---|---|
| Engines | Postgres, SQLite, MySQL, Oracle, Firebird, Vertica, Exasol, Snowflake, ODBC (feature flags at build time) |
| Layout | sqitch.plan, deploy/, revert/, verify/ directories per project |
| Config | sqitch.conf at project, user, or system scope (Git-like layering) |
| CI | Run sqitch deploy and sqitch verify against ephemeral or staging targets |
Practices: Keep DDL and DML in separate changes when verify tests need an empty schema. Declare cross-project dependencies when shared libraries ship their own plans. Tag before release so deployed hashes lock and scripts stop being editable.
References
Details
| Topic | Notes |
|---|---|
| Engines | Postgres, SQLite, MySQL, Oracle, Firebird, Vertica, Exasol, Snowflake, ODBC (feature flags at build time) |
| Layout | sqitch.plan, deploy/, revert/, verify/ directories per project |
| Config | sqitch.conf at project, user, or system scope (Git-like layering) |
| CI | Run sqitch deploy and sqitch verify against ephemeral or staging targets |
Practices: Keep DDL and DML in separate changes when verify tests need an empty schema. Declare cross-project dependencies when shared libraries ship their own plans. Tag before release so deployed hashes lock and scripts stop being editable.
References