relational type operation on key value storage
- by wayne
in my objects table i have
id | type | parent | order | created
and then in my data table i have
object_id | key | value
i want to get object of type 'x' where key 'y' === 'z' in the most optimal way possible.
ie. get user where slug === 'jonny'
i'm currently doing it with joins, because i'm doing this in mysql as a quick test. but i'll be moving to redis or a similar key/value storage system so obviously that won't work.