Read from database, write to another database, simultaneously

Sean Davis seandavi at gmail.com
Wed Jan 10 17:37:29 EST 2007


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




More information about the Python-list mailing list