dump_tweets.R a tool for saving tweets and user data to a database


  dump_tweets.R is a tool for  searching tweets and (recursively) crawl users from twitter: Data are then saved to a MySQL database and can finally be exported to .RData files dump_tweets.R is sponsorized by Associazione Rospo       Example:

Rscript search.R -q “#opensource”

2014-01-20 20:53:43 INFO::Connecting to TWITTER… 2014-01-20 20:53:43 INFO::Connecting to database=twitter, host=localhost with user=root 2014-01-20 20:53:43 INFO::using UTF8 code 2014-01-20 20:53:43 INFO::Searching for q=#opensource, sinceID=0 2014-01-20 20:53:57 INFO::Found 191 tweets 2014-01-20 20:53:57 INFO::maxID=425355265857187841 2014-01-20 20:53:57 INFO::Saving data to tweet table… 2014-01-20 20:53:58 INFO::saving data to search_results table…

Enter your instance's address

More posts like this

Exporting database tables to csv files with Apache Camel

2019-05-24 | #apache #camel #database

Below the interested part of code using spring xml <bean id="ds-patriot-dw_ro" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="oracle.jdbc.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@//patriot.redaelli.org:1111/RED"/> <property name="Username" value="user"/> <property name="Password" value="pwd"/> </bean> <camelContext id="MyCamel" streamCache="true" xmlns="http://camel.apache.org/schema/spring"> <route id="scheduler"> <from uri="timer:hello?

Continue reading 