Re: [sqlite] Temporal SQLite database

2009-09-16 Thread Jean-Christophe Deschamps
Doug, At 19:47 15/09/2009, you wrote: ´¯¯¯ >I'm not sure if you are looking to make a entry unique, or determine >the order in which the entries occurred. In either case, be aware - >time can go *backwards* on a system, especially if it is being syncd >to an outside source such as with NTP. > >

Re: [sqlite] Temporal SQLite database

2009-09-16 Thread Alberto Simões
Hello, Doug Thanks for your message. That helped a lot. ambs On Tue, Sep 15, 2009 at 6:47 PM, Douglas E. Fajardo < dfaja...@beyondtrust.com> wrote: > I'm not sure if you are looking to make a entry unique, or determine the > order in which the entries occurred. In either case, be aware - time ca

Re: [sqlite] Temporal SQLite database

2009-09-16 Thread Douglas E. Fajardo
I'm not sure if you are looking to make a entry unique, or determine the order in which the entries occurred. In either case, be aware - time can go *backwards* on a system, especially if it is being syncd to an outside source such as with NTP. Normally the 'jitter' is under a second, but excep

Re: [sqlite] Temporal SQLite database

2009-09-15 Thread Darren Duncan
Alberto Simões wrote: > Dear SQLite users, > > I am preparing a temporal database. Basically, entries will have a compound > key composed by the real key and some kind of time stamp. This is not > complicated to do, but I would like to know if anybody did something similar > and if: > - used the