Subject:
|
Re: Unique keys for sets
|
Newsgroups:
|
lugnet.admin.database
|
Date:
|
Mon, 27 Dec 1999 06:52:50 GMT
|
Viewed:
|
153 times
|
| |
|
|
A few minutes ago, I posted:
> Would it possible and reasonable to add a unique key to the Pause
> database setlists?
But... hm. A possible problem with documenting the key is that the
unique key used in the Pause database appears to change over time.
If TLC were to come out with another set numbered 8880, what would
the keys be for the sets?
I'm guessing, based on evidence on the db pages, that the Supercar's
unique key would become 8880-1, while the new set would be assigned
a key of 8880-2. A change like that might be fine internal to Pause
(I don't know) but would confuse personal databases like mine, and
probably result in misdirected links and associations from other
web sites that had been pointing at 8880, not 8880-1.
One option would be to use the year as part of the key. I think Kevin
does something like this on Brickshelf, and it's part of what I have
been doing in my spreadsheet. It doesn't quite solve the problem of
what to do if there are more than one set with the same number in one
year (like set 1974 or 214), but maybe TLC has stopped doing that... :-)
Dang... I didn't plan to ask for something and then disagree with
myself... I haven't been paying much attention to the online Lego
community until fairly recently, but I would guess that the subject
of unique, unchanging set keys came up ages ago. Has this problem
already been generally solved?
-r'm
|
|
Message has 1 Reply:
 | | Re: Unique keys for sets
|
| (...) No, the primary keys in that DB haven't changed since they were first created in April of 1998. When the DB is reborn out of its current form and into its new form, the old keys will be obsolete, but there will be a backward compatible (...) (25 years ago, 28-Dec-99, to lugnet.admin.database)
|
Message is in Reply To:
| | Unique keys for sets
|
| Would it possible and reasonable to add a unique key to the Pause database setlists? In effect, to add another column to: (URL) the related lists. I've got a fairly hairy spreadsheet that I use to keep track of my sets. I use the Pause database as a (...) (25 years ago, 27-Dec-99, to lugnet.admin.database)
|
12 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
|
|
|
|
Active threads in Database
|
|
|
|
|
|
