 | | A Technic set DB outline
|
|
Hi: First, thanks for everyone's help with my earlier database question. Here is a new one: does anyone have a Lego database in a true relational format (with all of the normalization, etc)? I have come up with an outline that will hold all of the (...) (26 years ago, 30-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Three Suggestions
|
|
(...) Right, that's why the :) -- it seemed like an obviously good idea at first, but then I couldn't really think of many practical uses. (26 years ago, 29-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Three Suggestions
|
|
(...) Is that a real :) or mostly a ;) ? I agree that a PerlRE would be cool (and not really difficult to add), but can you give some concrete examples of search queries which would benefit in a major way from a feature like that? I can see a bit of (...) (26 years ago, 29-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Three Suggestions
|
|
(...) How about this?... (URL) least for the time being... --Todd (26 years ago, 29-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Updatezilla
|
|
What I tell people when they ask is that I can't give or revoke permission to use the images on my site because I don't own them in the first place. I agree it's a nettequette issue rather than a legal one. KL (...) (26 years ago, 29-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Updatezilla
|
|
(...) It still never hurts to ask, although Huw (and I think Kevin) have given "blanket" permission for use of the images in this context. I don't recall if Tore, Joe, and Jim have given such blanket permissions, so I would ask. Aside from explicit (...) (26 years ago, 27-Nov-98, to lugnet.admin.database)
|
| |
| | Updatezilla
|
|
Hi all Todd, now I've 521 set pictures that are not registered to the database yet, and 202 other pictures for the sets with missing pictures. I'm still waiting further info from you. By the way, I investigated a little bit the pictures in my hand (...) (26 years ago, 27-Nov-98, to lugnet.admin.database)
|
| |
| | Re: A database question
|
|
Steve Bliss wrote in message <365c1013.5669348@lu...et.com>... (...) Access provides this facility built-in so there's no overhead in keeping it in Access, then creating a query to export the table(s)/fields exactly as required. Huw (26 years ago, 26-Nov-98, to lugnet.admin.database)
|
| |
| | Re: A database question
|
|
Steve Bliss wrote: < DBA 101, topic: non unique "keys" which really aren't keys.> Yup. AutoNum means no manual thinking about which postfix to attach to the set (and attendent opportunity for error) but also means a number that has no human meaning, (...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
| |
| | Re: A database question
|
|
(...) If you go with Access, take the time to write a VBA function to export the data to CSV format. That way, you can share with everyone, and you won't have a export-headache each time you update the database. (...) The classic relational database (...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
| |
| | Re: A database question
|
|
(...) Jim, if your intention is for other people out on the net to be able to make use of your DB, the best way to publish the tables is in CSV (Comma Separated Values) or tab-delimited ASCII. That way anyone can easily convert it to their own (...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
| |
| | Re: A database question
|
|
(...) Since set numbers are not unique, they shouldn't be used as primary keys. So the best solution is to move the set number into a secondary key and introduce a new primary key which is either a function of the set number by tacking on "-1", (...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
| |
| | Re: A database question
|
|
(...) I don't think Todd is using anything non-free -- in either sense of the word 'free'. (Correct me if I'm wrong...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
| |
| | A database question
|
|
Hi: I am currently in the early stages of completely redoing my Lego Technics site and decided it would be cool to put all of my information about technic sets and elements into an Access database (this may not be the best choice but is was free!). (...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Update Info for Lugnet Database Volume V
|
|
I have a few Euro-Service catalogues, from 1992-1998. Are they of any use? Would you want just the set pictures, or all of it, covers, multi- lingual ordering instructions, etc.? Was that scan of the 5600, at 300dpi reduced 1/3 side any good? If you (...) (26 years ago, 24-Nov-98, to lugnet.admin.database)
|
| |
| | Update Info for Lugnet Database Volume VI
|
|
Hi again, Here is the next flood..:-) As always 300 dpi set pictures to Lugnet, 100 dpi full catalog scans to kl.net. These sets are from service catalogs, namely 1991 Europen/Common Wealth, 1995 European, 1996 European, 1997 European, 1997 New (...) (26 years ago, 24-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Update Info for Lugnet Database Volume V
|
|
(...) muhahahha...:-D (...) They were the last two pages of a European (set boxes has no set names printed) Dealers' Catalog, which is printed in English. This is a big (A4 size) catalog with sligtly harder back and cover pages. I've never seen a (...) (26 years ago, 24-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Update Info for Lugnet Database Volume V
|
|
(...) Zoinks!!! Once again, ouch :) but thank you! (...) Haven't done anything with this yet, but saved it for later processing... it's quite nice because it shows the box sizes and official piece counts; is are there more things around like this? (...) (26 years ago, 23-Nov-98, to lugnet.admin.database)
|
| |
| | Update Info for Lugnet Database Volume V
|
|
Hi I'm back here and online again. Here are the sets from 1985 and 1986 Turkish/Middle Eastern, 1987 European Dealers' and 1990 European(?) catalogs. 0200 this picture features a different cover page and year is 1985 0300 alternative picture (no (...) (26 years ago, 23-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Update info for Lugnet Database Volume IV
|
|
Thanks to everybody for greetings and nice wishes. I'm a newly wed for a week now, and of course very happy...:-D Selçuk (26 years ago, 22-Nov-98, to lugnet.admin.database)
|
