Serializing Symbols in Table?

Hi everyone,

I’m planning an application that I’m going to be working on where I’ll
have a number of Users and I’ll need to store the user’s current
position on a governing board (if he/she has a position) and also all
past positions that the user has held. There are only a handful of
positions so I was thinking of making the positions symbols and storing
the current position as either a nil value or the symbol if the user
holds the position (and there is only one person per position at a time)
and a serialized list of the positions that each user has held in the
past. Does this make sense or is there a better way to do this? Also,
would I make my column types as binary types or INTS? I’m not sure what
a symbol should be represented by.

Also, on a related note, each user might/might not want all of his/her
information public, is it a good idea to have a seperate column for
every possible hidden value which represents a boolean indicating if
that value should be shown? (E.g. for columns email_address, phone, etc
there would be email_address_public phone_public, etc.)

Thanks everyone!
Matt

Anyone have any ideas?

Thanks!

matt jacobs wrote:

Hi everyone,

I’m planning an application that I’m going to be working on where I’ll
have a number of Users and I’ll need to store the user’s current
position on a governing board (if he/she has a position) and also all
past positions that the user has held. There are only a handful of
positions so I was thinking of making the positions symbols and storing
the current position as either a nil value or the symbol if the user
holds the position (and there is only one person per position at a time)
and a serialized list of the positions that each user has held in the
past. Does this make sense or is there a better way to do this? Also,
would I make my column types as binary types or INTS? I’m not sure what
a symbol should be represented by.

Also, on a related note, each user might/might not want all of his/her
information public, is it a good idea to have a seperate column for
every possible hidden value which represents a boolean indicating if
that value should be shown? (E.g. for columns email_address, phone, etc
there would be email_address_public phone_public, etc.)

Thanks everyone!
Matt

store them as strings and enjoy all the headaches you won’t be having.
:slight_smile:

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs