Re: Stroring html form settings

From: Dianne Yumul <dianne(at)wellsgaming(dot)com>
To: PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Stroring html form settings
Date: 2008-09-26 17:24:12
Message-ID: CD91E87E-4E5D-4F56-8A96-FE0A15E437A5@wellsgaming.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Would an EAV model work? I'm thinking something like
> <form,field,value>. For example:
> formA,ckbox1,true
> formA,input1,initial value
> formB,textarea1,enter your long comment here
>
> You could easily extend this to <user,form,field,value>, or
> normalize it as you see fit.

This would work great too. If we go this route, we'll keep it simple
and use the <user_id, report_id, field, value>, as you suggested,
where user_id and report_id are foreign key references.

> Another possibility is to use hstore hashes for form fields/values.
> See
> http://www.postgresql.org/docs/8.3/static/hstore.html

I will look into this too. But we'll have to upgrade to 8.3 which is
not a problem.

Thank you Reece.

Dianne

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jonah H. Harris 2008-09-26 17:47:16 Re: PostgreSQL future ideas
Previous Message furlani.francesco 2008-09-26 17:17:06 Slony Problem