4 ms·
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, et
by ajxs 6y ago
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.