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


Groups > comp.sys.apple2 > #25354 > unrolled thread

Retro computer collection management database recommendations sought

Started byeuroplus <europlus@mcnamaras.id.au>
First post2015-07-19 10:39 +0000
Last post2015-07-30 15:57 +1000
Articles 15 — 5 participants

Back to article view | Back to comp.sys.apple2


Contents

  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

#25354 — Retro computer collection management database recommendations sought

Fromeuroplus <europlus@mcnamaras.id.au>
Date2015-07-19 10:39 +0000
SubjectRetro computer collection management database recommendations sought
Message-ID<1195163374458993638.983494europlus-mcnamaras.id.au@news.sunsite.dk>
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

[toc] | [next] | [standalone]


#25355

FromTheJ <thej@shaw.ca>
Date2015-07-19 14:53 +0000
Message-ID<thej-1437317683@macgui.com>
In reply to#25354
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

[toc] | [prev] | [next] | [standalone]


#25380

FromD Finnigan <dog_cow@macgui.com>
Date2015-07-21 23:55 +0000
Message-ID<dog_cow-1437523007@macgui.com>
In reply to#25355
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/

[toc] | [prev] | [next] | [standalone]


#25388

FromTheJ <thej@shaw.ca>
Date2015-07-22 19:54 +0000
Message-ID<thej-1437594987@macgui.com>
In reply to#25380
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

[toc] | [prev] | [next] | [standalone]


#25389

Froma2retro <a2retrosystems@gmail.com>
Date2015-07-22 21:20 -0700
Message-ID<63f001a3-36f6-4221-8aec-1ad787611207@googlegroups.com>
In reply to#25388
Does Filemaker Pro support mobile devices? What does an entry level seat for that software cost?

[toc] | [prev] | [next] | [standalone]


#25390

FromHelpful Harry <HelpfulHarry@BusyWorking.com>
Date2015-07-23 18:21 +1200
Message-ID<230720151821103183%HelpfulHarry@BusyWorking.com>
In reply to#25389
In article <63f001a3-36f6-4221-8aec-1ad787611207@googlegroups.com>,
a2retro <a2retrosystems@gmail.com> wrote:
> 
> Does Filemaker Pro support mobile devices? What does an entry level seat for
> that software cost?

It depends what you want to be able to do.

If someone else is creating / modifying the database structure and all
you need to do is enter, browse, find, print, etc. the actual data,
then a developer with the more expensive "FileMaker Pro Advanced" can
create standalone / runtime databases (for Mac or Windows) that do not
require a licensed copy of the application itself. The runtime version
cannot create / modify the database's structure. The cost is whatever
the developer wants to charge - there's no charge from FileMaker Inc.
The runtime application is also restricted to being single-user and
cannot be accessed by multiple people at the same time.

The cheapest is full version, which is all most people would need for
both creating / modifying and using databases on a desktop computer, is
"FileMaker Pro 14" for Mac or Windows, which costs around US$330 for a
single download license, slightly more for a DVD version, and there are
small discounts for bulk licenses. 

There is "FileMaker Go", which is a free app for Apple's iOS mobile
devices to use FileMaker databases or access databases hosted on a
server via the Internet / local network. It can't create / modify the
database's structure.

To be used by multiple users at the same time, the database needs to be
hosted by "FileMaker Server", and each user needs a copy of "FileMaker
Pro" / "FileMaker Go", or using any good web browser (with some
limitations).



FileMaker Pro has it's advantages and disadvantages and cons when
compared to Microsoft Access. The two biggest advantages are that it's
*far* easier to develop powerful database systems in and is available
for both Mac and Windows. The biggest disadvantage is that it may not
be as powerful for very high-end databases systems.

Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]


#25395

Froma2retro <a2retrosystems@gmail.com>
Date2015-07-23 15:25 -0700
Message-ID<746a013f-1230-4433-950e-2e21266320c2@googlegroups.com>
In reply to#25390
On Thursday, July 23, 2015 at 2:20:31 AM UTC-4, Helpful Harry wrote:
> > 
> > Does Filemaker Pro support mobile devices? What does an entry level seat for
> > that software cost?
> 
> It depends what you want to be able to do.
> 
> If someone else is creating / modifying the database structure and all
> you need to do is enter, browse, find, print, etc. the actual data,
> then a developer with the more expensive "FileMaker Pro Advanced" can
> create standalone / runtime databases (for Mac or Windows) that do not
> require a licensed copy of the application itself. The runtime version
> cannot create / modify the database's structure. The cost is whatever
> the developer wants to charge - there's no charge from FileMaker Inc.
> The runtime application is also restricted to being single-user and
> cannot be accessed by multiple people at the same time.
> 
> The cheapest is full version, which is all most people would need for
> both creating / modifying and using databases on a desktop computer, is
> "FileMaker Pro 14" for Mac or Windows, which costs around US$330 for a
> single download license, slightly more for a DVD version, and there are
> small discounts for bulk licenses. 
> 
> There is "FileMaker Go", which is a free app for Apple's iOS mobile
> devices to use FileMaker databases or access databases hosted on a
> server via the Internet / local network. It can't create / modify the
> database's structure.
> 
> To be used by multiple users at the same time, the database needs to be
> hosted by "FileMaker Server", and each user needs a copy of "FileMaker
> Pro" / "FileMaker Go", or using any good web browser (with some
> limitations).
> 
> 
> 
> FileMaker Pro has it's advantages and disadvantages and cons when
> compared to Microsoft Access. The two biggest advantages are that it's
> *far* easier to develop powerful database systems in and is available
> for both Mac and Windows. The biggest disadvantage is that it may not
> be as powerful for very high-end databases systems.
> 
> Helpful Harry  :o)

