Researching WordPress Plugins
It doesn’t appear to be all that hard to build a WordPress plugin. As best I can tell, it’s just a matter of setting up some hook functions to initialize, update, and make changes. I probably will utilize the WordPress Post Meta methods for the tagging and naming of parts, one way or another, but add my own tables for additional information.
More Database Stuff
I know this is supposed to be a blog about taking apart a car, but so far it’s been more about building a website. C’est la vie. Here’s more of the same.
I got to thinking about that whole “use the WordPress term/tag tables” thing I was talking about and am now considering expanding the idea: what if I write the database access as a WordPress plug-in? Then I can use the WordPress Dashboard to enter data, and the whole thing will be more tightly integrated with WordPress. I think it’s a win-win. Plus, I get to explore building a proper plug-in in addition to brushing up [er ... relearning] MySQL.
The Basics of Database Building
I’ve long been wrestling with what I want the ReSassy database to do. So far it’s congealed into the following goals:
- I want to track each piece of Sassy.
- I want to be able to summarize data from anywhere on a hierarchy of sub-assemblies.
- I want to be able to summarize data from a dynamic list of characteristics (“parts made of plastic”, “parts that were recycled”, “after-market parts” etc.)
- I want to track all the parts by weight and compare to the total actual weight and the 2094 pound curb weight. I want to be able to enter weight in whatever unit is convenient.
- I want to track financial exchanges for each part: either how much it was sold for, or how much it cost me to get rid of it.
- I want to note where a part will likely end up at the end of its useful lifetime, and to rank its utility during that lifetime and its value or destructiveness after that lifetime.
The Low Hanging Fruit
In taking Sassy apart, I’m going to start with the “low hanging fruit”. I’m sure I can sell the OEM alloy wheels on eBay. The VTEC-E engine might be a popular thing too, but I’ll need to figure out how to ship an engine. Likewise with the transmission … a nice bolt-on for someone toying with an electric vehicle conversion, for instance (plus I have the original clutch in the garage). The control computer will probably fetch a good price too.
The 15-Year Anniversary Kick-Off
So 15 years ago today, I took ownership of a 1994 Honda Civic VX from John Holtz Honda in Rochester, NY. She was named “Sassy” just a few years ago, and this year I decided to start this project where I’ll be taking her apart and selling, reusing, repurposing, recycling, or (as a last resort) throwing away each piece. Check out the About the Project page and Sassy’s History for more details.
In the coming weeks I’ll be developing a database to track where the parts go and then it’s time to start unbolting!