[thelist] Architecture for arbitrary data management

kasimir-k kasimir.k.lists at gmail.com
Fri Feb 29 08:21:40 CST 2008

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


More information about the thelist mailing list