[twitter-dev] Re: sqllite command for writing to local DB
Bump!!? On Jan 17, 3:38 pm, Kidd wrote: > Hello all, > > I'm trying to capture data from twitter and write it to a local > sqlite3 DB. Can anyone help with a command for this? > > I am also a newbie so I wouldn't assume anything when explaining. > > thanks
[twitter-dev] sqllite command for writing to local DB
Hello all, I'm trying to capture data from twitter and write it to a local sqlite3 DB. Can anyone help with a command for this? I am also a newbie so I wouldn't assume anything when explaining. thanks
[twitter-dev] Re: Twitter with Google Visualization
So if I wanted to access tweets from a year ago how would I do that? Does twitter offer development access or is this where we would need to write to a new database for extended trending? thanks On Jan 9, 4:45 pm, Mark McBride wrote: > Twitter search keeps a limited amount of data (limited by time, fairly > short window). > The tweets however are kept indefinitely. Currently we only support > accessing the last 3200 of them via the web and API > > ---Mark > > http://twitter.com/mccvOn Sat, Jan 9, 2010 at 3:32 PM, Kidd > wrote: > > HI Peter, > > > Ok, so what I understand you saying is that Twtiter only keeps 7 days > > or 3200 results available per person? So if I want trending over time > > (more than 7days) I'm going to have to call that data and then store > > it in a DB? > > > Right now I am dabbling in Python as a way to retrieve, parse and > > write data. > > > thanks > > jason > > > On Jan 7, 4:52 pm, Peter Denton wrote: > >> Hi Kidd > >> Main reason to localize the data is for user experience. > >> If twitter search slows down, you may have page loads waiting for the > >> content you need. Also, you will get only 3200 results, or a historical > >> snapshot of 7 days from a query, so you run the risk of losing data > >> outside. > >> It all depends on what data you need for how long. > > >> Now, if twitter search data on the fly works good, you basically need to > > >> 1. retrieve the data from twitter search (probably json) - I use jQuery so > >> it would be something like thishttp://docs.jquery.com/Ajax/jQuery.ajax > > >> 2. parse the response result, convert it to proper JSON google > >> visualizations wants for consumption to create a > >> "google.visualization.DataTable" > > >> 3. create a "view" of the data table, specifying the information you want > >> to > >> display on the graph > > >> 4. create the visualization (areaImageChart, annotatedTimeline, etc) > > >> Here is an example from Google where the JSON is hardcoded, but aside from > >> getting and parsing the data from twitter, this should show you what you > >> need.http://www.mail-archive.com/google-visualization-...@googlegroups.com... > > >> Cheers > >> Peter
[twitter-dev] Re: Twitter with Google Visualization
HI Peter, Ok, so what I understand you saying is that Twtiter only keeps 7 days or 3200 results available per person? So if I want trending over time (more than 7days) I'm going to have to call that data and then store it in a DB? Right now I am dabbling in Python as a way to retrieve, parse and write data. thanks jason On Jan 7, 4:52 pm, Peter Denton wrote: > Hi Kidd > Main reason to localize the data is for user experience. > If twitter search slows down, you may have page loads waiting for the > content you need. Also, you will get only 3200 results, or a historical > snapshot of 7 days from a query, so you run the risk of losing data outside. > It all depends on what data you need for how long. > > Now, if twitter search data on the fly works good, you basically need to > > 1. retrieve the data from twitter search (probably json) - I use jQuery so > it would be something like thishttp://docs.jquery.com/Ajax/jQuery.ajax > > 2. parse the response result, convert it to proper JSON google > visualizations wants for consumption to create a > "google.visualization.DataTable" > > 3. create a "view" of the data table, specifying the information you want to > display on the graph > > 4. create the visualization (areaImageChart, annotatedTimeline, etc) > > Here is an example from Google where the JSON is hardcoded, but aside from > getting and parsing the data from twitter, this should show you what you > need.http://www.mail-archive.com/google-visualization-...@googlegroups.com... > > Cheers > Peter
[twitter-dev] Re: Twitter with Google Visualization
Hi Peter, Thanks for the response. I'd like to calculate on the fly. I'm not sure there's a reason to rewrite data that already exists on the twitter servers. The only issue would be if there services weren't available. I'm just trying to figure out how to access twitters data on the fly. Any other ideas? thanks jason On Jan 6, 4:16 pm, Peter Denton wrote: > Hi Kidd, > Many ways to do this depending on a) do you want to store the data > somewhere, calculate things, then show the data in a visualization or b) > calculate on the fly. > > One thing you might consider is writing to a google spreadsheet the data you > get back from your twitter query. You can use this instead of a DB. > You can then write very simple queries to the spreadsheet and rapidly > produce a visualization, among many other cool things. Also, there are a ton > of cool functions built into spreadsheets so you can do a lot of nifty math > on the server, then just call results using GQL from the client. > > see:http://code.google.com/apis/visualization/documentation/querylanguage... > > Cheers > Peter > > On Wed, Jan 6, 2010 at 3:46 PM, Kidd wrote: > > Hi, > > > I'm trying to visualize some data with google visualization and trying > > to do so without writing another new table. I want to pull the data > > directly from twitter using their API and then visualize that data. > > And any data that comes in after would be updated on-screen. > > > Similar to this.http://www.wattvision.com/house/live?h=263951 > > > I'd add some additional views later. > > > thanks
[twitter-dev] Twitter with Google Visualization
Hi, I'm trying to visualize some data with google visualization and trying to do so without writing another new table. I want to pull the data directly from twitter using their API and then visualize that data. And any data that comes in after would be updated on-screen. Similar to this.http://www.wattvision.com/house/live?h=263951 I'd add some additional views later. thanks
[twitter-dev] Installing Modules
I'm new to python and just want to install the twitter module, but no one on here explains how, probably because this is a common function for veterans. How do I install this or any module? I've downloaded the tar file to my downloads folder on my mac. thanks