Let's say I don't have more than one or two dozen objects with different properties, such as the following:
UID, Name, Value, Color, Type, Location
I want to be able to call up all objects with Location = "Boston", or Type = "Primary". Classic database query type stuff.
Most table solutions (pytables, *sql) are really overkill for such a small set of data. Should I simply iterate over all the objects and create a separate dictionary for each data column (adding values to dictionaries as I add new objects)?
This would create dicts like this:
{'Boston' : [234, 654, 234], 'Chicago' : [324, 765, 342] } - where those 3 digit entries represent things like UID's.
As you can see, querying this would be a bit of a pain.
Any thoughts of an alternative?