Re: Custom Fields Database Architecture
От
Greg Stark
Тема
Re: Custom Fields Database Architecture
Дата
Msg-id
407d949e0906160450h53579258g97391d2dde99c677@mail.gmail.com
Ответ на
Custom Fields Database Architecture (Gnanam)
Список
Дерево обсуждения
Custom Fields Database Architecture Gnanam <gnanam@zoniac.com>
Re: Custom Fields Database Architecture David Fetter <david@fetter.org>
Re: Custom Fields Database Architecture Stefan Keller <sfkeller@gmail.com>
Re: Custom Fields Database Architecture David Fetter <david@fetter.org>
Re: Custom Fields Database Architecture Sim Zacks <sim@compulab.co.il>
Re: Custom Fields Database Architecture Richard Broersma <richard.broersma@gmail.com>
Re: Custom Fields Database Architecture David Goodenough <david.goodenough@btconnect.com>
Re: Custom Fields Database Architecture Greg Stark <gsstark@mit.edu>
Re: Custom Fields Database Architecture David Fetter <david@fetter.org>
On Mon, Jun 15, 2009 at 2:04 PM, Gnanam wrote: > > I also read some article which talks about the type of patterns: > 1. Meta-database > 2. Mutating > 3. Fixed > 4. LOB > > My question here is, what is the best approach to define the architecture > for custom fields. Performance should not be compromised. The reason there are multiple patterns are because the best approach depends very much on the specifics of your needs. For all David's dogma there are use cases where EAV is the best fit. But there are downsides and if those downsides are a problem then one of the other patterns may be a better fit. -- greg http://mit.edu/~gsstark/resume.pdf
В списке pgsql-general по дате отправления
