Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.apple2 > #25358

Re: Retro computer collection management database recommendations sought

Show all headers | View raw

In article
<1195163374458993638.983494europlus-mcnamaras.id.au@news.sunsite.dk>,
europlus <europlus@mcnamaras.id.au> 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

That's a fairly specific database design, so I doubt there's anything
ready-made and a custom-made database is usually hideously expensive
(even spread over a couple of people or so) ... more like thousands of
dollars than hundreds. 

With good specifications and examples, I could make a FileMaker Pro
database system at a much more sensible price (or a standalone database
for Windows or Mac OS 8 / 9) that doesn't require owning FileMaker
Pro), but my version of FileMaker is an only old pre-OS X one - newer
versions of FileMaker should convert the documents, but it's would be a
bit messy.

Helpful Harry  :o)

Back to comp.sys.apple2 | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Retro computer collection management database recommendations sought europlus <europlus@mcnamaras.id.au> - 2015-07-19 10:39 +0000
  Re: Retro computer collection management database recommendations sought TheJ <thej@shaw.ca> - 2015-07-19 14:53 +0000
    Re: Retro computer collection management database recommendations sought D Finnigan <dog_cow@macgui.com> - 2015-07-21 23:55 +0000
      Re: Retro computer collection management database recommendations sought TheJ <thej@shaw.ca> - 2015-07-22 19:54 +0000
        Re: Retro computer collection management database recommendations sought a2retro <a2retrosystems@gmail.com> - 2015-07-22 21:20 -0700
          Re: Retro computer collection management database recommendations sought Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-23 18:21 +1200
            Re: Retro computer collection management database recommendations sought a2retro <a2retrosystems@gmail.com> - 2015-07-23 15:25 -0700
              Re: Retro computer collection management database recommendations sought Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-24 18:18 +1200
        Re: Retro computer collection management database recommendations sought D Finnigan <dog_cow@macgui.com> - 2015-07-23 23:14 +0000
          My database schema, was Re: Retro computer collection... D Finnigan <dog_cow@macgui.com> - 2015-07-25 17:01 +0000
            Re: My database schema, was Re: Retro computer collection... Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-26 10:42 +1200
  Re: Retro computer collection management database recommendations sought Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-20 13:57 +1200
    Re: Retro computer collection management database recommendations sought europlus <europlus@mcnamaras.id.au> - 2015-07-30 07:24 +1000
      Re: Retro computer collection management database recommendations sought Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-30 14:09 +1200
        Re: Retro computer collection management database recommendations sought europlus <europlus@mcnamaras.id.au> - 2015-07-30 15:57 +1000

csiph-web