I'd upgrade, but I'm staying at whatever version CentOS needs as the package manager yum and other important system utilities depend on Pyton.
I tried installing pysqlite2, both from binaries and from source. I get errors whenever I require it in Python, though. Could you go ahead and try and see if you get the same errors?