Cool project. That database schema is ridiculous though.
The script creates a set of tables for each newsgroup it finds, containing headers, body, from, to, etc... Why has he done this? This could be contained in only two tables: One table containing group information, another containing the posts. He also hasn't used any foreign key constraints, which begs the question of why using SQL at all if you're not going to take advantage of its best features.
Is there a link to the actual resulting sql database dump to save the many hours of running this script?
I had the idea to look and see what people were saying about Chernobyl at the time, but want to add my own search constraints and play with other data in a way that is difficult to do on the usenetarchives site.
3 comments
[ 0.19 ms ] story [ 611 ms ] threadhttps://dgraph.io/
The script creates a set of tables for each newsgroup it finds, containing headers, body, from, to, etc... Why has he done this? This could be contained in only two tables: One table containing group information, another containing the posts. He also hasn't used any foreign key constraints, which begs the question of why using SQL at all if you're not going to take advantage of its best features.
I had the idea to look and see what people were saying about Chernobyl at the time, but want to add my own search constraints and play with other data in a way that is difficult to do on the usenetarchives site.