Collecting tweets with Openfire

66 views
Skip to first unread message

Andrew Maizels

unread,
May 7, 2008, 12:12:57 AM5/7/08
to Twitter Development Talk
I have Openfire installed and I'm successfully getting a Jabber feed
from Twitter.

What I want to do is collect them in a MySQL database so that I can
easily process them with my application. Openfire has an option to
store messages that arrive when you're offline... But it doesn't seem
to do what I want. I'm guessing that as soon as I go offline, Twitter
stops sending me the Jabber feed. And if I'm online, Openfire doesn't
store the messages.

Has anyone solved this?

Tom Carden

unread,
May 7, 2008, 1:48:31 AM5/7/08
to Twitter Development Talk
There's a really simple bot library for OpenFire that you could use to
receive messages and write them to a database:
http://www.igniterealtime.org/community/docs/DOC-1130

There are helpful instructions in the comments for how to compile a
plug-in written with the bot library.

Tom.

Andrew Maizels

unread,
May 7, 2008, 10:03:16 PM5/7/08
to Twitter Development Talk
Yeah, I was hoping to get it to work without writing a bot or
something like that, but it's looking like that's the only solution.

Thanks,

Andrew

Andrew Maizels

unread,
May 13, 2008, 12:56:57 AM5/13/08
to Twitter Development Talk
Ended up writing a little bot in Python using xmpppy. Works like a
charm. Shame I couldn't get OpenFire to do it, but in the end it
wasn't that hard - except for some aggravating unicode issues with
MySQL.

Andrew

On May 8, 12:03 pm, Andrew Maizels <andrew.maiz...@gmail.com> wrote:
> Yeah, I was hoping to get it to work without writing a bot or
> something like that, but it's looking like that's the only solution.
>
> Thanks,
>
> Andrew
>
> On May 7, 3:48 pm, Tom Carden <tom.car...@gmail.com> wrote:
>
> > On May 6, 9:12 pm, Andrew Maizels <andrew.maiz...@gmail.com> wrote:
>
> > > I haveOpenfireinstalled and I'm successfully getting a Jabber feed
> > > from Twitter.
>
> > > What I want to do is collect them in a MySQL database so that I can
> > > easily process them with my application. Openfirehas an option to
> > > store messages that arrive when you're offline... But it doesn't seem
> > > to do what I want. I'm guessing that as soon as I go offline, Twitter
> > > stops sending me the Jabber feed. And if I'm online,Openfiredoesn't
> > > store the messages.
>
> > > Has anyone solved this?
>
> > There's a really simple bot library forOpenFirethat you could use to

Ed Finkler

unread,
May 13, 2008, 10:43:05 AM5/13/08
to twitter-deve...@googlegroups.com
Willing to share source? Howtos for this stuff are gold.

--
Ed Finkler
http://funkatron.com
AIM: funka7ron
ICQ: 3922133
Skype: funka7ron

Reply all
Reply to author
Forward
0 new messages