Try to use "twisted.enterprise.adbapi" accessing database nonblockingly in Twisted (failed)

- Download  pyPgSQL from the following website:

http://sourceforge.net/projects/mysql-python/?source=recommended

- Extract it into a file, and Install at current path:

$ sudo python setup.py install

- A nice introduction of twisted.internet.defer

http://ezyang.com/twisted/defer2.html

- Test procedure:

I am first trying to still use the old API but with non-blocking mode.

cp = adbapi.ConnectionPool("pg", dbname="mydb", host="143.89.46.81",user="dbcreator",passwd="nifti")

cp .connect()

self.conn=cp.connect()

self.conn=adbapi.ConnectionPool("pg", dbname="mydb", host="143.89.46.81",user="dbcreator",passwd="nifti")

self.conn.connect()

self.conn.query => self.conn.runQuery("SELECT age FROM users WHERE name = ?", user)

cp = adbapi.ConnectionPool("pg", dbname="mydb", host="143.89.46.81",user="dbcreator",passwd="nifti")

c=cp.connect()

c.query()

cp.runQuery()

\lo_list

- PROBLEM: how to use pypgsql to operate large object!

TRIES:

http://pypgsql.sourceforge.net/README.html

you need to check how to use large object in PypgSQL,

search for "large".

you will get to the api,

then change all related APIs in topicdb_twist.py.

(the function names are the APIs.)

STILL NOT SOLVED:

"to implement the large object operation with postgresql under pypgsql."