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

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 -

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 abo

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

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 revie