News for hackers. Stuff that matters.
Re:Ask PG: Karma Data Dump by zck on Monday September 14, 2009 @03:33PM (#822425)
There's no database for HN. Everything is saved as text files. The save-votes function (line 133 of news.arc), which writes out the hash table of a user's votes to a file, is as follows:

(def save-votes (u) (save-table (votes* u) (+ votedir* u)))

So the data could be gotten as a zip, but not a SQL dump.

Re:Ask PG: Karma Data Dump by kqr2 on Monday September 14, 2009 @05:19PM (#822642)
Interesting. If HN ever decides to go the database route, sqlite might be a good fit since it's relatively simple and everything is stored as a single file.
Re:Ask PG: Karma Data Dump by benhoyt on Monday September 14, 2009 @05:54PM (#822694)
PostgreSQL stores everything in flat files too (on Windows, in a directory like "C:\Program Files\PostgreSQL\8.1\data\base\100929"), and I'm guessing MySQL would too.
Re:Ask PG: Karma Data Dump by mahmud on Monday September 14, 2009 @11:01PM (#823187)
Are you nutts!? sqlite LOCKS the entire database for every update!