Thanks Harry,

I noticed that there is also a subscription (priced per month but contract looks to be yearly). Whats not clear it what happens if you don't renew your sub.

Glenn

[toc] | [prev] | [next] | [standalone]


#25405

FromHelpful Harry <HelpfulHarry@BusyWorking.com>
Date2015-07-24 18:18 +1200
Message-ID<240720151818569964%HelpfulHarry@BusyWorking.com>
In reply to#25395
In article <746a013f-1230-4433-950e-2e21266320c2@googlegroups.com>,
a2retro <a2retrosystems@gmail.com> wrote:
> On Thursday, July 23, 2015 at 2:20:31 AM UTC-4, Helpful Harry wrote:
> > > 
> > > Does Filemaker Pro support mobile devices? What does an entry level seat
> > > for that software cost?
> > 
> > It depends what you want to be able to do.
> > 
> > If someone else is creating / modifying the database structure and all
> > you need to do is enter, browse, find, print, etc. the actual data,
> > then a developer with the more expensive "FileMaker Pro Advanced" can
> > create standalone / runtime databases (for Mac or Windows) that do not
> > require a licensed copy of the application itself. The runtime version
> > cannot create / modify the database's structure. The cost is whatever
> > the developer wants to charge - there's no charge from FileMaker Inc.
> > The runtime application is also restricted to being single-user and
> > cannot be accessed by multiple people at the same time.
> > 
> > The cheapest is full version, which is all most people would need for
> > both creating / modifying and using databases on a desktop computer, is
> > "FileMaker Pro 14" for Mac or Windows, which costs around US$330 for a
> > single download license, slightly more for a DVD version, and there are
> > small discounts for bulk licenses. 
> > 
> > There is "FileMaker Go", which is a free app for Apple's iOS mobile
> > devices to use FileMaker databases or access databases hosted on a
> > server via the Internet / local network. It can't create / modify the
> > database's structure.
> > 
> > To be used by multiple users at the same time, the database needs to be
> > hosted by "FileMaker Server", and each user needs a copy of "FileMaker
> > Pro" / "FileMaker Go", or using any good web browser (with some
> > limitations).
> > 
> > 
> > 
> > FileMaker Pro has it's advantages and disadvantages and cons when
> > compared to Microsoft Access. The two biggest advantages are that it's
> > *far* easier to develop powerful database systems in and is available
> > for both Mac and Windows. The biggest disadvantage is that it may not
> > be as powerful for very high-end databases systems.
> 
> Thanks Harry,
> 
> I noticed that there is also a subscription (priced per month but 
> contract looks to be yearly). Whats not clear it what happens if you 
> don't renew your sub.

I haven't looked into those monthly / annual costs (mainly because I'm
still way behind using FileMaker Pro 4 and 5), but they may be only
needed for the server version if the admin needs to have more users
accessing the databases at the same time than FileMaker Server allows
out of the box. If that is the case, then not renewing the sub would
cut the number of simultaneous users the server will allow.

Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]


#25396

FromD Finnigan <dog_cow@macgui.com>
Date2015-07-23 23:14 +0000
Message-ID<dog_cow-1437693349@macgui.com>
In reply to#25388
TheJ wrote:
> 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 :-)

OK, I will publish the schema as soon as I can.

[toc] | [prev] | [next] | [standalone]


#25421 — My database schema, was Re: Retro computer collection...

FromD Finnigan <dog_cow@macgui.com>
Date2015-07-25 17:01 +0000
SubjectMy database schema, was Re: Retro computer collection...
Message-ID<dog_cow-1437843759@macgui.com>
In reply to#25396
This is really spartan, but it gets the job done for me. I am willing to
improve it, but contact me near the end of August because I'm too busy now
to devote time to it.

