which to use for dynamic data in the database eav or json

312 views
Skip to first unread message

Eddilbert Macharia

unread,
May 2, 2014, 3:38:51 PM5/2/14
to django...@googlegroups.com
Hi guys,

I have been trying to decide which approach to use to store dynamic data in the database i.e. data from a survey application in that a user creates there on form like in http://www.wufoo.com/.

Storing JSON has its limitation like searching while EAV is generally getting negative reviews from the online community sighting performance overhead in the queries.

For those who have actual done such an application which is better in the long run.

C. Kirby

unread,
May 2, 2014, 4:23:15 PM5/2/14
to django...@googlegroups.com
If you are using postgres as your data store (And I recommend you do) take a look at the hstore type:
http://www.postgresql.org/docs/9.0/static/hstore.html

There is a django app to help you work with hstore:
https://github.com/djangonauts/django-hstore

Here is a discussion by Craig Kerstiens about using hstore with django:
http://www.craigkerstiens.com/2012/06/11/schemaless-django/

Lastly, Marc Tamlyn is a django core contributor working on a Kickstarter to add more postgres support to django:
https://www.kickstarter.com/projects/mjtamlyn/improved-postgresql-support-in-django

Hope this helps some.

Kirby

Eddilbert Macharia

unread,
May 2, 2014, 4:57:40 PM5/2/14
to django...@googlegroups.com
Hello Kirby,

thanks for the assist.

I had actually checked at this posts, I was wondering if i was to use the hstore or json and eav which in the long run would cause less maintaince issues for a data collection system where users create their own forms to collect data.

Regards.

Eddilbert
Reply all
Reply to author
Forward
0 new messages