cbitstech / Purple-Robot

Sensing and automation platform for Android.
Other
38 stars 19 forks source link

Datatype of postgres backend for payloads could be JSONB #268

Open RichJackson opened 9 years ago

RichJackson commented 9 years ago

Since postgres 9.4, the data type JSONB is available to store JSON data. This is a binary format that is more efficient for querying and allows indexes to be built on such fields.

http://www.postgresql.org/docs/9.4/static/datatype-json.html

audaciouscode commented 9 years ago

Is there support for these field types in Django yet? I'm hesitant to go too far ahead of the framework.

audaciouscode commented 9 years ago

This might be worth investigating: https://github.com/djangonauts/django-pgjson