Retrospective: Sprint 3

[vmvarela]

What went well?

• All 6 packaging issues completed — DEB, RPM, Chocolatey, WinGet, Scoop, and Nix all shipped
• Sprint Goal achieved — sql-pipe is now installable on all major platforms (Linux, macOS, Windows, NixOS)
• v0.3.0 release published with clean, categorized release notes
• Housekeeping done in parallel — moved aur/ to packaging/aur/, cleaned dead sed from CI, merged 3 Dependabot PRs
• Self-review process caught a real bug — the DEB staging rewrite in PR fix: update nfpm download URL and Chocolatey license format #62 would have broken the upload step; caught during review and fixed before merge

What could be improved?

• CI packaging jobs were not tested before release — the nfpm URL change and Chocolatey license format issue only surfaced when v0.3.0 was published. No way to test packaging jobs without creating a tag.
• The Nix update job pushes directly to master — violates branch protection rules. Unlike Homebrew/Scoop (which push to separate repos), Nix updates the same repo. Filed as Nix update job fails: direct push to master blocked by branch protection #63.
• AI-generated code needs careful review — the initial PR fix: update nfpm download URL and Chocolatey license format #62 had a significant DEB staging rewrite (changing pkg-work to staging, dropping man page and LICENSE) that would have broken the job. Only caught during explicit self-review of the diff.

Action items for next sprint

• Fix Nix update job to work with branch protection (Nix update job fails: direct push to master blocked by branch protection #63)
• Consider adding a CI smoke test for packaging jobs (e.g., test with a pre-release tag)

Metrics

• Planned: 6 issues
• Completed: 6 issues (100%)
• Carried over: 0 issues
• Sprint Goal met: Yes
• Additional work: 2 housekeeping PRs (chore: move aur/ to packaging/aur/ for structural consistency #58, chore: remove dead sed strip from update-homebrew CI job #60), 3 Dependabot PRs (chore(deps): bump actions/stale from 9 to 10 #46, chore(deps): bump actions/checkout from 4 to 6 #47, chore(deps): bump KSXGitHub/github-actions-deploy-aur from 3.0.1 to 4.1.1 #48), 1 CI fix PR (fix: update nfpm download URL and Chocolatey license format #62), 1 manual Nix update PR (chore(nix): update versions.json to v0.3.0 #64), v0.3.0 release published