How do I put a dictionary in the datastore?

Question

Is there a good way to store a Python dictionary in the datastore? I want to do something like the following:

from google.appengine.ext import db

class Recipe(db.Model):
  name = db.StringProperty()
  style = db.StringProperty()
  yeast = db.StringProperty()
  hops = db.ListofDictionariesProperty()

Of course, that last line doesn't actually work. I need hops to be a list of key-value pairs, where the key is always a string and the value can be a string, int, or float, but I can't see anything in that would allow me to do that in the Property classes.

Answer 1

You could pickle the dictionary and store it as a StringProperty.

Answer 2

Serializing a dict with repr is a good way to do it. You can then reconstitute it with eval, or if you don't trust the data, a "safe eval".

An advantage of repr over pickling is that the data is readable in the database, even queryable in desperate cases.

Answer 3

I'm pretty sure there's no way to store a Python dictionary. But why not just place what you'd like in hops as a second model?

Also, as mentioned by John you could use pickle, but (and correct me if I'm wrong) store it as a Blob value instead.

Answer 4

Your options are basically to use pickle, to use a db.Expando and make each key in the dict a separate property, or to have a StringListProperty of keys and one of values and zip() them back to a dict when reading.

Answer 5

You can use json