To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.admin.databaseOpen lugnet.admin.database in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Administrative / Database / *70 (-10)
  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)


Next Page:  5 more | 10 more | 20 more

Redisplay Messages:  All | Compact

©2005 LUGNET. All rights reserved. - hosted by steinbruch.info GbR