Sent from my iPhone
On 20 Oct 2008, at 16:37, David Smit <[EMAIL PROTECTED]
s.net> wrote:
>
> I need to give users the ability to optionally add metadata to
> documents. Another way to state this is the fact that users need to
> add
> at least 5 categories to a document.
>
> Basically what I want to do is dynamically add metadata (or
> categories)
> to a document on an ad hoc basis. Here are the options that I have
> thought of:
>
> **Option 1:**
> Should I do this by dynamically creating new table columns in the
> database?
>
Yuck
> **Option 2:**
> Should I define 5 columns called
> attirbute1,attirbute2,attirbute3,attirbute4,attirbute5 and then only
> use
> and show them if the user requires the attributes.
>
May not be flexible enough
> **Option 3:**
> Should I create a metadata table that keeps track of the columns and
> the
> data associated with them?
>
I would go that way. Your metadata table just stores triples: id of
the parent, the name of the piece of data and its value
Fred
> What do you think is the best way to achieve this? Can you think of
> any
> other ways to easily add this functionality. The problem is that the
> functionality needs to be very generic.
> --
> Posted via http://www.ruby-forum.com/.
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
