Re: [sqlite] DB design questions

: "Michael Ruck" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, April 20, 2007 10:10 PM Subject: [sqlite] DB design questions Hello, I'm currently modelling and designing a new database according the following specifications. The general idea is the abil

Re: [sqlite] DB design questions

[EMAIL PROTECTED] wrote: Hello, I'm currently modelling and designing a new database according the following specifications. The general idea is the ability to store arbitrary objects, which have attributes of various kinds. The attributes themselves may be multivalued. The objects being

Re: [sqlite] DB design questions

By having "versioned attributes" do you mean the entire set of attributes is versioned as a group, or individually? Is it an object's state at a specific point in time that you want to version? --a On 4/20/07, Michael Ruck <[EMAIL PROTECTED]> wrote: Hello, I'm currently modelling and

[sqlite] DB design questions

Hello, I'm currently modelling and designing a new database according the following specifications. The general idea is the ability to store arbitrary objects, which have attributes of various kinds. The attributes themselves may be multivalued. The objects being stored need to be versioned, so

Re: [sqlite] DB design questions

We do something like that by storing the data in TEXT format and using RCS to handle versioning by its reverse delta method. It works well for storing notes and may be useful in your application. A function can return the appropriate version. Michael Ruck wrote: Hello, I'm currently