Path: csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!1.eu.feeder.erje.net!news.swapon.de!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail From: D Finnigan Newsgroups: comp.sys.apple2 Subject: Re: Retro computer collection management database recommendations sought Date: Tue, 21 Jul 2015 23:55:19 +0000 (UTC) Organization: Mac GUI Lines: 45 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: Tue, 21 Jul 2015 23:55:19 +0000 (UTC) Injection-Info: mx02.eternal-september.org; posting-host="ac9e0e4d7dd3957fb97803ee6801bab8"; logging-data="29860"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX193FlmDAJqJGkRa1/WnOmhm" User-Agent: Mac GUI Usenet In-Reply-To: Cancel-Lock: sha1:lOdYrIBcioXPojZt0QG1AT0W3xI= Xref: csiph.com comp.sys.apple2:25380 TheJ wrote: > 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 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. OK, so I too have my own database of Apple equipment and I found a good solution was just to give a lot of this old equipment and software away. ;-) (only half way joking, but seriously, I have been downsizing since fall 2014) Anyway, I have two systems. One is for everything, and it has a serial number, name, price, date received, and description fields (and some others too that I can't remember now). This is a MySQL database and I use phpMyAdmin as the frontend. The other system is for all printed matter: books, magazines, manuals. This is *far* more elaborate as it is an unfinished system for Mac GUI Vault (which I hope to finish, maybe in 2016). I would be happy to share the database schema for the first system. I regret that I probably couldn't put forth the time now to make a dedicated front-end, so my offer is probably not really valuable to you. -- ]DF$ The Marina IP stack for Apple II-- http://marina.a2hq.com/