From: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Subject: | Re: My honours project - databases using dynamically attached entity-properties |
Date: | 2007-03-15 15:31:24 |
Message-ID: | 45F966CC.2050700@cheapcomplexdevices.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Josh Berkus wrote:
>> And then what? dynamically construct all your SQL queries?
>> Sure, sounds like a simple solution to me...
>
> Not to mention DB security issues. How do you secure your database when
> your web client has DDL access?
>
> So, Edward, the really *interesting* idea would be to come up with a
> secure, normalized way to do UDFs *without* EAV tables. People would be
> very impressed.
>
I have a system with many essentially user-defined fields, and was
thinking of creating something similar to an Array type and writing
some GIST indexes for it.
My current workaround is to store them as a YAML document and use
tsearch to index it (with application logic to further refine the
results) - but a EAV datatype that could be put in tables and
effectively indexed would be of quite a bit of interest here.
And yes, a better say to do UDFs would be even cooler.
From | Date | Subject | |
---|---|---|---|
Next Message | tomas | 2007-03-15 15:52:06 | Re: My honours project - databases using dynamically attached entity-properties |
Previous Message | Joshua D. Drake | 2007-03-15 15:30:53 | Re: [PATCHES] Bitmapscan changes |