| |
In lugnet.db.brictionary, Steve Hodge wrote:
> 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.
'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 Descriptions, would have
the various descriptions for the part and the key back to the core element
table.
> > Any suggestions on which database?
Flat files. Those will have the broadest usage. And it's not like the amount
of data (thousands of records, maybe 10's of thousands) will stress the
software. If your server is NT, you can even use the ODBC text driver to throw
a layer of RDBM on top of the data.
> > 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.
Pictures are going to be the ultimate ID method for parts. Having a small
number of categories or types would allow easier access to the pictures. Once a
number of descriptions are collected, a text search function is possible.
Look at <http://www.lugnet.com/cad/ldraw/parts/ref/> for ideas on organizing and
searching. Some stuff there works well, some doesn't.
Steve
|
|
Message has 1 Reply:
 | | Re: Online LEGO Inventory Database
|
| (...) collate. (...) Yep. The difficulty is in matching up the descriptions from the various sources (e.g. which LDraw part is this Technica part?). Sometimes it's easy, somethimes it's not. (...) Yep. (...) part (...) a (...) and (...) That's the (...) (25 years ago, 9-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
Message is in Reply To:
| | Re: Online LEGO Inventory Database
|
| (...) 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 (...) (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
|
|
|
|
