Path: csiph.com!usenet.pasdenom.info!aioe.org!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: Wed, 22 Jul 2015 19:54:58 +0000 (UTC) Organization: Mac GUI Lines: 55 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: Wed, 22 Jul 2015 19:54:58 +0000 (UTC) Injection-Info: mx02.eternal-september.org; posting-host="ac9e0e4d7dd3957fb97803ee6801bab8"; logging-data="12408"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/fhDJfSbk55ZH2idmpQ0Oy" User-Agent: Mac GUI Usenet In-Reply-To: Cancel-Lock: sha1:EAdnWRa+DkgdZUprWgZwZ9nmKuY= Xref: csiph.com comp.sys.apple2:25388 D Finnigan wrote: > 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. > Sharing your schema would be awesome ! This would allow it to be created in any database and cataloged individually and if/when a "community" database is created, everyone would already have their collections cataloged using the same schema! I look forward to seeing the schema :-) Jason