Skip to content

Python3 daemon that logs tweets by keywords and saves them in a MySQL data base

License

Notifications You must be signed in to change notification settings

epieffe/tweet-logger

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Please Note:

This program had been running for two weeks from 02/18/2018 untill 05/04/2018 on a raspberry pi 3 logging tweets regarding Italian political elections. Detailed results will be published soon. We experimented some random crashes with the tweepy API and we suspect it is excessively memory consuming. We lost some tweets due to this crashes, but we had been offline for less than 36 hours overall (also for some hardware related problems). We would like to reimplement the tweet_logger module using a different twitter API, but the developer is into other stuff right now :)

What this program does

this is a python daemon that logs tweets corresponding to certain keywords in real time using Twitter Streaming API. You can set your keywords in the config.py file. Tweets are stored using a DBMS. You can set the DBMS you want to use in the config.py file. Currently only MySQL is supported, but it's very easy to bring support for other RDMBS, you just have to provide a different DBConnection interface implementation. (see the docs) The program only purpose is to store Tweets on the DB, there's no option to visualize them in the program, you will have to write custom SQL or use phpmyadmin to visualize them and eventually extract statistics

How to setup

  • create Twitter account

  • create Twitter application at: https://apps.twitter.com/

  • install Python3 and MySQL

  • install Python dependncies:

    pip install tweepy

    pip install mysqlclient

  • create db tables. the db tables sql is in file db.sql, you can import it with phpmyadmin

  • edit config.py file adding Tweeter API and MySQL authentication data

  • run

    python3 run.py

    once the program is started the only way to stop it is with KeyboardInterrupt (ctrl + c).

    Documentation

    in the folder doc there's a pdf file that explains how the program is structured in case you want to change stuff or add new features. For any help or info feel welcome to contact me at: ferrariepifanio@gmail.com

About

Python3 daemon that logs tweets by keywords and saves them in a MySQL data base

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages