Skip to content

Releases: vmvarela/sql-pipe

v0.9.0

10 May 11:53
ede09fe

Choose a tag to compare

🚀 Features

  • --disk flag — use a file-backed SQLite temp database instead of :memory:, enabling datasets larger than available RAM. Also sets PRAGMA temp_store = FILE for transient structures. (#148)
  • --json-path <path> flag — navigate to a nested JSON array before querying, using a dot-separated path (e.g. results.items). Works with queries, --columns, and --validate. Requires -I json. (#151)

🐛 Bug Fixes

  • XML parser now verifies that nested closing tags match their opening tag names and exits with a clear error on mismatch (#149)

⚡ Performance

  • Replaced byte-by-byte takeByte() loops with bulk block reads (allocRemaining) in XML and JSON input loading — significantly faster on large files (#150)

🧰 Maintenance

  • Modularized source into dedicated modules: format, args, sqlite, loader, modes (#146)
  • Eliminated code duplication and simplified core patterns across the codebase (#147)

📝 Documentation

  • Added --xml-root / --xml-row usage examples to --help text, man page, and README (#152)

Full Changelog: v0.8.1...v0.9.0

v0.8.1

08 May 07:57
e8cbd32

Choose a tag to compare

What's Changed

🐛 Bug Fixes

  • fix: make --xml-root and --xml-row work for XML input parsing (#140) @vmvarela

Full Changelog: v0.8.0...v0.8.1

v0.8.0

07 May 15:21
adbc99d

Choose a tag to compare

🚀 Features

  • Add XML input and output format support — --input xml / --output xml (#133)
  • Support multi-character input delimiters — e.g. --delimiter '||' (#132)
  • Add --sample <n> flag for quick data preview with schema (#131)
  • Add --validate mode to check input syntax without running a query (#130)
  • Add --silent / -s flag to suppress row count output (#129)

🧰 Maintenance

  • Fix CI: pass -Dbundle-sqlite=true to unit-test step (#137)
  • Fix DNF5 compatibility: replace dnf config-manager --add-repo with curl (#126)

📝 Documentation

  • Add real-world examples and JSON/NDJSON input documentation (#128)

Full Changelog: v0.7.1...v0.8.0

v0.7.1

01 May 15:26
16081e9

Choose a tag to compare

What's Changed

  • chore: remove redundant in-repo Nix and AUR packaging files (#125) @vmvarela
  • feat(packaging): centralize package repositories by package manager (#124) @vmvarela

Full Changelog: v0.7.0...v0.7.1

v0.7.0

01 May 09:20
171129f

Choose a tag to compare

What's Changed

🚀 Features

  • feat: add JSON and NDJSON input/output format support (#118) @vmvarela
  • feat: add TSV input and output format support (#120) @vmvarela

🧰 Maintenance

  • chore: fix release-drafter duplicate entries across categories (#119) @vmvarela

Full Changelog: v0.6.0...v0.7.0

v0.6.0

29 Apr 15:58
eeb626d

Choose a tag to compare

🚀 Features

  • Add --output <file> flag to write query results to a file (#115)
  • Add --columns flag to list CSV input column names (#113)
  • Progress indicator during CSV loading (#112)
  • Print row count after loading CSV (#111)
  • Improve SQL error messages with column context and did-you-mean hint (#110)
  • Add --max-rows flag to limit input size (#109)

🐛 Bug Fixes

  • Warn on duplicate column names in CSV header (#105)
  • Include man page in generated Homebrew formula (#101)

🧰 Maintenance

  • Consolidate Homebrew publishing to vmvarela/homebrew-tap (#107)

⬆️ Dependency Updates

  • Bump toshimaru/auto-author-assign from 3.0.1 → 3.0.2 (#108)
  • Bump KSXGitHub/github-actions-deploy-aur from 4.1.2 → 4.1.3 (#106)

Full Changelog: v0.5.0...v0.6.0

v0.5.0

15 Apr 07:16
75ff138

Choose a tag to compare

What's Changed

🧰 Maintenance

  • fix: warn on duplicate column names in CSV header (#105) @vmvarela
  • fix: apply RFC 4180 quoting to CSV output fields (#104) @vmvarela

Full Changelog: v0.4.1...v0.5.0

v0.4.1

07 Apr 09:50
7e245fe

Choose a tag to compare

What's Changed

  • chore(deps): bump KSXGitHub/github-actions-deploy-aur from 4.1.1 to 4.1.2 (#103) @dependabot[bot]
  • fix(ci): include man page in generated Homebrew formula (#101) @vmvarela
  • ci: fix release-drafter duplicate entries and label/prefix mismatch (#79) @vmvarela

Full Changelog: v0.4.0...v0.4.1

v0.4.0

20 Mar 01:00
b35f8bb

Choose a tag to compare

🚀 Features

  • Add --json output flag — results as a JSON array of objects (#74)
  • Add Alpine Linux .apk packages to release workflow (#75)

🧰 Maintenance

  • Add integration tests for --delimiter, --tsv, and --header flags (#73)
  • Update docs: --json flag and Alpine APK install instructions (#77)
  • Fix Nix CI: update job was pushing directly to master, blocked by branch protection (#63)
  • Auto-remove status:* labels on issue close via GitHub Actions (#43)

⬆️ Dependency Updates

  • Bump release-drafter/release-drafter from 6 to 7 (#72)

Full Changelog: v0.3.1...v0.4.0

v0.3.1

15 Mar 11:52
f40f31d

Choose a tag to compare

What's Changed

  • chore(nix): update versions.json to v0.3.0 (#64) @vmvarela

Full Changelog: v0.3.0...v0.3.1