sgi newsgroups

Open discussion on or around SGI; software/hardware related posts should go in the appropriate subforum.
Forum rules
Any posts concerning pirated software or offering to buy/sell/trade commercial software are subject to removal.
User avatar
Posts: 6704
Joined: Mon Apr 14, 2003 4:34 am

sgi newsgroups

Unread postby foetz » Sun Mar 22, 2015 10:37 pm

some things are worth being preserved and one of them are the newsgroups. so as a little weekend project i put all sgi related newsgroups except for marketplace into mysql. cut off date is somewhere in 2006. the fields are:
  • from
  • subject
  • date
  • msg

all fields are indexed (msg as fulltext) and all rows have the usual autoincrement id as primary key.
the dates are converted to proper sql dates and to the actual content i applied the following changes:
  • trailing blanks removed
  • number of consecutive blank lines limited to 2
  • quoted-printable content converted
  • empty mails skipped
  • subjects are cut off by "..." if they exceed 128 chars

if that sounds handy to you you're welcome to download the sql dumps there:

Code: Select all

User avatar
Posts: 3396
Joined: Mon Jun 06, 2005 9:53 pm
Location: New England, USA

Re: sgi newsgroups

Unread postby josehill » Mon Mar 23, 2015 4:08 am

Thanks, foetz. Good idea.

Posts: 1001
Joined: Tue Sep 20, 2005 5:10 pm
Location: IRL

Re: sgi newsgroups

Unread postby kramlq » Mon Mar 23, 2015 1:12 pm


Return to “SGI: Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest