Monitor IPython SQLite history; save into plain textfile on every update

ipythonsync.sh

#!/usr/bin/env bash
# Saves todays ipython history to textfile.
# Needs inotify-tools, sqlite3

HISTORY_SQLITE="${HOME}/.config/ipython/profile_default/history.sqlite"
HISTORY_FILE="${HOME}/.config/ipython/profile_default/history.py"

if [ ! -f "${HISTORY_FILE}" ]; then
  touch "${HISTORY_FILE}"
fi

LAST_UPDATE="`date +%F` 00:00:00"

while true; do
  inotifywait -e modify "${HISTORY_SQLITE}" &&
    echo "
      select distinct(source) from history, sessions 
      where history.session = sessions.session and sessions.start > '${LAST_UPDATE}' 
      order by sessions.start;" \
      | sqlite3 "${HISTORY_SQLITE}" > "${HISTORY_FILE}"
done