Just one mention about this plan..
the idea of the Wiki is to contain the information on in the wiki. NOT to link to external sources. While they can of course be referenced, the information needs to still be in the wiki site itself.
Otherwise you're dependent on another website to be up and useful. The entire point is so that if this board were to crash and go away, or someones random personal page with good info was to disappear, you would still have all the info you need in one place. The wiki itself is professionally hosted, backed up and maintained in a data center with mirrors in 3 physically different parts of the country.. so it should never be "lost". But anything it links to can be.
Im still lost on how some static data belongs in a different database. I dont know if you're aware, but everything in the wiki, is in a database, complete with versioning history and everything. nothing is lost.
I would suggest heroku is a far more stable host than this site, as often I find it down. Heroku is a professional hosting server that many companies use. Admittedly this is on a hobby dev within the server (which is free hosting up to 10,000 rows in the DB)
You can read about it here.
Ultimately BrianTRice should have the last say as to what he wants or what is a good idea as its his baby. I will just go with the flow.
A real DB lets you run queries to subset the data so thats the advantage as Shadow pointed out.
Thanks for setting this up! I fully agree that the data should live in the wiki database, but there is no way obvious to me how to do this. I'm of course willing to make measurements on my Zero and do data entry! There just needs to be some good mechanism for the data to be useful after it is entered.
My own ambition, beyond maybe what Brian would like, is that "Zero Manual" not be limited Zero Motorcycles vehicles.
At danger of over-thinking this... more general purpose for the field names would allow us to form a parts database. Mostly I am thinking of fasteners and torque values, where i.e. Bolt Depot's
Identifying Fasteners guide says five fields is enough. All of the world's life in science studies are described by seven categories, and the well known "O.S.I." model has seven layers as well. I think we need at least five to describe fasteners, and seven is pretty close to that so we can assume seven categories.
The basic tables layout having [foreign key] and {unique key}:
MakeYearModels (Make, Year, Model)
Cats ({Name}, A, B, C, D, E, F, G) ; "Fastener"=>Type,Material,Diameter,Length,Thread,NULL,NULL
Items ([CatName], A, B, C, D, E, F, G) ; [Fastener], Shoulder Bolt, Alloy Steel, 10mm, 100mm, M8
and beyond this we can go into applications Apts of those items
Apts ([MakeYearModel], [Item], Name, Minimum, Nominal, Maximum, Unit)
OEMParts ([MakeYearModel], [Item], Partnumber, Description)
Citations ([Application], Description, URL)
This works if you have multiple Items (bolt, with a nut, each is a fastener) for an Apt. That part of the idea needs a little refinement perhaps.
The overall desire I have is for a parts database, with torque/pressure/partnumbers, and perhaps references back into the wiki, that we can query by URL and inset to the wiki.