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@classiccmp.org>: > > 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 > > >
