Not quite the same issue, but I've set up triggers to generate a journal
record whenever a record is added/changed/deleted from a table. This
mechanism (triggers) could easily be used to generate a 'version' record.
*** Doug F.
John Stanton wrote:
> We perform some versioning by holding column
We perform some versioning by holding column material in XML and using
RCS to maintain reverse deltas and versions.
Samuel R. Neff wrote:
Not specific to SQLite, but we're working on an app that needs to keep
versioned data (i.e., the current values plus all previous values). The
versioning
Not specific to SQLite, but we're working on an app that needs to keep
versioned data (i.e., the current values plus all previous values). The
versioning is integral to the app so it's more than just an audit trail or
history.
Can anyone share experiences with the database structure for this
3 matches
Mail list logo