I need to store json objects on the google cloud platform. I have considered a number of options:
- Store them in a bucket as a text (.json) file.
- Store them as text in datastore using json.dumps(obj).
- Unpack it into a hierarchy of objects in datastore.
Option 1: Rejected because it has no organising principles other than the filename and cannot be searched across.
Option 2: Is easy to implement, but you cannot search using dql.
Option 3: Got it to work after a lot of wrangling with the key and parent key structures. While it is searchable, the resulting objects have been split up and held together by the parent key relationships. It is really ugly!
Is there any way to store and search across a deeply structured json object on the google cloud platform - other than to set up mongodb in a compute instance?
