fix: comprehensive error handling, UI fixes, and transaction protection

fix: add database migrations at container startup and deployment tests