[thelist] Architecture for arbitrary data management

[kasimir-k]

Joe Flintham scribeva in 2008-02-29 13:39:
> Basically, I'm trying to design a system which can cope with storing a 
> fairly arbitrary set of key:value pairs, but which can quickly retrieve 
> subsets of them based on complex queries as in any RDBMS.

I'd approach it with something like this:

table items
- itemId
- userId
- timeAdded

table properties
- propertyId
- propertyName

table items_x_properties
- itemId
- propertyId
- propertyValue

.k