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
ssage- > From: sqlite-users-boun...@sqlite.org [mailto: > sqlite-users-boun...@sqlite.org] On Behalf Of Alberto Simões > Sent: Tuesday, September 15, 2009 4:38 AM > To: General Discussion of SQLite Database > Subject: [sqlite] Temporal SQLite database > > Dear SQLite users, > &

Re: [sqlite] Temporal SQLite database

2009-09-16 Thread Douglas E. Fajardo
extra code involved. *** Doug F. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Alberto Simões Sent: Tuesday, September 15, 2009 4:38 AM To: General Discussion of SQLite Database Subject: [sqlite] Temporal SQLite database D

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

[sqlite] Temporal SQLite database

2009-09-15 Thread Alberto Simões
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 number of non-leap seconds since