A very simple approach is to use empty marker files to make such changes visible in the filesystem. Say, dbjoin.done: database.db sqlite3 $< <<< "y

A very simple approach is to use empty marker files to make such changes visible in the filesystem. Say, dbjoin.done: database.db sqlite3 $< <<< "your query" touch $@