Path: csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!1.eu.feeder.erje.net!newsfeed.fsmpi.rwth-aachen.de!newsfeed.straub-nv.de!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail From: TheJ Newsgroups: comp.sys.apple2 Subject: Re: Retro computer collection management database recommendations sought Date: Sun, 19 Jul 2015 14:53:15 +0000 (UTC) Organization: Mac GUI Lines: 60 Message-ID: References: <1195163374458993638.983494europlus-mcnamaras.id.au@news.sunsite.dk> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Injection-Date: Sun, 19 Jul 2015 14:53:15 +0000 (UTC) Injection-Info: mx02.eternal-september.org; posting-host="ac9e0e4d7dd3957fb97803ee6801bab8"; logging-data="10360"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18eb9506Usjq5kzyp9SEUAK" User-Agent: Mac GUI Usenet In-Reply-To: <1195163374458993638.983494europlus-mcnamaras.id.au@news.sunsite.dk> Cancel-Lock: sha1:h/MLYeaMQ522bLsl8WT/siBCumo= Xref: csiph.com comp.sys.apple2:25355 europlus wrote: > Hi all, > > I've struggled for some time with trying to flesh out some sort of > collection-management database system. After a couple of successful > gatherings at my place and realising I need a better handle on what I > have, > I've decided to start looking into this again. > > I thought I may as well check in on the collective wisdom of you all in an > attempt to shortcut my efforts - I'm already time-poor, so I really > shouldn't try to develop something myself, and I'm not a database expert > (just enough knowledge to be dangerous). > > I'd prefer something in an open-source DBMS with a web front-end that can > be installed in OS X, but I'm open to a FileMaker Pro solution. MS Access > and/or other Windows-based solutions won't be viable for me unless there > is > no alternative and I get desperate. > > It will have to be relational and quite flexible about the organisation of > records. > > For example, I'd like to be able to have components combined to make other > components. For example, two 5.25" drive "components" combined with a disk > controller "component" to make a "5.25 disk sub-system", which, in turn, > is > added to an Apple ][ CPU component into a "main system". > > Item attributes might be as varied as serial number, number of pages in a > book, storage capacity, provenance, condition, problems, picture/s, loan > info (who, when, etc) - each item would have a "type" attribute which then > determines which other attributes apply. If it's a book: ISBN, author/s, > pages, publisher, etc. If it's a disk drive: model, serial number, etc. > > Does anyone have a system such as I describe that they can recommend? I > won't say price is no object, but I am willing to pay for a solution - > probably in the order of up to a few hundred at most (for a phenomenal > system). If I'm paying for a system, though, I'd certainly want to have a > good amount of info available beforehand and availability of support after > purchase, even if only e-mail based. > > Thanks > > europlus > I too have had this desire and also don't the time to do it. I'm an entry level database guy. I make FileMaker DBs as my day job but I'm self taught and really not up to making something that high performance. I would love to see something that's open to the Internet at large so a COLLECTIVE view of the state of teh Apple 2 community was possible. I have shared this with someone who definitely has teh knowhow to pull it off. I will leave it to him to comment if he wishes. J