[sqlite] stored procedures

[Puneet Kishor]

searching on the 'net reveals that SQLite3 doesn't support storedprocs, 
but they could be somewhat emulated via TRIGGERs. Is there a tutorial 
on doing so? I want to wrap multiple, but logically single, SELECTs, 
UPDATEs, INSERTs, and DELETEs into one db call.

preamble question -- is there a perf advantage to "creating" a 
storedproc in SQLite? Does it pre-compile the storedproc? If there 
isn't any perf advantage, I'd rather not even bother.


--
Puneet Kishor