On Mon, Aug 14, 2023 at 4:32 PM Mike Katz via cctalk <[email protected]> wrote:
> I'm looking for a good inventory program to help me keep track of all of > my PDP-8 stuff. > > I would like to keep track of physical location, board etch revision, > board modification revision, bus type, where used, etc. > > If you have any good ideas, please let me know. > > I'm using a simple spreadsheet for now and it's not what I'm looking for. > > Thank you. > I've been using Libre Office Calc (Linux) to keep track of my new computer collection. It has 18 sheets. The largest sheet has nearly 450 rows, and a few others have over 300 rows; the majority are under 100 rows. The structure of each sheets is nearly the same, with minor adjustments depending on the item type. For example, books will have title, author, publisher, year of publication, edition, printing, ISBN, category; hardware will analogously have a model, manufacturer, year of manufacture, etc. It is starting to become unwieldy, especially in terms of searching. The search facilities in Calc are less than desirable. And it's slowing down. And once in a while I get these very strange data integrity errors, and I have to go repair random cells here or there (I keep regular backups so worst case I can retrieve any missing data from backups). I've been wanting to find a database paradigm that has no structure. I just want a datablob that I feed stuff into and it sorts itself out using computer magic, and then I can query it in various ways to tell me what I have. I'm not entirely sure how this will work. I'm hoping someone else already figured it out. I would also appreciate any recommendations for database software. Sellam
