It is really easy to screw up database programming when writing Python scripts when autocommit is set to false and you forget to commit select queries and hold the transaction open so that it eventually blocks by holding locks.
I've found setting autocommit to true and using...
Conversation
context managers for cursors is a good way to avoid situations where you might accidentally maintain open transactions from things like select where committing after a select isn't always intuitive.