gitsqlite

danielsiegl · danielsiegl.gitsqlite

smudge/clean/diff git filters for checking in sqlite3 databases as text into git

https://github.com/danielsiegl/gitsqlite/

winget install --id danielsiegl.gitsqlite --exact --source winget

Latest 0.9.1

Release Notes

Trying to fix winget problem Full Changelog: v0.9.0...v0.9.1 📦 gitsqlite Release A Git clean/smudge/diff filter for storing SQLite databases in plain text SQL, enabling meaningful diffs and merges. There are several benefits over using sqlite3 .dump directly:

  • byte-by-byte equal across windows/linux/mac
  • Consistent float rounding (deterministic dumps).
  • Strip SQLite’s internal/system tables from dumps.
  • Temp-file I/O for robustness (vs fragile pipes).
  • handles broken pipes with Git Gui Clients
  • easier to deploy and maintain in an organization - eg: winget for windows
  • Optional: logging for diagnostics Quick Start
  1. Download the appropriate binary for your platform and make sure it is reachable from Git Bash (Path)

    Example for Windows

    winget install danielsiegl.gitsqlite

    curl -L -o gitsqlite.exe https://github.com/danielsiegl/gitsqlite/releases/latest/download/gitsqlite-windows-amd64.exe

  2. Install SQLite 3: winget install SQLite.SQLite (Windows) or sudo apt install sqlite3 (Linux)
  3. Configure Git filters: echo '*.db filter=gitsqlite' >> .gitattributes

    echo '*.db diff=gitsqlite' >> .gitattributes

    git config filter.gitsqlite.clean "gitsqlite clean" git config filter.gitsqlite.smudge "gitsqlite smudge"

    git config diff.gitsqlite.textconv "gitsqlite diff"

Available Binaries

  • Windows: gitsqlite-windows-amd64.exe, gitsqlite-windows-arm64.exe
  • Linux: gitsqlite-linux-amd64, gitsqlite-linux-arm64
  • macOS: gitsqlite-macos-arm64 📖 Full documentation: README.md

Installer type: portable

Architecture Scope Download SHA256
x64 Download 5BD2684987CF8A16973B95A007A675B968B7EA58E6D3BF9104D36B7E3D4ABE29

Details

Homepage
https://github.com/danielsiegl/gitsqlite
License
BSD-2-Clause
Publisher
danielsiegl
Support
https://github.com/danielsiegl/gitsqlite/issues

Older versions (4)

0.8.0
Architecture Scope Download SHA256
x64 Download 96FC720EF9C73BC0CC2F335915741291E6AB4A5E7366C3748EC86344ABA099A5
0.7.9
Architecture Scope Download SHA256
x64 Download A37BDAC6D192D2CF9D14D7C37BE19E8E02A80C01B987ACC7CE404B99CCCFC4A0
0.7.8
Architecture Scope Download SHA256
x64 Download 363A5D64DA4F0B1D18637B82FE8CB241B0A62A21970E77916307269E57A76CBD
0.7.2
Architecture Scope Download SHA256
x64 Download BA5D6AC7C8B9A1734DC7039175286160CB198FF71F8BB9BC7CE6401155BDEC00