>>25
The
world4ch_archiver.py script is to be run in Python, and the
world4ch_archive.db.gz file should be gunzipped and then can be opened with SQLite (
http://www.sqlite.org/download.html)
e.g.
$ sqlite3 world4ch_archive.db
SQLite version 3.5.8
Enter ".help" for instructions
sqlite> .tables
boards posts threads
sqlite> select max(date_time) from posts where board_name = 'prog';
2008-05-01 15:08
sqlite> select thread_no, post_no from posts where board_name = 'prog' and html like '%forced indentation%' order by date_time limit 1;
1138460471|12
sqlite> select board_name, count(*) from threads group by board_name order by count(*) desc;
lounge|23382
comp|7879
vip|7762
prog|5266
newpol|3662
games|3212
lang|2271
sci|2234
music|1995
anime|1977
tech|1835
newnew|1257
book|1179
img|1155
tele|875
food|640
sports|556
carcom|441
sjis|324
sqlite>