
Hooray for active data collection!Not to throw a wrench in KISS, but in your schema, be sure to allow for a “source” of the serial number data. I’m not sure I have your email address, so write me at and I’ll send you the Remington stuff. Who knows what their source was, but it’s another piece of the puzzle.

The “collection gallery” idea has morphed into just adding the ability to upload typewriter photos to each make/model/year category, so we can upload examples of that particular category’s machines as a visual aid to assist identification.In preparation for this project, I’ve picked up many of the recommended reference works on typewriter history and identification to beef up my own admittedly limited knowledge of the subject, and now I’m identifying problem areas with TW-DB and coordinating alternate sources to see if these areas can be made more accurate. Now I’m thinking “Keep It Simple, Stupid”, and just re-compiling the existing data into a relational database, fix what’s incorrect or re-jigger what’s confusing, and trying to fill the gaps.


If the original maintainer were still doing updates, these could be easily fixed, but that doesn’t appear to be the case.Originally, I thought of creating an online game with a new serial number database and collection galleries and such, but that idea’s out the window just because of the complexity involved.
