BeginTransaction starts a transaction and returns the new transaction along with the rollback function to be deferred.

Connect establishes a connection to the given Postgres database and returns a connection pool to be used for further access.

ResolveTransactionWithRollback acts as a failsafe, preventing any missed rollbacks from holding on to a transaction.