Re: [sqlite] Temporal SQLite database

2009-09-16 Thread Douglas E. Fajardo
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 Dear SQLite users

Re: [sqlite] Temporal SQLite database

2009-09-16 Thread Alberto Simões
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, I am preparing a temporal database. Basically, entries will have a compound key composed by the real key and some kind of time stamp

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.

[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

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 number