Retrospective: Sprint 2

[vmvarela]

Sprint Goal

Make sql-pipe installable — ship the man page, Homebrew tap, AUR package, and shell installer so any developer can onboard in seconds.

What went well?

• 100% completion rate again (6/6 issues), matching Sprint 1 velocity. Consistent throughput across sprints.
• All 4 action items from Sprint 1 retrospective were addressed: installation packages (Homebrew Homebrew tap for macOS and Linux installation #20, AUR AUR package for Arch Linux #21, install.sh Shell installer script (install.sh) #23), man page (Man page (man 1 sql-pipe) #22), and both feature issues (Custom delimiter support (--delimiter / --tsv) #9, Output header row option (--header / -H) #10). The retrospective loop is working.
• Sprint Goal fully achieved. sql-pipe is now installable via Homebrew (brew install vmvarela/tap/sql-pipe), AUR, and a curl-pipe-sh installer, with a proper man page (man sql-pipe).
• Release v0.2.0 shipped with 15 platform binaries + sql-pipe.1.gz man page. Cross-platform coverage is excellent (Linux, macOS, Windows, FreeBSD, NetBSD, ARM, RISC-V, x86).
• Feature work (Custom delimiter support (--delimiter / --tsv) #9 delimiter, Output header row option (--header / -H) #10 header) was clean and well-scoped. PR feat: add custom delimiter support (-d/--delimiter, --tsv) #30 (delimiter) touched 5 files / 260 additions and PR feat: add --header / -H flag for output column names #31 (header) touched 2 files / 83 additions — reasonable change sizes.
• Dependabot PRs (chore(deps): bump actions/cache from 4 to 5 #32–chore(deps): bump actions/download-artifact from 4 to 8 #36) were merged promptly, keeping CI dependencies up to date.
• Release Drafter is working — v0.2.1 draft is already accumulating changes automatically.

What could be improved?

• All 6 issues closed on the same day (March 3). This suggests batch delivery rather than continuous flow. Ideally, issues should be worked and closed over the sprint duration for smoother progress.
• Closed issues still carry status:ready labels instead of having status labels removed on completion. The workflow should clean up status labels when closing issues.
• Sprint 3 backlog is thin — only 2 issues (Scoop bucket for Windows installation #24 Scoop, Nix package / NixOS derivation #25 Nix). Consider adding more backlog items (new features, improvements) to ensure enough work is planned.
• No automated tests for new features. The delimiter and header features (Custom delimiter support (--delimiter / --tsv) #9, Output header row option (--header / -H) #10) were shipped without dedicated test coverage. The build.zig integration tests were added (PR ci: add Zig cache and build.zig integration tests #16), but feature-specific regression tests are missing.

Action items for next sprint

• Clean up status:* labels when closing issues (remove status:ready or status:in-progress on close)
• Add backlog items beyond packaging — consider user-facing features, error handling improvements, or performance work
• Consider adding feature-level tests for delimiter and header options

Metrics

• Sprint Goal: Make sql-pipe installable
• Planned: 6 issues
• Completed: 6 issues (100%)
• Carried over: 0 issues
• Sprint Goal met: Yes
• Release: v0.2.0
• PRs merged: 11 (6 feature/docs + 5 dependabot)
• Lines changed: +499 / −73 (feature PRs only)

Completed issues

• Custom delimiter support (--delimiter / --tsv) #9 Custom delimiter support (--delimiter / --tsv) — size:xs
• Output header row option (--header / -H) #10 Output header row option (--header / -H) — size:xs
• Homebrew tap for macOS and Linux installation #20 Homebrew tap for macOS and Linux installation — size:s
• AUR package for Arch Linux #21 AUR package for Arch Linux — size:s
• Man page (man 1 sql-pipe) #22 Man page (man 1 sql-pipe) — size:s
• Shell installer script (install.sh) #23 Shell installer script (install.sh) — size:xs