I would like this software to be developed for Windows using Python. I want to store tweets only from New York and London using Python and Twitter Streaming API. The tweets have to be stored on a MySQL database.
The database should store the following information about every tweet.
tweet_id, user_id, tweet text, coordinates, created_at, place, retweet_count, favorite_count.