I'm positive that a third party was providing a tql api for their database of tweets and that it was announced on this list but now searching returns nothing. Does anybody else remember this? Maybe it was a dream...
On Sun, Mar 22, 2009 at 15:28, Zac Bowling <zbowl...@gmail.com> wrote: > > I would love it if Twitter would develop an equivalent to Facebook's > FQL, Yahoo's YQL, Amazon's SimpleDB, or Google's GQL (used for app > engine data storage). > > Basically an abstracted SQL-like query engine for doing queries and > getting back data the data you want using virtual tables of different > data twitter serves up. > > You could do something basic like: > > SELECT StatusID, UserID, Text FROM StatusUpdates as S > WHERE > S.UserID in (SELECT UserID FROM SocialGraph WHERE FollowerUseringID > = MYUSERID) and > S.StatusID > LASTID > ORDER BY S.StatusID DESC > LIMIT 200 > > to get a basic user's following timeline or whatever. From there you > can build on from that and get a bit more complex. > > It could even build on from just query syntax to modify and destructive > calls. > > Maybe something like: > DELETE FROM StatusUpdates WHERE StatusID = 200102; > > or: > INSERT INTO StatusUpdates(text,replyToStatusID,replyToUserID) VALUES > ('@johnsmith hello',123601020,235133); > > or: > UPDATE StatusUpdates SET favorite = TRUE WHERE StatusID = 123601020; > > You could do it where you do an HTTP get/post with a query like above > to twitter's rest api, and the results could come back as JSON or XML > or whatever. > > Some concepts like this could be done in a local side wrapper (like > I've seen a SQL bridge for MSSQL for twitter on here a while back) but > it would be awesome if these were processed twitter server side. If > done right, it can save on overhead on both twitter and from the > client side. > > Like in one case I have where I'm hitting the following timeline, I'm > missing something out of the user structure that you get back from > that, so I turn around and do another user call on user for each tweet > to get that data. Half the data I get back in both cases don't use on > both calls but it would be awesome to be able to get that data in one > call. > > A lot to consider around optimization and limits and a bit of work to > build it but I think something like that would be really useful. > > > Zac > -- Abraham Williams | http://the.hackerconundrum.com Web608 | Community Evangelist | http://web608.org This email is: [ ] blogable [x] ask first [ ] private. Sent from: Madison WI United States.