maybe Virtual tables? can register functions of various types... mostly since the typical usage of sqlite is as a tightly coupled library, a function in your application is a 'stored procedure'.
http://www.sqlite.org/c3ref/update_hook.html There are hooks which would trigger callbacks like triggers... to fake an exec you'd have to use like 'select sp_myProc(...)' instead of 'execute' On Tue, May 8, 2018 at 1:58 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 5/8/2018 4:02 PM, Mike Clark wrote: > >> Has there been any thought of implementing some kind of stored procedure >> feature for SQLite? >> >> Or does this feature exist in some other form, with another name? >> > > Triggers are kind of like stored procedures. You can create a dedicated > view and put INSTEAD OF trigger on it. To "call" the trigger, insert a row > into the view - the trigger could use column values, available via > new.columnName, as its parameters. > -- > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
