SQL Transactions Hell: What can go wrong and how to get out of it [ukr]

The world of SQL transactions seems simple — until the doors to real “hell” swing open: deadlocks, locks, mysterious timeouts, and long-running transactions that paralyze your system. In this talk, I’ll show how this hell emerges, how to recognize it using database tools, and how to fight it effectively in practice. We’ll break down common failures, isolation levels, ORM antipatterns, the behavior of long transactions, and best practices for surviving in high-load environments. You’ll see that there is a way out of transaction hell — you just need to know where to find the fire extinguisher.