templating and other things

I built a one page template, with page specific items stored in the database. This will make it much easier when editing the timeline pages. I'm going to build a few more basic templates to handle other page types, like the era indices and some of the static pages.

It should be noted that while much of what presented here is automated it is not automatic. I still build the pages at home and each page fits into a determined structure. The templates and database tools I've created are just tools to this end. All the pages except for a few SSI are static. I do it this way to keep my load on the server and the load times for visitors as low as possible, and it is done because all of this is homemade by me and I really wouldn't trust it 'in the wild' without me looking at what it is doing.

The size of the 'working' database is about 20,000 items. There are still plenty of dupes and no specific editor yet. I'm still writing throwaway scripts to extract and convert the different timelines pages into the mySQL . I think I have only one more set to do.

I'm still learning the intricacies of mySQL, but I have a decent idea of what the timeline tools will look like when all this is finished and how to get there.