SQLite Forum

Feature request: Stored Procedures
Login
With a proc you can do `INSERT`/`DELETE`/`UPDATE`/`SELECT` in any conceivable order to get the desired action and/or result.  You can't do that with triggers.  And even if you manage to figure out a way to do so for some specific case, in general it won't be possible or straight forward/readable.

Why pollute your schema with a whole bunch of funny named view-trigger combinations so you can remember which one to use when a simple concise proc can do the same.

Apparently, it's hard to reach a consensus that stored procedures are a good thing.

I guess there will always be two kinds of people; those who like simplicity and beauty, and those who enjoy programming as if in brainf@ck language :)