in reply to Perl, SQLite3, and Parsing the Chatterbox Feed.

um, two comments..

  1. You're parsing XML with a regex. Tsk! Tsk!. You should know better than that :p
    Use a proper XML parser such as XML::Twig or XML::Simple.
  2. Given that you're creating a CB history, wouldn't you think it a good idea to include a date/time field in your database? ;)

Cheers,
Darren :)

  • Comment on Re: Perl, SQLite3, and Parsing the Chatterbox Feed.

Replies are listed 'Best First'.
Re^2: Perl, SQLite3, and Parsing the Chatterbox Feed.
by jrsimmon (Hermit) on Feb 14, 2008 at 15:44 UTC
    I'd like to second both of these suggestions, as well as add a couple of my own...

    Have you considered parsing the posts for links in the CB? I imagine it would lend itself to some very interesting correlations down the road:
    "What percentage of posts link to cpan?
    Which Monk links to his/her scratchpad most often?
    etc..."

    To make this really work well, you would definately need at least a time value as suggested already (and if you plan to keep more than 24 hours worth of data, a date value will be necessary as well).
[reply]

In Section Seekers of Perl Wisdom