adding custom fields dynamically to a model

Question

I have a model called List which has many records:

class List
 has_many :records
end

class Record

end

The table Record has 2 permanent fields: name, email.
Besides these 2 fields, for each List a Record can have 'n' custom fields.

For example: for list1 I add address(text), dob(date) as custom fields. Then while adding records to list one, each record can have values for address and dob.

Is there any ActiveRecord plugin which provides this type of functionality?
Or else could you share your thoughts on how to model this?

Thanks in advance,
Pankaj

VP. · Accepted Answer · 2010-04-28 09:02:02Z

2

You should take a look in schemaless database solutions. One that i think is great is mongoDB.

There is a railscast explaining how to use it with rails. Take a look, it works great.

answered Apr 28, 2010 at 9:02

VP.

5,1567 gold badges50 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ramon Tayag Over a year ago

Sounds good but I wouldn't want dynamic fields be the only reason to move :|

severin · Accepted Answer · 2010-04-28 10:17:41Z

2

If your custom fields don't need to be real database columns, you could use serialize: http://railsapi.com/doc/rails-v2.3.5/classes/ActiveRecord/Base.html#M000924 You would use it like:

class Record < ActiveRecord::Base
  serialize :custom_fields, Hash
end

r = Record.create :custom_fields => {:name => 'John Doe', :birth_date => Date.new(1970,1,1)}

r.custom_fields[:name]
# => 'John Doe'

r.custom_fields[:birth_date]
# => #<Date: 4881175/2,0,2299161>

Pro: easy to use

Con: since the custom fields are not db columns, you can't find records in the db based on their values (e.g. Record.find_by_name('John Doe') does not work)

answered Apr 28, 2010 at 10:17

severin

10.3k1 gold badge42 silver badges41 bronze badges

Comments

Fran · Accepted Answer · 2010-04-28 07:20:46Z

1

Maybe this? has_magic_columns. I havn't tested it myself but seems like it can do what you need.

answered Apr 28, 2010 at 7:20

Fran

1,07310 silver badges19 bronze badges

1 Comment

Espen Over a year ago

Does not work with Rails3 though. And the code has not been touched in a while. Cannot find any info on it except for the docs.

Collectives™ on Stack Overflow

adding custom fields dynamically to a model

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related