Re: Schema design question
От | Ben |
---|---|
Тема | Re: Schema design question |
Дата | |
Msg-id | Pine.LNX.4.64.0803311053260.18595@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Schema design question ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>) |
Список | pgsql-general |
On Tue, 1 Apr 2008, Andrej Ricnik-Bay wrote: > On 29/03/2008, Ben <bench@silentmedia.com> wrote: >> I'm working on a project which requires me to keep track of objects, >> each of which can have an arbitrary number of attributes. Although >> there will be many attributes that an object can have, the data types >> of those attributes won't be all that varried (int, float, text, >> boolean, date, etc.). > > And a somewhat unorthodox suggestion for the list ... would it > be worthwhile considering a different storage mechanism all > together, like maybe an LDAP directory type of thing? The query > language is admittedly very limited. Hm.... worthwhile for some, perhaps, but not for this project. This is only a small part of a much larger whole, most of which fits quite well into SQL. Thanks though! I think I'm leaning towards the one-table-with-many-columns approach, as it seems to require the simpliest set of constraints while still giving me type-safety.
В списке pgsql-general по дате отправления: