> Simon Slavin wrote:
>
> On 6 Feb 2018, at 8:33am, Ulrich Telle wrote:
>
> > Another possibility would be to add a user-defined function for the
> > configuration of the extension that could be called from a SELECT
> > statement:
> >
> > SELECT myextension_config('param-name', 'param-value');
>
> I've seen this done before. Of course it means that your normal function is
> not deterministic, so you may no longer use SQLITE_DETERMINISTIC . This is
> in contrast to a function where parameters are set during compilation.
Well, actually my goal is not to have an extension with non-deterministic
functions. The parameters have mostly the purpose to initialize the extension
(things similar to what you do to SQLite itself with pragmas like "PRAGMA
cache_size", or "PRAGMA data_store_directory"). The extension would accept
changes to the parameters only before the first invocation of the extension
functions.
Regards,
Ulrich
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
