[katello-devel] key-value pairs for objects in katello db

[Ohad Levy]

On 08/15/2012 04:34 PM, Ivan Nečas wrote:
> On 08/15/2012 03:26 PM, Tom McKay wrote:
>> One of the design tasks for this sprint is to come up with a way to
>> associate key-value pairs to systems and subscriptions. This would be
>> similar to the system facts that exist. It would be nice to allow
>> these pairs to exist on other objects now or in the future as well
>> (eg. activation keys).
>>
>> Question: What is the best way to model this in the katello db? Joins
>> or something?
> We have already this in User model: see
>
>     serialize :preferences
>
> this serializes this parameters into blob transparently.
>
when you serialize you lose a few things

1. the ability to join
2. the ability to filter in sql (you have to load it all, decode it and 
do in memory search)..


Ohad
> -- Ivan
>>
>> _______________________________________________
>> katello-devel mailing list
>> katello-devel at redhat.com
>> https://www.redhat.com/mailman/listinfo/katello-devel
>
>