This is the query stuff I am using.  create and create2 are the
structure of the databases.

This is the main document index database
create table pdp8docs ( 
id serial,   // Document number
docname char(32),  // Name, when known the part # DEC etc used
doctype char(32),  // Not currently used
title char(100),  
date char(32),     // Just a string where I put what I know about printing date
size int4,	   // Size in bytes.  Probably should convert to more useful
                   // things like MB when displayed
filename char(100) unique,  // The filename with path from site field below
sort char(32),     // This is used so lists of documents group sensibly when 
                   // displayed
keywords text,     // A list of keywords to also use for searching if the
                   // title doesn't contain all the words people are likely
                   // to use to find to document. The docname, title, and 
                   // keywords are searched
site char(64)	   // main site document is from
);
Some example lines

1|aa-5267c-ta                     |Manual                          |WPS-8 Word Processing System Reference Manual (Ver 2.7 and 3.0) chapters 1-8                        |December 1978                   |4330312|pdp8docs/aa-5267c-ta-c1-8.tif                                                                       |OS WPS                          |WPS, VT78                    |http://www.pdp8.net/                                            
50|EK-8E0003-MM                    |Manual                          |PDP-8/E PDP-8/F & PDP-8/M Processor Maintenance Manual Volume 3                                     |                                |0|dassearch.html                                                                                      |PDP-8/E                         |LC8-E, M8329, PC8-E, M840, PC04, XY8-E, M842, LE8-E, M841, DP8-E, M839, M866, KG8-E, M884, CM8-E, M843, CR8-E, TD8-E, M868, TM8-E, M8321, M8322, M8323, M8327, TA8-E, M8331,  RK8-E, M7104, M7105, M7106, VT8-E, M8335, M8336, M8337            |http://www.digital.com/                                         
136|ek-8a001-op                     |Manual                          |PDP-8/A Operator's Handbook                                                                         |September 1976                  |0|dassearch.html                                                                                      |PDP-8/A                         |                       |http://www.digital.com/                                         
182|AA-5184A-TA                     |Manual                          |RTS/8 DECnet/8 User's Guide                                                                         |February 1977                   |295754|doc/decnet8.doc                                                                                     |OS RTS/8                        |          |ftp://ftp.dbit.com/pub/pdp8/                                    


This tells where to find files and extra information on the file for
each documents.  The site and filename fields are concatinated together
and looked up in this file for location.  If descr is non blank it is
printed with the file link.  The MD5 field for that document is then
searched for to find if any other mirrors of the document exist.  If
so they are displayed
CREATE TABLE "files" (
	"location" character(100),  // File location
	"md5" character(32),  // MD5 checksum (md5sum) of file contents.  Can
                              // be any unique identifier to allow matching
                              // of documents on mirror sites
	"lcl" bool,           // Local to my site for some special processing
	"site" character(16), // information on what site, not used.
	"descr" text          // Extra information to display with document
);

Some example lines
http://www.pdp8.net/pdp8prints/fp5409668.tif   477044c540ef01dd9ee3f5eb1ca1a5aa	t LCL   

http://www.pdp8.net/miscdocs/small-computer-handbook-1966-sec1-2.tif  61838179f44d9d7c3b1724dbe0ed859c t LCL Converted from JPEG to black and white tiff, much smaller (5M vs 60M) but looses some quality.

http://www.digital.com/dassearch.html 00000000000000000000000000000000 f DEC This document is available for purchase from Compaq. If it goes out of print let me know and I will make my copy available.  Enter the document number (docname) in the search string field in the following link.  To purchase try 1-800-ATCOMPAQ or 1-800-DIGITAL.  If you have trouble getting the document email me djg@drs-esg.com and I may be able to help.  I have no relation to Compaq or Digital but will attempt to find the correct information for you.

http://www.pdp8.net/pdp8docs/ek-0rx02-tm-001-300dpi.tif f35897d142c7b086124a284f2b0cf4bc t LCL Document converted from 600 to 300 DPI, about half the size for download