db transactions and more stable subscription updating