Cataloging Collection of Boards and Pieces

Sort:
Avatar of clorgies

As I have amassed a considerable (for me) number of boards and pieces, I've decided I need to catalog them somehow. Do any of you keep a database, spreadsheets, or other catalog of your boards and/or pieces? If so, any tips on software, characteristics to track, etc? 

At the moment I have started an Airtable db for pieces that tracks name of pieces, king height and base diameter, recommended board size, materials, design , notes (of my own and from vendors, sales, etc), images (my own and from vendors or elsewhere), and price I paid.

I'm also scratching my head a bit about designs. I have listed, so far: Staunton, Zagreb, Dubrovnik, Modernist, Themed, and Isle of Lewis.

Avatar of Newcastle1974

I use this apple numbers spreadsheet to keep track of my sets, speaking of this, I need to add a bunch more sets into the database (they add up sooo fast before you know it). You can click on the wood types and select any kind of material possible. Hope this can be helpful!

Avatar of chesslover0003

If you think a DB is necessary, any relational DB is likely going to be fine. I would have suggested a spreadsheet... and possibly even Google Sheets if it is something you wanted to share and collaborate with others.

I use Google Sheets to track all batches of Palinka I distill. I don't bother tracking the consumption, lol. I should add a new field for awards since a few batches have earned awards.

Once it's in the DB, what do you plan or intend to do with the data? Is it for insurance purposes? Do you lend them out?

Avatar of Newcastle1974

Well for me I DB it for a few reasons...first, just in case something unexpectedly happens to me and I pass. My family will have a DB to help them understand what their crazy Chess fanatic Dad/husband has of value. On top of that, for myself! After so many set collected, they can become very hard to remember who I bought them from and other such details. I guess I don't have the best of memories any longer lol...

Avatar of chesslover0003

All good reasons. I think a spreadsheet would be fine (no everyone knows how to browse a DB).

Avatar of Newcastle1974

I agree, my post above is a spreadsheet from apple numbers. Only spreadsheet available worth using on a MAC unfortunately!

Avatar of clorgies

I'm using AirTable, which is sort of a meld of a spreadsheet and a relational DB. I use it a lot at work, so I am familiar with it! I don't know that I am going to get quite that detailed with piece weights and such though!

Avatar of Newcastle1974

Thats ok, just detail what you need and scratch the rest. I am a little OCD and have the same sets but different sizes, colors and such sometimes and want to be as complete as I can. Plus I have a great time examining my sets when measuring and weighting them, it helps to understand the designs as much as I can. Its just a passion of mine I guess...

Avatar of lighthouse

Unless you have the real set's & not repros , Most will not be worth that much . Just put a note in the chess box saying what is what , As easy as that , I don" t have that many , yet I am happy with the sets I do have + just let my son know these's are rare & valuable sets , As one day it's his .tongue