Archives Aug. 16, 2004

Multi-threading with PyPgSQL can be a serious PITA (Another few hours tracking down hangs due to a missing commit...)

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 ...

Continue reading

Previous day

Aug. 14, 2004

Next day

Aug. 17, 2004