Evan Martin (evan) wrote in evan_tech,
Evan Martin

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;
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;

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?

  • dremel

    They published a paper on Dremel, my favorite previously-unpublished tool from the Google toolchest. Greg Linden discusses it: "[...] it is capable…

  • 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…

  • google ime

    Japanophiles might be interested to learn that Google released a Japanese IME. IME is the sort of NLP problem that Google is nearly uniquely…

  • Post a new comment


    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.