Andreas Fuchs <[EMAIL PROTECTED]> writes:
> On 2000-10-28, Tom Perrine <[EMAIL PROTECTED]> wrote:
> > If someone were to build such a PIB API, it seems that the hardest
> > part would be to support the current "invent a new field on the fly"
> > features.
>
> Nah, not at all. You could have a table that contains all notes field
> names (and an ID), and then have a table which contains all the field
> values. I had to do something like that once (only that the field could
> have any data type, but contained strings), and it was not very
> nontrivial. (-:
Modifying db schema is not trivial or elegant with any RDBMS that I've
ever heard of. Besides, adding a new field on the fly is easy with
the current bbdb implementation. Doing it with a RDBMS would be quite
difficult, and many RDBMS implementations have limitations on how you
can modify tables once they have been created. If we really wanted
the flexibility we should choose a non-relational database with more
schema flexibility, maybe Berkeley DB or something similar (maybe even
LDAP?)
Benjamin
_______________________________________________
bbdb-info mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/mailman/listinfo/bbdb-info
