On Mon, Aug 14, 2023 at 4:32 PM Mike Katz via cctalk <cctalk(a)classiccmp.org>
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