Since then I acquired a variety of large sets of stock-books, collections and random boxes of stuff from a variety of real auctions in London and on-line in the early days of eBay - which I would now not go near as it's simply a hotbed of fraud and scams. Every time I progressed in sorting things out more material appeared. It's been a number of years since I last had a proper go at consolidating, classifying and recording what I have and I have decided it's about time to start again. Again.
Now that the world has moved on and on-line is the way forward I have looked for, in vain, a good resource to help me catalogue my collection. There are a variety of sites and services out there and a lot of work has already been done by Keijo Kortelainen one his rather excellent site - one page in particular has been very useful: Stamp Collecting Blog - Software & Services. However what I have been looking for is something much more akin to the functionality, community and openness of Discogs but sadly there is nothing. So, in the spirit of the nerd I am going to see what I can knock up as a starting point and see what happens.
I've sought advice and pointers from my friends and had some good input but as of yet there is nothing simple and out-of-the-box that's going to be trivially adaptable. Platform solutions like Drupal and Django and Ruby On Rails all seem like good jumping off points but I have, as always, my own ideas and crowbarring these into an existing system may not be as easy as all that. I've bought some O'Reilly books that might get me started or at least thinking in the right direction. Especially as today is the last day of their 50% off Back 2 School promotion. In a way I am going back to school, just in my own head.
So, not having actually done much yet what do I think I want? Well my ideal starting point would be a white-box version of Discogs but I guess they are too focused on their own venture - and good luck to them as it's a great thing - and there is no sign it's being open sourced. So, with that constraint out of the way what are my wants again?
On the front-end I would like to see
- User contributed content
- Open access to data
- An active community
On the technical side I want
- A real relational SQL backend with a well structured data model
- Intuitive and fast web interface, client-side processing for responsivness
- Portable interface with local data (for offline catalogue portability) - Android and maybe iOS if anyone is bothered
- Extensibility for new features and other categories of collectibles
In terms of the technologies and the acronyms - REST, AJAX, MVC etc. - that can come later. I think the right place to start is the data model and work up from there. Any framework that allows me to then incorporate that data model (I am very happy to write the SQL queries) is a good starting point from then.
So, next posting I am going to ramble about taxonomies (not the Drupal sort) and how to split the data and what data might exist for that hobby called stamp collecting. Not philately, that's something quite different.