Archives Aug. 16, 2004
Multi-threading with PyPgSQL can be a serious PITA (Another few hours tracking down hangs due to a missing commit...)
Last update on .
Full-featured databases tend to have low-level locking mechanisms such that if a particular thread or client has modified a row in one transaction, then attempts to reference that row in other transactions are blocked. When your database interface (e.g. PyPgSQL) doesn't allow for sharing transactions between threads, you can (when a problem occurs) wind up ...