I have implemented a loadable SQLite extension. The behaviour of the
extension can be configured by setting various parameters. Currently I select
the parameter settings at compile time. However this is not very flexible. I
would like to be able to modify the parameters at runtime.
The most logical way would be to add extension-specific pragmas, but it
doesn't seem to be possible to intercept the pragma handling of SQLite
without modifying the SQLite source.
Another possibility would be to add a user-defined function for the
configuration of the extension that could be called from a SELECT
SELECT myextension_config('param-name', 'param-value');
Is there a better (or even recommended) way how to accomplish such
parameterization at runtime?
E-Mail privat: ulrich.te...@gmx.de
World Wide Web: http://www.telle-online.de
sqlite-users mailing list