15 Aug
2023
15 Aug
'23
4:24 p.m.
I can provide SQL database dumps (PostgreSQL, but adaptable for other SQL
databases) for:
* ~38,000 hardware items (table "hwr"), e.g. "KA630" "MicroVAX II
CPU"(99%
DEC items)
* ~117,000 hardware item variants (table "hwrvar"), e.g. "KA630-AB"
"1MB
without floating point"
There are tables for other kinds of items, too, e.g.: "swrpro" (software),
"doc" (manuals), "swrpac" (software packages), ...
And there are the "link tables" that glue the "base tables" together,
e.g.:
"doc_hwr" (which manuals describe certain hardware items).
For the database specialists: Referential integity is strictly inforced
Finally there is a user-interface, too, built with LibreOffice Base.
Last but not least I must admit that the "DECdoc" database is VERY helpful,
but it needs some understanding of databases, and it lacks a web interface.
Let me know when you want to try ...
Ulli
Am Di., 15. Aug. 2023 um 18:19 Uhr schrieb Ali via cctalk <
cctalk(a)classiccmp.org>gt;:
I can think of
a couple of options that might be what you're looking
for. The first is
Part-DB-server (https://github.com/Part-DB/Part-DB-server). It was
originally meant for
managing inventories of parts but I've found that it's also good for
managing my inventory
of retrotech.
This sounds like something I have been looking for and was actually
thinking of learning SQL so I could implement myself. But if someone has
already done the heavy lifting... One question: how complex are the web
pages it generates? That is can older browsers, or even TEXT based e.g.
Lynx, browsers also view inventory and/or edit the DB? I would ideally love
a solution that I can access from both my modern systems and the vintage
system I am currently working on. TIA
-Ali