|
Thanks for the quick replies Sean and Alexander. One of our current
products allows users to sign up for weather alerts based on their zip
code. When we receive a weather alert for a set of locations, we need
to quickly find all users in the zip codes effected. We currently do
this with a simple sql query against a relational db. Being new at
this key/value store thing, we are not sure the best way to tackle this
with Riak. Some zip codes have over 20,000 users, so storing the users in a json array with the zip code as the key would get ugly fast. One thought was to store the user profiles in one bucket, and then add an key per user in the correct zip code bucket, perhaps with a link back to the users record in the profile bucket. We could then fetch the keys for the effected zip codes using map reduce. I am open to all suggestions on how to best model this type of data in Riak. Thanks, Scott Sean Cribbs wrote: Scott, |
_______________________________________________ riak-users mailing list [email protected] http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com
