Re: [sqlite] Question about triggers

2007-06-28 Thread Nuno Lucas
On 6/29/07, Kees Nuyt <[EMAIL PROTECTED]> wrote: On Wed, 27 Jun 2007 20:42:18 -0400, you wrote: >1) Faster to do the timestamp in the sql statement, since it does not >require activation of the trigger. >2) Query looks 'cleaner', not having an explicit datetime() inside >3) Can switch the timesta

Re: [sqlite] Question about triggers

2007-06-28 Thread Kees Nuyt
On Wed, 27 Jun 2007 20:42:18 -0400, you wrote: >Hello all: >I was reading through a couple of sqlite tutorials and I noticed >examples of timestamping database entries by using triggers. I wanted >to ask people's opinion about using triggers to timestamp records in a >database. > >Which is 'b

[sqlite] Question about triggers

2007-06-27 Thread Rich Rattanni
Hello all: I was reading through a couple of sqlite tutorials and I noticed examples of timestamping database entries by using triggers. I wanted to ask people's opinion about using triggers to timestamp records in a database. Which is 'better': using a trigger to timestamp records or explici