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
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 |