> Should be doable with bash's PROMPT_COMMAND if you are still on bash

Already done, with also PS0 and a sqlite backend: https://github.com/csdvrx/bash-timestamping-sqlite