
Marcello: How about linking to wikipedia for those we don't have descriptions for? If that's something we're interested in, I'd even be willing to take a stab at creating new Wikipedia entries for those that don't exist in either location. Also, have we thought about making a PG wiki? It might take some of this load off of you, even if we do it as a "staged to the wiki, rolled out to 'production' on a given cycle after all changes in the current cycle have been examined by one of the following trusted people..." to prevent unsavory types from pollution the production site. I'd be more than willing to help setup, maintain, and cross-populate such, if it's something PG is interested in. Here are some wikipedia links for you to use if you so choose. If you want me to make the additional entries, just let me know. avi: http://en.wikipedia.org/wiki/.avi css: http://en.wikipedia.org/wiki/Cascading_Style_Sheets dvi: http://en.wikipedia.org/wiki/DVI_file_format eps: http://en.wikipedia.org/wiki/Encapsulated_PostScript gif: http://en.wikipedia.org/wiki/GIF html: http://en.wikipedia.org/wiki/HTML iso: http://en.wikipedia.org/wiki/ISO_image lit: http://en.wikipedia.org/wiki/Microsoft_Reader ly: http://en.wikipedia.org/wiki/GNU_LilyPond md5: http://en.wikipedia.org/wiki/MD5 mp3: http://en.wikipedia.org/wiki/MP3 mus: http://en.wikipedia.org/wiki/Finale_notation_program pdb: http://en.wikipedia.org/wiki/Palm_OS pdf: http://en.wikipedia.org/wiki/Portable_Document_Format prc: http://en.wikipedia.org/wiki/Palm_OS ps: http://en.wikipedia.org/wiki/PostScript qt: http://en.wikipedia.org/wiki/QuickTime rtf: http://en.wikipedia.org/wiki/RTF sib: http://en.wikipedia.org/wiki/Sibelius_notation_program svg: http://en.wikipedia.org/wiki/SVG tei: http://en.wikipedia.org/wiki/Text_Encoding_Initiative tex: http://en.wikipedia.org/wiki/TeX tiff: http://en.wikipedia.org/wiki/TIFF tr: http://en.wikipedia.org/wiki/TomeRaider xml: http://en.wikipedia.org/wiki/XML xsl: http://en.wikipedia.org/wiki/XSL Also, you may or may not want to apply any of the following to the database. These are brought over from the /etc/mime.types on my debian box, so apply salt to taste. [See, I can make food analogies too! ;)] update filetypes set mediatype = 'video/x-msvideo' where pk = 'avi'; update filetypes set mediatype = 'text/css' where pk = 'css'; update filetypes set mediatype = 'application/msword' where pk = 'doc'; update filetypes set mediatype = 'application/x-dvi' where pk = 'dvi'; update filetypes set mediatype = 'application/x-iso9660-image' where pk = 'iso'; update filetypes set mediatype = 'audio/midi' where pk = 'mid'; update filetypes set mediatype = 'text/plain' where pk = 'readme'; update filetypes set mediatype = 'image/svg+xml' where pk = 'svg'; update filetypes set mediatype = 'audio/x-wav' where pk = 'wav'; update filetypes set mediatype = 'application/xml' where pk = 'xsl';