Re: RFC: Preventing double-updates

[Shaun Laughey <..hidden..>]

> The use of session tables sounds like unnecessary overhead.
> 
> Ciao,
> 
> David A. Bandel

Hiya all,

I really like the idea of triggers. It sounds like it would involve a
lot less coding - which is nearly always a good thing. Plus it would
give a tighter integration to the logic in the db idea.

Sessions would be easier to implement though. There's already the
concept within the code for sessions.

However....

Any session based system I've used has the issue of stale sessions,
multiple sessions and browsers discovering 'old' sessions and using
them. 

The issue of timing out sessions is a tough one. There's one widely used
application still in use at VW and Toyota that logged everyone out at
12am every day when it cleared it's session table. Very annoying to late
night workers.

I have a feeling tightly coupling important business stuff to something
as flaky as a session would result in a world of pain.

Just my 2c. 

Shaun Laughey.