1. don't store binary files in Git 2. don't run programs that keep a git file open for too long, otherwise clowntown. For example, you run git pull while GnuCash keeps the file open and then you loose all your updates when you save (also a problem with the code below, but fixable).

The correct solution to this is running the "smudge" and "clean" operations as a backup and restore operation, outside the repo, when starting and closing GnuCash, in this case:

```

#!/bin/bash

cat $1.sql > $1.sqlite3

gnucash $1.sqlite3

echo ".dump" | sqlite3 $1.sqlite3 > $1.sql

# optionally:

# git add $1.sql

# git commit -m "Update $(date) $1.sql"

```