Difference between revisions of "Database Timelines"
From Recital Documentation Wiki
Barrymavin (Talk | contribs) (→Summary) |
Barrymavin (Talk | contribs) (→What are Database Timelines?) |
||
| Line 1: | Line 1: | ||
==Database Timelines== | ==Database Timelines== | ||
===What are Database Timelines?=== | ===What are Database Timelines?=== | ||
| + | |||
| + | Database timelines introduce row versioning to the Recital database engine. Whenever a change is made to a table that has timeline enabled then delta changes are automatically recorded for each transaction. | ||
| + | |||
| + | ===Using Database Timelines=== | ||
| + | |||
| + | To enable database timelines all you need to do is issue '''SET TIMELINE ON''' command in your Recital configuration file. | ||
| + | |||
| + | The '''CLEAR TIMELINE''' command will reset a timeline. | ||
| + | |||
| + | There are 2 ways to view a timeline. | ||
| + | |||
| + | * The '''LIST TIMELINE''' command | ||
| + | * The '''SELECT * FROM TIMELINE''' command | ||
Revision as of 01:32, 1 November 2009
Database Timelines
What are Database Timelines?
Database timelines introduce row versioning to the Recital database engine. Whenever a change is made to a table that has timeline enabled then delta changes are automatically recorded for each transaction.
Using Database Timelines
To enable database timelines all you need to do is issue SET TIMELINE ON command in your Recital configuration file.
The CLEAR TIMELINE command will reset a timeline.
There are 2 ways to view a timeline.
- The LIST TIMELINE command
- The SELECT * FROM TIMELINE command
