Perform database writes inside transactions to allow rollback on failure

[toasted226]

We should perform work where multiple database writes are required inside of a transaction, such that if failure occurs, the changes are rolled back. This should also be more efficient, as we don't have to create a connection for every write.

[toasted226]

A PR has been made to transactionalise analytics writes