On May 7, 5:47 pm, Tom Z Meinlschmidt <to...@meinlschmidt.org> wrote:
> just realize...
>
> in the case od 1st method:
> everything is simple, but db grows.. but... you made some typo mistake
> (eg Albama instead of Alabama) and what then.. repair entire table to
> get the correct results? weird
>
> 2nd method:
> I'm using it for a small enumeration lists (not hundreds/thousands items
> - then is better to use db enumeratin methods, like countries table and
> country_id column)
>
> in app/model/some_model.rb
>
> @@enum_list = %w( value1 value2 value3 )
>
> # to use in erb templates for form.select() helper
> def self.enum_list_for_select
> @@enum_list.enum_with_index.collect{|k,v| [k,v]}
> end
>
> def enum_list_to_text
> self.enum_list.nil? ? 'undefined' : @@enum_list[self.enum_list]
> end
>
> tom
>
>
>
> Vipin wrote:
> > in a database table if there is a field which has a certain set of
> > fixed values. for example
> > staus => {Single, Married, Divorced }
> > OR
> > state => {California, Albama, Olaska ...}
>
> > so what should be preferred way out of the following for storing the
> > values
>
> > 1. Keep the field as "string(Rails)" VARCHAR(MySQL) itself ....and
> > while showing the field just show the field value.
>
> > 2. Keep the field internally as a code like {:california =>
> > 01, :albama => 02, washington => 03 ....} but while showing the state
> > show only the corresponding state.
>
> > By using option 2, a certain disadvantage is extra computation time
> > required to find out corresponding state name based on code when
> > showing the state field to user. But an advantage could be in terms of
> > smaller database. In my opinion, saving 01 as an integer could save
> > significant space than storing "california" if number of records
> > happen to be in tens of thousands .
>
> > please suggest ??
>
> > vipin
>
> --
> ===============================================================================
> Tomas Meinlschmidt, MS {MCT, MCP+I, MCSE, AER}, NetApp Filer/NetCache
>
> www.meinlschmidt.com www.maxwellrender.cz www.lightgems.cz
> ===============================================================================
Thanks ! i will try this.
--~--~---------~--~----~------------~-------~--~----~
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 rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
