I recently step over a problem where recursive triggers are really helpfull, and realized that my idea for propagating changes along a tree structure won't work without recursive triggers obviously.
In short, I think the server sql engines implement recursion limits because they are mulit-user. So, if one creates accidentally an endless loop, the whole server must not be taken down(at least no db-admin must be called...) and the other applications can continue. There are other ways for DOS, of course, too. Mostly, I think, a sqlite db-file is not shared between different users, so *this* problem of endless recursive triggers ist not present often. thanks for this nice pice of software, lothar