CREATE TABLE IF NOT EXISTS `items` (
  `item_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `obtained_from` varchar(255) NOT NULL DEFAULT '',
  `obtained_date` varchar(255) NOT NULL DEFAULT '',
  `price` varchar(50) NOT NULL DEFAULT '',
  `serial_no` varchar(255) NOT NULL DEFAULT '',
  `part_no` varchar(255) NOT NULL DEFAULT '',
  `notes` text NOT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;



-- 
]DF$
The Marina IP stack for Apple II--
http://marina.a2hq.com/

[toc] | [prev] | [next] | [standalone]


#25423 — Re: My database schema, was Re: Retro computer collection...

FromHelpful Harry <HelpfulHarry@BusyWorking.com>
Date2015-07-26 10:42 +1200
SubjectRe: My database schema, was Re: Retro computer collection...
Message-ID<260720151042012904%HelpfulHarry@BusyWorking.com>
In reply to#25421
In article <dog_cow-1437843759@macgui.com>, D Finnigan
<dog_cow@macgui.com> wrote:
> 
> This is really spartan, but it gets the job done for me. I am willing to
> improve it, but contact me near the end of August because I'm too busy now
> to devote time to it.
> 
> CREATE TABLE IF NOT EXISTS `items` (
>   `item_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
>   `name` varchar(255) NOT NULL DEFAULT '',
>   `obtained_from` varchar(255) NOT NULL DEFAULT '',
>   `obtained_date` varchar(255) NOT NULL DEFAULT '',
>   `price` varchar(50) NOT NULL DEFAULT '',
>   `serial_no` varchar(255) NOT NULL DEFAULT '',
>   `part_no` varchar(255) NOT NULL DEFAULT '',
>   `notes` text NOT NULL,
>   PRIMARY KEY (`item_id`)
> ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

That's an extremely simple flat-file database, easily buildable in any
database or spreadsheet application. Other than putting something in
the Notes field, it won't do the collecting of various parts into a
"system" record that the original poster was looking for. For that you
really need a database with record relationship links.

Helpful Harry   :o)

[toc] | [prev] | [next] | [standalone]


#25358

FromHelpful Harry <HelpfulHarry@BusyWorking.com>
Date2015-07-20 13:57 +1200
Message-ID<200720151357491925%HelpfulHarry@BusyWorking.com>
In reply to#25354
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)

[toc] | [prev] | [next] | [standalone]


#25437

Fromeuroplus <europlus@mcnamaras.id.au>
Date2015-07-30 07:24 +1000
Message-ID<1446652091459862277.792564europlus-mcnamaras.id.au@news.ausics.net>
In reply to#25358
Thanks, Harry - I'd prefer finding something pre-existing approaching what
I'm after rather than trying to build someone to scratch in an attempt to
get everything I want. We'll see what shakes out.

I've found Collective Access and Collection Space so far.

Talk soon,

europlus

PS news.sunsite.dk seems down, and I've just connected to an alternative
news server as real life got in the way :(

Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:
> 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)

[toc] | [prev] | [next] | [standalone]


#25439

FromHelpful Harry <HelpfulHarry@BusyWorking.com>
Date2015-07-30 14:09 +1200
Message-ID<300720151409553972%HelpfulHarry@BusyWorking.com>
In reply to#25437
In article
<1446652091459862277.792564europlus-mcnamaras.id.au@news.ausics.net>,
europlus <europlus@mcnamaras.id.au> wrote:

> Thanks, Harry - I'd prefer finding something pre-existing approaching what
> I'm after rather than trying to build someone to scratch in an attempt to
> get everything I want. We'll see what shakes out.
> 
> I've found Collective Access and Collection Space so far.
> 
> Talk soon,
> 
> europlus
> 
> PS news.sunsite.dk seems down, and I've just connected to an alternative
> news server as real life got in the way :(

Some of the database software does come with templates, like word
processors usually do, one of which is often a "Home Inventory" or
"Record / Video Collection" type of database which could potentially be
modified to fit this idea, although again the combining of records into
a separate record may not be possible without some heavy modifying.

I don't know if there's a Windows version and I haven't used it, but
for Mac OS 10.10 users who see FileMaker Pro as being too expensive
(which it is for just this need), there is a database application
called "Records" which might be a good alternative (£22.99,
http://pushpopcorn.com ). The review in the May issue of the UK's
MacFormat magazine gave it 4 stars out of 5.

Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]


#25440

Fromeuroplus <europlus@mcnamaras.id.au>
Date2015-07-30 15:57 +1000
Message-ID<1368560581459928489.747816europlus-mcnamaras.id.au@news.ausics.net>
In reply to#25439
Thanks for the link, Harry - looks like a flat database, which I think will
make it limited for what I envisaged. There's obviously nothing quite like
what I want out there already (well, I say that without looking in detail
into the two web based ones I have already mentioned, so that's a
provisional judgement - I just worry they're overkill), so may be heading
down the bespoke path one day.

europlus

Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:
> Some of the database software does come with templates, like word
> processors usually do, one of which is often a "Home Inventory" or
> "Record / Video Collection" type of database which could potentially be
> modified to fit this idea, although again the combining of records into
> a separate record may not be possible without some heavy modifying.
> 
> I don't know if there's a Windows version and I haven't used it, but
> for Mac OS 10.10 users who see FileMaker Pro as being too expensive
> (which it is for just this need), there is a database application
> called "Records" which might be a good alternative (£22.99,
> http://pushpopcorn.com ). The review in the May issue of the UK's
> MacFormat magazine gave it 4 stars out of 5.
> 
> Helpful Harry  :o)

[toc] | [prev] | [standalone]


Back to top | Article view | comp.sys.apple2


csiph-web