Process datafeed in one MySql table and output to another MySql table

[Sam]

I have a datafeed which is constantly sent to a MySql table. The table grows constantly as the data feeds in. I would like to write a python script which process the data in this table and output the processed data to anothertable in another MySql database in real-time.

Which are the python libraries which are suitable for this purpose? Are there any useful sample code or project on the web that I can use as reference? Thank you.

 

[Denis McMahon]

I have a datafeed which is constantly sent to a MySql table ...

Which are the python libraries which are suitable for this purpose? Are
there any useful sample code or project on the web that I can use as
reference?

Did you search for mysql on the python docs website, or perhaps try
googling "python mysql"?

 

[Jason Friedman]

I have a datafeed which is constantly sent to a MySql table. The table
grows constantly as the data feeds in. I would like to write a python
script which process the data in this table and output the processed data
to another table in another MySql database in real-time.

Which are the python libraries which are suitable for this purpose? Are
there any useful sample code or project on the web that I can use as
reference? Thank you.

Is there a reason you do not want to move these rows with a mysql command?
drop table if exists temp;
insert into temp select * from source where ...;
insert into target select * from temp;
delete from source where id in (select id from temp);

 

[Sam]

Did you search for mysql on the python docs website, or perhaps try

googling "python mysql"?

I did. There were documentation but I was hoping to have more sample code. Preferably a similar project which I can use as reference.

 

[Mark Lawrence]

I did. There were documentation but I was hoping to have more sample code. Preferably a similar project which I can use as reference.

Would you please read and action this
https://wiki.python.org/moin/GoogleGroupsPython to prevent us seeing the
double line spacing above, thanks.