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

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

On Friday, May 2, 2014 10:38:51 AM UTC-5, Eddilbert Macharia wrote:

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.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/c248a378-6bc3-4dbd-b4d2-3133d236ce97%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.