| |
In lugnet.db.brictionary, Eric Vitiello writes:
> I'm going to begin by designing the database to hold the data,
> and deciding on the best method to catalog the parts, or the best existing
> database to use for the parts.
One problem we have at the moment is that the various sources of parts lists
(LDraw, Tim Vattima's set inventories, Auczilla, Technica, etc) all contain
different subsets of the full parts list and use different descriptions. We
need to combine these sources and also work out how to deal with parts not on
any of those lists. Until that's done the inventories are difficult to collate.
> Any suggestions on which database?
For an online database I'd choose Oracle or SQL Server. There are people (like
me) who'd like an offline version as well. I think Access would probably be
best.
> I'd also like to get a list of things people would like to see this thing do
> once it's
> completed, that way the database can be better designed. Here's a list of
> my wants:
>
> 1. Search for the parts in a particluar set.
> 2. Search for all sets with parts matching a list.
> 3. Search for sets that have X in the name
>
> I will also like to include pictures of each part.
Some sort of searching (or at least heirarchical arrangement) of parts based
on attributes/description of the part would also be necessary (it's not
pleasant to have to wade through huge numbers of pictures looking for the part
you want). There's another thread about just this.
Regards,
Steve Hodge
|
|
Message has 1 Reply:
 | | Re: Online LEGO Inventory Database
|
| (...) 'The database' should allow multiple descriptions per piece. And should have the major descriptions pre-loaded. The core element table should have an abstract key value, and a pointer to a graphic image for each part. A second table, call it (...) (25 years ago, 7-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
Message is in Reply To:
| | Re: Online LEGO Inventory Database
|
| (...) I (...) to (...) Perhaps (...) be (...) Sounds good to me! I'm going to begin by designing the database to hold the data, and deciding on the best method to catalog the parts, or the best existing database to use for the parts. Any suggestions (...) (25 years ago, 7-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
9 Messages in This Thread:
  
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
This Message and its Replies on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
