I am working on a simple script to read from one database (oracle) and write to another (postgresql). I retrieve the data from oracle in chunks and drop the data to postgresql continuously. The author of one of the python database clients mentioned that using one thread to retrieve the data from the oracle database and another to insert the data into postgresql with something like a pipe between the two threads might make sense, keeping both IO streams busy. Any hints on how to get started?
Thanks, Sean -- http://mail.python.org/mailman/listinfo/python-list
