Evan Martin (evan) wrote in evan_tech,
Evan Martin
evan
evan_tech

lj comments

LJ lets you export your comments now:

sqlite> select u.username,c.body from user u, comment c where c.commentid=(select max(commentid) from comment) and u.userid=c.posterid;
xaosenkosmos|<i> but I think I'm still paying the internet time bill.</i>\n\nSee also: <a href="http://en.wikipedia.org/wiki/Anthropic_principle">The Anthropic Principle</a> in light of the existence of the parent post ;^)


% ls -l comments.db
-rw-r--r-- 1 martine martine 10763264 2004-03-29 09:28 comments.db

Having them in a database is much more fun than LogJam's XML export:

sqlite> select avg(length(body)) from comment;
234.04325931319
sqlite> select length(c.body),c.jitemid,u.username,c.commentid from comment c, user u where length(c.body)=(select max(length(body)) from comment) and u.userid=c.posterid;
4271|2466|housepet|13530


Unfortunately, I don't think I can map from a jitemid to a URL without a journal export beside it. (And even that may not include the anum...?)
So now: use my C-based liblivejournal export and write an SQLite backend? Or use my ML-based SQLite and write a journal export?
Subscribe

  • your vcs sucks

    I've been hacking on some Haskell stuff lately that's all managed in darcs and it's reminded me of an observation I made over two years ago now (see…

  • perl people, explain your language to me

    Every time I use perl I feel mildly positive about it right up until I encounter CPAN. I've never managed to make CPAN work, despite the multitude of…

  • dns attack of doom

    If I've learned anything from the new Kaminsky DNS attack, it's that if you want to keep something a secret while disclosing to a trusted subset of…

  • Post a new comment

    Error

    default userpic
    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 2 comments